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