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 5120: FROM mtl_transactions_interface mti

5116: SET lot_expiration_date =
5117: fnd_date.canonical_to_date (l_lotexpdate)
5118: WHERE transaction_interface_id IN (
5119: SELECT transaction_interface_id
5120: FROM mtl_transactions_interface mti
5121: WHERE mti.parent_id = p_parent_id
5122: AND mti.transaction_interface_id =
5123: mtli.transaction_interface_id);
5124: EXCEPTION

Line 5185: FROM mtl_transactions_interface mti

5181: SET lot_expiration_date =
5182: fnd_date.canonical_to_date (l_lotexpdate)
5183: WHERE transaction_interface_id IN (
5184: SELECT transaction_interface_id
5185: FROM mtl_transactions_interface mti
5186: WHERE mti.parent_id = p_parent_id
5187: AND mti.parent_id = mti.transaction_interface_id
5188: AND mti.transaction_interface_id =
5189: mtli.transaction_interface_id);

Line 5240: FROM mtl_transactions_interface mti

5236: SET lot_expiration_date =
5237: fnd_date.canonical_to_date (l_lotexpdate)
5238: WHERE transaction_interface_id IN (
5239: SELECT transaction_interface_id
5240: FROM mtl_transactions_interface mti
5241: WHERE mti.parent_id = p_parent_id
5242: AND mti.transaction_interface_id =
5243: mtli.transaction_interface_id);
5244: EXCEPTION

Line 5311: FROM mtl_transactions_interface mti

5307: SET lot_expiration_date =
5308: fnd_date.canonical_to_date (l_lotexpdate)
5309: WHERE transaction_interface_id IN (
5310: SELECT transaction_interface_id
5311: FROM mtl_transactions_interface mti
5312: WHERE mti.parent_id = p_parent_id
5313: AND mti.transaction_interface_id =
5314: mtli.transaction_interface_id
5315: AND mtli.lot_expiration_date IS NULL);

Line 5400: FROM mtl_transactions_interface mti

5396: SET lot_expiration_date =
5397: fnd_date.canonical_to_date (l_lotexpdate)
5398: WHERE transaction_interface_id IN (
5399: SELECT transaction_interface_id
5400: FROM mtl_transactions_interface mti
5401: WHERE mti.parent_id = p_parent_id
5402: AND mti.parent_id = mti.transaction_interface_id
5403: AND mti.transaction_interface_id =
5404: mtli.transaction_interface_id);

Line 5460: FROM mtl_transactions_interface mti

5456: SET lot_expiration_date =
5457: fnd_date.canonical_to_date (l_lotexpdate)
5458: WHERE transaction_interface_id IN (
5459: SELECT transaction_interface_id
5460: FROM mtl_transactions_interface mti
5461: WHERE mti.parent_id = p_parent_id
5462: AND mti.transaction_interface_id =
5463: mtli.transaction_interface_id
5464: AND mtli.lot_expiration_date IS NULL);