[Home] [Help]
702: l_commit_size NUMBER := 500;
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
903: -- 2. Non-Serialized and Serial Control at sales order issue
904: --
905: -- If the item is pre-defined or at inventory receipt, the serial number
906: -- is entered while completing the job. The serial number is stored in
907: -- mtl_unit_transactions table. So the serial number can be matched to
908: -- the serial number on repair order and the repair order is updated
909: -- with the completed qty. But if the wip job is for upgrade, then the
910: -- repair order item is different then the item on the WIP job. So if
911: -- it is upgrade then the completion qty is updated based on the
925: -- Txn Id Job ID Txn Qty Completion Subinv
926: -- M1 1121 2 FGI
927: -- M2 1121 8 Stores
928: --
929: -- MTL_UNIT_TRANSACTIONS
930: --
931: -- Txn Id Serial Number Subinv
932: -- M1 SN1 FGI
933: -- M2 SN2 FGI
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
951: and mt.transaction_action_id = 31 -- Wip Assembly Completion
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
1063: and mt.transaction_action_id = 31 -- Wip Assembly Completion
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
1201: and mt.transaction_action_id = 31 -- Wip Assembly Completion
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)
7135: and mtl.picking_line_id = p_del_line_id
7145: mut.locator_id,
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
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
7890: -- D1 L1 6
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
8047: and mtl.transaction_type_id in ( 50,62,54,34)
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
8303: and mtl.transaction_type_id in ( 50,62,54,34)