eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_CPLPROC_PRIV dependencies on MTL_TRANSACTIONS_INTERFACE

Line 1022: from mtl_transactions_interface

1018: primary_quantity priQty,
1019: transaction_quantity txnQty,
1020: overcompletion_primary_qty,
1021: organization_id
1022: from mtl_transactions_interface
1023: where completion_transaction_id = p_cplTxnID
1024: and transaction_header_id = p_txnHdrID
1025: and transaction_source_id = p_wipEntityID
1026: and transaction_source_type_id = 5

Line 1513: from mtl_transactions_interface mti

1509: sysdate,
1510: mti.transaction_quantity,
1511: mti.primary_quantity,
1512: mti.transaction_date
1513: from mtl_transactions_interface mti
1514: where mti.transaction_header_id = p_txnHdrID
1515: and mti.completion_transaction_id = p_cplTxnID
1516: and mti.transaction_action_id = wip_constants.retassy_action;
1517: end if;

Line 1753: mtl_transactions_interface mti

1749:
1750: SELECT COUNT(1)
1751: INTO l_mti_lot_rec
1752: FROM mtl_transaction_lots_interface mtli,
1753: mtl_transactions_interface mti
1754: WHERE mtli.transaction_interface_id = mti.transaction_interface_id
1755: AND mti.transaction_header_id = p_mtl_header_id
1756: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1757: and MTI.TRANSACTION_TYPE_ID in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)

Line 1766: FROM mtl_transactions_interface mti,

1762:
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

Line 1782: FROM mtl_transactions_interface mti,

1778: AND mln.inventory_item_id = mti.inventory_item_id
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

Line 1812: FROM mtl_transactions_interface mti,

1808: oracle error 1427. See bugs 866408 and 938422. */
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)

Line 1828: FROM mtl_transactions_interface mti,

1824: mti.transaction_interface_id)
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