sql query to qlik script cpnvert

Gaurav_Kapoor — Tue, 20 Sep 2022 06:39:02 GMT

Hi I want to convert this Oracle script into Qliksense Script .

Can anyone able to decode this script into qliksense?

SELECT
XX.P_DATE,
XX.ORGANIZATION_ID,
XX.ITEM_ID,
XX.ITEM_CODE,
XX.DESCRP,
XX.UOM,
,
XX.SUBINVENTORY_CODE,
XX.TRANSACTION_QUANTITY,
XX.CATEGORY1,
XX.CATEGORY2,
XX.CATEGORY3,
round
(
XX.TRANSACTION_QUANTITY * XX.CF_ITEM_COST_AS_ON,
2
) "CF_TOTAL_VALUE",
XX.CF_ITEM_COST_AS_ON,
XXX_CF_QUANTITY_0_30(
XX.ORGANIZATION_ID, XX.ITEM_ID, SYSDATE,
XX.SUBINVENTORY_CODE, XX.TRANSACTION_QUANTITY
) "CF_QUANTITY_0_30",
XX_CF_Quantity_31_60(
XX.ORGANIZATION_ID, XX.ITEM_ID, SYSDATE,
XX.SUBINVENTORY_CODE, XX.TRANSACTION_QUANTITY
) "CF_QUANTITY_31_60",
XX_CF_Quantity_61_90(
XX.ORGANIZATION_ID, XX.ITEM_ID, SYSDATE,
XX.SUBINVENTORY_CODE, XX.TRANSACTION_QUANTITY
) "CF_QUANTITY_61_90",
XX_CF_Quantity_91_120(
XX.ORGANIZATION_ID, XX.ITEM_ID, SYSDATE,
XX.SUBINVENTORY_CODE, XX.TRANSACTION_QUANTITY
) "CF_QUANTITY_91_120",
XX_CF_Quantity_121_150(
XX.ORGANIZATION_ID, XX.ITEM_ID, SYSDATE,
XX.SUBINVENTORY_CODE, XX.TRANSACTION_QUANTITY
) "CF_QUANTITY_121_150",
XX_CF_Quantity_151_180(
XX.ORGANIZATION_ID, XX.ITEM_ID, SYSDATE,
XX.SUBINVENTORY_CODE, XX.TRANSACTION_QUANTITY
) "CF_QUANTITY_151_180",
XX_CF_Quantity_181_360(
XX.ORGANIZATION_ID, XX.ITEM_ID, SYSDATE,
XX.SUBINVENTORY_CODE, XX.TRANSACTION_QUANTITY
) "CF_QUANTITY_181_360",
XX_CF_Quantity_361_720(
XX.ORGANIZATION_ID, XX.ITEM_ID, SYSDATE,
XX.SUBINVENTORY_CODE, XX.TRANSACTION_QUANTITY
) "CF_QUANTITY_361_720",
XX_CF_qty_720_onwards(
XX.ORGANIZATION_ID, XX.ITEM_ID, SYSDATE,
XX.SUBINVENTORY_CODE, XX.TRANSACTION_QUANTITY
) "CF_QUANTITY_720_ONWARDS",
XX_CF__VALUE_0_30(
XX.ORGANIZATION_ID, XX.ITEM_ID, SYSDATE,
XX.SUBINVENTORY_CODE, XX.TRANSACTION_QUANTITY,
XX.CF_ITEM_COST_AS_ON
) "CF__VALUE_0_30",
XX_CF_VALUE_31_60(
XX.ORGANIZATION_ID, XX.ITEM_ID, SYSDATE,
XX.SUBINVENTORY_CODE, XX.TRANSACTION_QUANTITY,
XX.CF_ITEM_COST_AS_ON
) "CF_VALUE_31_60",
XX_CF__VALUE_61_90(
XX.ORGANIZATION_ID, XX.ITEM_ID, SYSDATE,
XX.SUBINVENTORY_CODE, XX.TRANSACTION_QUANTITY,
XX.CF_ITEM_COST_AS_ON
) "CF__VALUE_61_90",
XX_CF_VALUE_91_120(
XX.ORGANIZATION_ID, XX.ITEM_ID, SYSDATE,
XX.SUBINVENTORY_CODE, XX.TRANSACTION_QUANTITY,
XX.CF_ITEM_COST_AS_ON
) "CF_VALUE_91_120",
XX_CF_VALUE_121_150(
XX.ORGANIZATION_ID, XX.ITEM_ID, SYSDATE,
XX.SUBINVENTORY_CODE, XX.TRANSACTION_QUANTITY,
XX.CF_ITEM_COST_AS_ON
) "CF_VALUE_121_150",
XX_CF_VALUE_151_180(
XX.ORGANIZATION_ID, XX.ITEM_ID, SYSDATE,
XX.SUBINVENTORY_CODE, XX.TRANSACTION_QUANTITY,
XX.CF_ITEM_COST_AS_ON
) "CF_VALUE_151_180",
XX_CF_VALUE_181_360(
XX.ORGANIZATION_ID, XX.ITEM_ID, SYSDATE,
XX.SUBINVENTORY_CODE, XX.TRANSACTION_QUANTITY,
XX.CF_ITEM_COST_AS_ON
) "CF_VALUE_181_360",
XX_CF_VALUE_720_ONWARDS(
XX.ORGANIZATION_ID, XX.ITEM_ID, SYSDATE,
XX.SUBINVENTORY_CODE, XX.TRANSACTION_QUANTITY,
XX.CF_ITEM_COST_AS_ON
) "CF_VALUE_720_ONWARDS"
FROM
(
SELECT
: P_DATE P_DATE,
A.ORGANIZATION_ID ORGANIZATION_ID,
A.INVENTORY_ITEM_ID ITEM_ID,
A.SEGMENT1 ITEM_CODE,
A.DESCRIPTION DESCRP,
A.PRIMARY_UNIT_OF_MEASURE UOM,
ROUND (ITEM_COST, 2) ITEM_COST,
APPS.XXMTL_ONHAND_SUB (
A.ORGANIZATION_ID, A.INVENTORY_ITEM_ID,
: P_DATE, 'SUB_INV', : SUBINVENTORY_CODE1
) SUBINVENTORY_CODE,
NVL (
APPS.XXMTL_ONHAND_SUB (
A.ORGANIZATION_ID, A.INVENTORY_ITEM_ID,
: P_DATE, 'SUB_QTY', : SUBINVENTORY_CODE1
),
0
) TRANSACTION_QUANTITY,
MCK.SEGMENT1 CATEGORY1,
MCK.SEGMENT2 CATEGORY2,
MCK.SEGMENT3 CATEGORY3,
TO_NUMBER(
XXCF_ITEM_COST_AS_ON(
A.ORGANIZATION_ID,
ROUND (ITEM_COST, 2),
: P_DATE,
A.INVENTORY_ITEM_ID
)
) "CF_ITEM_COST_AS_ON"
FROM
MTL_SYSTEM_ITEMS_B A,
CST_ITEM_COSTS B,
MTL_CATEGORIES_KFV MCK,
MTL_ITEM_CATEGORIES MIC
WHERE
1 = 1
AND A.ORGANIZATION_ID = NVL(
: P_ORGANIZATION_ID, A.ORGANIZATION_ID
)
AND A.ORGANIZATION_ID = B.ORGANIZATION_ID
AND A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
AND A.INVENTORY_ITEM_ID = NVL(
: P_INVENTORY_ITEM_ID, A.INVENTORY_ITEM_ID
)
AND A.SERIAL_NUMBER_CONTROL_CODE = NVL (
: P_SERIAL_CONTROL, A.SERIAL_NUMBER_CONTROL_CODE
)
AND : P_DATE = : P_DATE
AND A.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND A.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND MIC.CATEGORY_ID = MCK.CATEGORY_ID
) XX

topic sql query to qlik script cpnvert in Connectivity & Data Prep

sql query to qlik script cpnvert