inventory.sql

Source: DMF/PuC/AIF/DR1 scripts/inventory.sql

-- INVENTORY --
 
-- 1. Insert from TMP (ORI_INVENTORY_TMP) into STG (ORI_INVENTORY_STG) table:
 
INSERT INTO ORI_INVENTORY_STG(ITEM
                             ,ORG_NUM
                             ,DAY_DT
                             ,CLEARANCE_FLG
                             ,INV_SOH_QTY
                             ,INV_SOH_COST_AMT_LCL
                             ,INV_SOH_RTL_AMT_LCL
                             ,INV_UNIT_RTL_AMT_LCL
                             ,INV_AVG_COST_AMT_LCL
                             ,DOC_CURR_CODE
                             ,LOC_CURR_CODE
							 ,CREATE_ID
							 ,CREATE_DATETIME
							 ,CTRL_STATUS)
SELECT t.ITEM
      ,t.ORG_NUM
      ,to_date(TO_CHAR(t.DAY_DT, 'YYYYMMDD'),'YYYYMMDD')
      ,t.CLEARANCE_FLG
      ,t.INV_SOH_QTY
      ,t.INV_SOH_COST_AMT_LCL
      ,t.INV_SOH_RTL_AMT_LCL
      ,t.INV_UNIT_RTL_AMT_LCL
      ,t.INV_AVG_COST_AMT_LCL
      ,t.DOC_CURR_CODE
      ,'EUR'
	  ,USER
	  ,SYSDATE
	  ,'N'
 FROM ORI_INVENTORY_TMP t;
 
-- 2. Insert from STG (ORI_INVENTORY_STG) into CTRL (ORI_INVENTORY_CTRL) table:
 
BEGIN
    PCK_MIGR_GEN.GEN_LOAD_CTRL_TABLES (P_table_name => 'ORI_INVENTORY');
END;
/
 
BEGIN
    LOAD_CTRL_TABLES;
END;
/
 
-- 3. Export inventory.csv
 
python oracleExport_inventory.py