DBA Data[Home] [Help]

APPS.CSI_WIP_TRXS_PKG dependencies on MTL_UNIT_TRANSACTIONS

Line 116: mtl_unit_transactions mut,

112: abs(mtln.primary_quantity) lot_primary_quantity,
113: mmt.transaction_set_id transaction_set_id --bug 5376024
114: FROM hr_all_organization_units haou,
115: mtl_transaction_lot_numbers mtln,
116: mtl_unit_transactions mut,
117: mtl_secondary_inventories msi,
118: mtl_material_transactions mmt
119: WHERE mmt.transaction_id = p_transaction_id
120: AND mmt.transaction_id = mut.transaction_id(+)

Line 149: mtl_unit_transactions mut,

145: abs(mtln.primary_quantity) lot_primary_quantity,
146: mmt.transaction_set_id transaction_set_id --bug 5376024
147: FROM hr_all_organization_units haou,
148: mtl_transaction_lot_numbers mtln,
149: mtl_unit_transactions mut,
150: mtl_secondary_inventories msi,
151: mtl_material_transactions mmt
152: WHERE mmt.transaction_id = p_transaction_id
153: AND mmt.subinventory_code = msi.secondary_inventory_name

Line 5495: from mtl_material_transactions mmt, mtl_unit_transactions mut

5491: --Added for bug 5376024--
5492: BEGIN
5493: select mmt.inventory_item_id, mut.serial_number
5494: into l_inv_item_id, l_serial_number
5495: from mtl_material_transactions mmt, mtl_unit_transactions mut
5496: where mmt.transaction_id = mut.transaction_id
5497: and mmt.transaction_set_id = p_mmt_rec.transaction_set_id
5498: and mmt.transaction_type_id = 17;
5499: