DBA Data[Home] [Help]

APPS.DDR_BASE_UTIL_PKG dependencies on DDR_E_MFG_SHIP_ITEM

Line 1635: INSERT INTO DDR_E_MFG_SHIP_ITEM

1631: BEGIN
1632: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
1633:
1634:
1635: INSERT INTO DDR_E_MFG_SHIP_ITEM
1636: (REC_ID, LOAD_ID, ERR_REASON,
1637: BSNS_UNIT_CD, MFG_SKU_ITEM_NBR,
1638: UOM,SHIP_QTY, SHIP_AMT, SRC_SYS_IDNT,
1639: SRC_SYS_DT, SRC_IDNT_FLAG, ACTION_FLAG, TRANS_DT,

Line 1682: FROM DDR_E_MFG_SHIP_ITEM

1678: BSNS_UNIT_CD,
1679: MFG_SKU_ITEM_NBR,
1680: TRANS_DT, SHIP_TO_ORG_CD,
1681: SHIP_TO_BSNS_UNIT_CD
1682: FROM DDR_E_MFG_SHIP_ITEM
1683: GROUP BY
1684: BSNS_UNIT_CD,
1685: MFG_SKU_ITEM_NBR,
1686: TRANS_DT, SHIP_TO_ORG_CD,

Line 1720: INSERT INTO ddr_e_mfg_ship_item

1716:
1717: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
1718:
1719: FOR rec IN c1 LOOP --{
1720: INSERT INTO ddr_e_mfg_ship_item
1721: (crncy_cd
1722: ,day_cd
1723: ,load_id
1724: ,mfg_sku_item_id