APPS.DDR_BASE_UTIL_PKG dependencies on DDR_I_MFG_SHIP_ITEM

Line 1647: FROM DDR_I_MFG_SHIP_ITEM

1643: BSNS_UNIT_CD, MFG_SKU_ITEM_NBR,
1644: UOM,SHIP_QTY, SHIP_AMT, SRC_SYS_IDNT,
1645: SRC_SYS_DT,'I','N', TRANS_DT,
1646: SHIP_TO_ORG_CD, SHIP_TO_BSNS_UNIT_CD, SHIP_COST
1647: FROM DDR_I_MFG_SHIP_ITEM
1648: WHERE
1649: (BSNS_UNIT_CD,
1650: MFG_SKU_ITEM_NBR,
1651: TRANS_DT, SHIP_TO_ORG_CD,

Line 1659: FROM DDR_I_MFG_SHIP_ITEM

1655: BSNS_UNIT_CD,
1656: MFG_SKU_ITEM_NBR,
1657: TRANS_DT, SHIP_TO_ORG_CD,
1658: SHIP_TO_BSNS_UNIT_CD
1659: FROM DDR_I_MFG_SHIP_ITEM
1660: GROUP BY
1661: BSNS_UNIT_CD,
1662: MFG_SKU_ITEM_NBR,
1663: TRANS_DT, SHIP_TO_ORG_CD,

Line 1670: DELETE FROM DDR_I_MFG_SHIP_ITEM

1666: COMMIT;
1667:
1668: -- DELETE DUPLICATE RECORDS FROM INTERFACE TABLE --
1669:
1670: DELETE FROM DDR_I_MFG_SHIP_ITEM
1671: WHERE
1672: (BSNS_UNIT_CD,
1673: MFG_SKU_ITEM_NBR,
1674: TRANS_DT, SHIP_TO_ORG_CD,