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.CSD_UPDATE_PROGRAMS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 707: l_mtl_subinv mtl_material_transactions.subinventory_code%type;

703: l_msg_text VARCHAR2(2000);
704: l_mtl_trx_id NUMBER;
705: l_mtl_trx_date DATE;
706: l_mtl_serial_num mtl_unit_transactions.serial_number%type;
707: l_mtl_subinv mtl_material_transactions.subinventory_code%type;
708: l_SN_mismatch BOOLEAN := FALSE;
709:
710: l_ro_count NUMBER ; ---Added by vijay to put ro count in JC event
711:

Line 805: from mtl_material_transactions mtl

801: select subinventory_code,
802: transaction_quantity,
803: transaction_id,
804: transaction_date
805: from mtl_material_transactions mtl
806: where mtl.transaction_source_id = p_entity_id
807: and mtl.transaction_source_type_id = 5 -- Job or Schedule
808: and mtl.transaction_action_id = 31;-- Wip Assembly Completion
809:

Line 924: -- MTL_MATERIAL_TRANSACTIONS

920: -- In WIP_DISCRETE_JOBS
921: -- Job Name Job Id Start Qty Completion Qty Completion Subinv
922: -- W1 1121 10 10
923: --
924: -- MTL_MATERIAL_TRANSACTIONS
925: -- Txn Id Job ID Txn Qty Completion Subinv
926: -- M1 1121 2 FGI
927: -- M2 1121 8 Stores
928: --

Line 946: from mtl_material_transactions mt,

942: mt.subinventory_code
943: into l_mtl_trx_id,
944: l_mtl_trx_date,
945: l_mtl_subinv
946: from mtl_material_transactions mt,
947: mtl_unit_transactions mut
948: where mt.transaction_id = mut.transaction_id
949: and mt.transaction_source_id = JOB.wip_entity_id
950: and mt.transaction_source_type_id = 5 -- Job or Schedule

Line 1034: -- MTL Material Transactions

1030: -- Wip Discrete Jobs
1031: -- Job Start Qty Comp Qty
1032: -- W1 3 3
1033: --
1034: -- MTL Material Transactions
1035: -- Mtl Txn Id Txn Qty SubInv
1036: -- M1 2 FGI
1037: -- M2 1 Stores
1038: -- MTL Unit Txns

Line 1058: from mtl_material_transactions mt,

1054: into l_mtl_trx_id,
1055: l_mtl_trx_date,
1056: l_mtl_serial_num,
1057: l_mtl_subinv
1058: from mtl_material_transactions mt,
1059: mtl_unit_transactions mut
1060: where mt.transaction_id = mut.transaction_id
1061: and mt.transaction_source_id = JOB.wip_entity_id
1062: and mt.transaction_source_type_id = 5 -- Job or Schedule

Line 1196: from mtl_material_transactions mt,

1192: into l_mtl_trx_id,
1193: l_mtl_trx_date,
1194: l_mtl_serial_num,
1195: l_mtl_subinv
1196: from mtl_material_transactions mt,
1197: mtl_unit_transactions mut
1198: where mt.transaction_id = mut.transaction_id
1199: and mt.transaction_source_id = JOB.wip_entity_id
1200: and mt.transaction_source_type_id = 5 -- Job or Schedule

Line 1291: -- MTL_MATERIAL_TRANSACTIONS

1287: -- In WIP_DISCRETE_JOBS
1288: -- Job Name Job Id Start Qty Completion Qty Completion Subinv
1289: -- W1 1121 10 10
1290: --
1291: -- MTL_MATERIAL_TRANSACTIONS
1292: -- Txn Id Job ID Txn Qty Completion Subinv
1293: -- M1 1121 2 FGI
1294: -- M2 1121 8 Stores
1295: FOR MTL in Get_mtl_txns(JOB.wip_entity_id)

Line 7130: from mtl_material_transactions mtl,

7126: mut.subinventory_code,
7127: mut.locator_id,
7128: mut.serial_number,
7129: mtl.transaction_id
7130: from mtl_material_transactions mtl,
7131: mtl_unit_transactions mut
7132: where mtl.transaction_id = mut.transaction_id
7133: and mtl.transaction_source_type_id = 8 -- Internal Order
7134: and mtl.transaction_type_id in (50, 62,54,34)

Line 7150: mtl_material_transactions mtl

7146: mut.serial_number,
7147: mtl.transaction_id
7148: from MTL_TRANSACTION_LOT_NUMBERS mln,
7149: mtl_unit_transactions mut,
7150: mtl_material_transactions mtl
7151: WHERE MLN.SERIAL_TRANSACTION_ID = mut.transaction_id
7152: and mln.transaction_id = mtl.transaction_id
7153: and mtl.transaction_source_type_id = 8 -- Internal Order
7154: and mtl.transaction_type_id in ( 50,62,54,34)

Line 7885: -- in the material unit transactions. Need to join the mtl_material_transactions

7881:
7882: Debug('DEL.LOT_CONTROL_CODE ='||DEL.LOT_CONTROL_CODE ,l_mod_name,1);
7883:
7884: -- In case of item serialized at sales order issue, the serial number is stored
7885: -- in the material unit transactions. Need to join the mtl_material_transactions
7886: -- with mtl_unit_transactions to get the serial numbers.
7887: -- Serial Number Control Code = 6 (Serialized at Sales order Issue)
7888: -- Delivery Lines
7889: -- Del Line Id Order Line Id Shipped Qty

Line 8042: from mtl_material_transactions mtl,

8038: and cpt.prod_txn_status in ('BOOKED','RELEASED')
8039: and cra.serial_number not in
8040: (select
8041: mut.serial_number
8042: from mtl_material_transactions mtl,
8043: mtl_unit_transactions mut,
8044: wsh_delivery_details wdd
8045: where mtl.transaction_id = mut.transaction_id
8046: and mtl.transaction_source_type_id = 8 -- Internal Order

Line 8298: from mtl_material_transactions mtl,

8294: and cpt.prod_txn_status in ('BOOKED','RELEASED')
8295: and cra.serial_number not in
8296: (select
8297: mut.serial_number
8298: from mtl_material_transactions mtl,
8299: mtl_unit_transactions mut,
8300: wsh_delivery_details wdd
8301: where mtl.transaction_id = mut.transaction_id
8302: and mtl.transaction_source_type_id = 8 -- Internal Order