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 714: l_mtl_subinv mtl_material_transactions.subinventory_code%type;

710: l_msg_text VARCHAR2(2000);
711: l_mtl_trx_id NUMBER;
712: l_mtl_trx_date DATE;
713: l_mtl_serial_num mtl_unit_transactions.serial_number%type;
714: l_mtl_subinv mtl_material_transactions.subinventory_code%type;
715: l_SN_mismatch BOOLEAN := FALSE;
716:
717: l_ro_count NUMBER ; ---Added by vijay to put ro count in JC event
718:

Line 812: from mtl_material_transactions mtl

808: select subinventory_code,
809: transaction_quantity,
810: transaction_id,
811: transaction_date
812: from mtl_material_transactions mtl
813: where mtl.transaction_source_id = p_entity_id
814: and mtl.transaction_source_type_id = 5 -- Job or Schedule
815: and mtl.transaction_action_id = 31;-- Wip Assembly Completion
816:

Line 931: -- MTL_MATERIAL_TRANSACTIONS

927: -- In WIP_DISCRETE_JOBS
928: -- Job Name Job Id Start Qty Completion Qty Completion Subinv
929: -- W1 1121 10 10
930: --
931: -- MTL_MATERIAL_TRANSACTIONS
932: -- Txn Id Job ID Txn Qty Completion Subinv
933: -- M1 1121 2 FGI
934: -- M2 1121 8 Stores
935: --

Line 953: from mtl_material_transactions mt,

949: mt.subinventory_code
950: into l_mtl_trx_id,
951: l_mtl_trx_date,
952: l_mtl_subinv
953: from mtl_material_transactions mt,
954: mtl_unit_transactions mut
955: where mt.transaction_id = mut.transaction_id
956: and mt.transaction_source_id = JOB.wip_entity_id
957: and mt.transaction_source_type_id = 5 -- Job or Schedule

Line 1041: -- MTL Material Transactions

1037: -- Wip Discrete Jobs
1038: -- Job Start Qty Comp Qty
1039: -- W1 3 3
1040: --
1041: -- MTL Material Transactions
1042: -- Mtl Txn Id Txn Qty SubInv
1043: -- M1 2 FGI
1044: -- M2 1 Stores
1045: -- MTL Unit Txns

Line 1065: from mtl_material_transactions mt,

1061: into l_mtl_trx_id,
1062: l_mtl_trx_date,
1063: l_mtl_serial_num,
1064: l_mtl_subinv
1065: from mtl_material_transactions mt,
1066: mtl_unit_transactions mut
1067: where mt.transaction_id = mut.transaction_id
1068: and mt.transaction_source_id = JOB.wip_entity_id
1069: and mt.transaction_source_type_id = 5 -- Job or Schedule

Line 1203: from mtl_material_transactions mt,

1199: into l_mtl_trx_id,
1200: l_mtl_trx_date,
1201: l_mtl_serial_num,
1202: l_mtl_subinv
1203: from mtl_material_transactions mt,
1204: mtl_unit_transactions mut
1205: where mt.transaction_id = mut.transaction_id
1206: and mt.transaction_source_id = JOB.wip_entity_id
1207: and mt.transaction_source_type_id = 5 -- Job or Schedule

Line 1298: -- MTL_MATERIAL_TRANSACTIONS

1294: -- In WIP_DISCRETE_JOBS
1295: -- Job Name Job Id Start Qty Completion Qty Completion Subinv
1296: -- W1 1121 10 10
1297: --
1298: -- MTL_MATERIAL_TRANSACTIONS
1299: -- Txn Id Job ID Txn Qty Completion Subinv
1300: -- M1 1121 2 FGI
1301: -- M2 1121 8 Stores
1302: FOR MTL in Get_mtl_txns(JOB.wip_entity_id)

Line 7422: from mtl_material_transactions mtl,

7418: mut.subinventory_code,
7419: mut.locator_id,
7420: mut.serial_number,
7421: mtl.transaction_id
7422: from mtl_material_transactions mtl,
7423: mtl_unit_transactions mut
7424: where mtl.transaction_id = mut.transaction_id
7425: and mtl.transaction_source_type_id = 8 -- Internal Order
7426: and mtl.transaction_type_id in (50, 62,54,34)

Line 7442: mtl_material_transactions mtl

7438: mut.serial_number,
7439: mtl.transaction_id
7440: from MTL_TRANSACTION_LOT_NUMBERS mln,
7441: mtl_unit_transactions mut,
7442: mtl_material_transactions mtl
7443: WHERE MLN.SERIAL_TRANSACTION_ID = mut.transaction_id
7444: and mln.transaction_id = mtl.transaction_id
7445: and mtl.transaction_source_type_id = 8 -- Internal Order
7446: and mtl.transaction_type_id in ( 50,62,54,34)

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

8173:
8174: Debug('DEL.LOT_CONTROL_CODE ='||DEL.LOT_CONTROL_CODE ,l_mod_name,1);
8175:
8176: -- In case of item serialized at sales order issue, the serial number is stored
8177: -- in the material unit transactions. Need to join the mtl_material_transactions
8178: -- with mtl_unit_transactions to get the serial numbers.
8179: -- Serial Number Control Code = 6 (Serialized at Sales order Issue)
8180: -- Delivery Lines
8181: -- Del Line Id Order Line Id Shipped Qty

Line 8334: from mtl_material_transactions mtl,

8330: and cpt.prod_txn_status in ('BOOKED','RELEASED')
8331: and cra.serial_number not in
8332: (select
8333: mut.serial_number
8334: from mtl_material_transactions mtl,
8335: mtl_unit_transactions mut,
8336: wsh_delivery_details wdd
8337: where mtl.transaction_id = mut.transaction_id
8338: and mtl.transaction_source_type_id = 8 -- Internal Order

Line 8590: from mtl_material_transactions mtl,

8586: and cpt.prod_txn_status in ('BOOKED','RELEASED')
8587: and cra.serial_number not in
8588: (select
8589: mut.serial_number
8590: from mtl_material_transactions mtl,
8591: mtl_unit_transactions mut,
8592: wsh_delivery_details wdd
8593: where mtl.transaction_id = mut.transaction_id
8594: and mtl.transaction_source_type_id = 8 -- Internal Order