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.INV_LOT_TRX_VALIDATION_PUB dependencies on MTL_TRANSACTIONS_INTERFACE

Line 5091: FROM mtl_transactions_interface mti

5087: SET lot_expiration_date =
5088: fnd_date.canonical_to_date (l_lotexpdate)
5089: WHERE transaction_interface_id IN (
5090: SELECT transaction_interface_id
5091: FROM mtl_transactions_interface mti
5092: WHERE mti.parent_id = p_parent_id
5093: AND mti.transaction_interface_id =
5094: mtli.transaction_interface_id);
5095: EXCEPTION

Line 5156: FROM mtl_transactions_interface mti

5152: SET lot_expiration_date =
5153: fnd_date.canonical_to_date (l_lotexpdate)
5154: WHERE transaction_interface_id IN (
5155: SELECT transaction_interface_id
5156: FROM mtl_transactions_interface mti
5157: WHERE mti.parent_id = p_parent_id
5158: AND mti.parent_id = mti.transaction_interface_id
5159: AND mti.transaction_interface_id =
5160: mtli.transaction_interface_id);

Line 5211: FROM mtl_transactions_interface mti

5207: SET lot_expiration_date =
5208: fnd_date.canonical_to_date (l_lotexpdate)
5209: WHERE transaction_interface_id IN (
5210: SELECT transaction_interface_id
5211: FROM mtl_transactions_interface mti
5212: WHERE mti.parent_id = p_parent_id
5213: AND mti.transaction_interface_id =
5214: mtli.transaction_interface_id);
5215: EXCEPTION

Line 5282: FROM mtl_transactions_interface mti

5278: SET lot_expiration_date =
5279: fnd_date.canonical_to_date (l_lotexpdate)
5280: WHERE transaction_interface_id IN (
5281: SELECT transaction_interface_id
5282: FROM mtl_transactions_interface mti
5283: WHERE mti.parent_id = p_parent_id
5284: AND mti.transaction_interface_id =
5285: mtli.transaction_interface_id
5286: AND mtli.lot_expiration_date IS NULL);

Line 5371: FROM mtl_transactions_interface mti

5367: SET lot_expiration_date =
5368: fnd_date.canonical_to_date (l_lotexpdate)
5369: WHERE transaction_interface_id IN (
5370: SELECT transaction_interface_id
5371: FROM mtl_transactions_interface mti
5372: WHERE mti.parent_id = p_parent_id
5373: AND mti.parent_id = mti.transaction_interface_id
5374: AND mti.transaction_interface_id =
5375: mtli.transaction_interface_id);

Line 5431: FROM mtl_transactions_interface mti

5427: SET lot_expiration_date =
5428: fnd_date.canonical_to_date (l_lotexpdate)
5429: WHERE transaction_interface_id IN (
5430: SELECT transaction_interface_id
5431: FROM mtl_transactions_interface mti
5432: WHERE mti.parent_id = p_parent_id
5433: AND mti.transaction_interface_id =
5434: mtli.transaction_interface_id
5435: AND mtli.lot_expiration_date IS NULL);