APPS.WIP_CPLPROC_PRIV dependencies on MTL_SYSTEM_ITEMS

Line 1767: mtl_system_items msi,

1763: UPDATE mtl_transaction_lots_interface mtli
1764: SET lot_expiration_date =
1765: (SELECT MIN(mln.expiration_date)
1766: FROM mtl_transactions_interface mti,
1767: mtl_system_items msi,
1768: mtl_lot_numbers mln
1769: WHERE mti.organization_id = msi.organization_id
1770: AND mti.inventory_item_id = msi.inventory_item_id
1771: AND mti.transaction_header_id = p_mtl_header_id

Line 1783: mtl_system_items msi

1779: AND mln.organization_id = mti.organization_id)
1780: WHERE mtli.transaction_interface_id IN
1781: (SELECT mti.transaction_interface_id
1782: FROM mtl_transactions_interface mti,
1783: mtl_system_items msi
1784: WHERE mti.organization_id = msi.organization_id
1785: AND mti.inventory_item_id = msi.inventory_item_id
1786: AND mti.transaction_header_id = p_mtl_header_id
1787: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)

Line 1813: mtl_system_items msi

1809: UPDATE mtl_transaction_lots_interface mtli
1810: SET lot_expiration_date =
1811: (SELECT mti.transaction_date + NVL(msi.shelf_life_days,0)
1812: FROM mtl_transactions_interface mti,
1813: mtl_system_items msi
1814: WHERE mti.transaction_header_id =p_mtl_header_id
1815: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1816: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1817: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED

Line 1829: mtl_system_items msi

1825: WHERE mtli.lot_expiration_date IS NULL
1826: AND mtli.transaction_interface_id IN
1827: (SELECT mti.transaction_interface_id
1828: FROM mtl_transactions_interface mti,
1829: mtl_system_items msi
1830: WHERE mti.organization_id = msi.organization_id
1831: AND mti.inventory_item_id = msi.inventory_item_id
1832: AND mti.transaction_header_id = p_mtl_header_id
1833: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)