DBA Data[Home] [Help]

APPS.CSI_UTL_PKG dependencies on MTL_UNIT_TRANSACTIONS

Line 7474: mtl_material_transactions mmt,mtl_unit_transactions mut

7470:
7471: SELECT 1 INTO l_lot_ctrl_code FROM dual WHERE (--condition
7472: EXISTS
7473: (SELECT * FROM
7474: mtl_material_transactions mmt,mtl_unit_transactions mut
7475: where mut.transaction_id(+) = mmt.transaction_id
7476: AND mmt.transaction_id = p_transaction_id
7477: )
7478: AND

Line 7484: mtln,mtl_unit_transactions mut where

7480: (
7481:
7482: SELECT * FROM
7483: mtl_material_transactions mmt, mtl_transaction_lot_numbers
7484: mtln,mtl_unit_transactions mut where
7485: mut.transaction_id(+) = mtln.serial_transaction_id
7486: and
7487: mtln.transaction_id = mmt.transaction_id
7488: AND mmt.transaction_id = p_transaction_id

Line 7512: mtln,mtl_unit_transactions mut where

7508: (--condition
7509:
7510: SELECT * FROM
7511: mtl_material_transactions mmt, mtl_transaction_lot_numbers
7512: mtln,mtl_unit_transactions mut where
7513: mut.transaction_id(+) = mtln.serial_transaction_id
7514: and
7515: mtln.transaction_id = mmt.transaction_id
7516: AND mmt.transaction_id = p_transaction_id