APPS.WIP_UTILITIES dependencies on MTL_SERIAL_NUMBERS

Line 350: delete from mtl_serial_numbers_temp

346: /* Deletes transaction records from the mtl temp tables */
347: procedure delete_temp_records(p_header_id IN NUMBER) is
348: begin
349: -- Delete all serial numbers tied to lots
350: delete from mtl_serial_numbers_temp
351: where transaction_temp_id in
352: ( select msnt.transaction_temp_id
353: from mtl_serial_numbers_temp msnt,
354: mtl_transaction_lots_temp mtlt,

Line 353: from mtl_serial_numbers_temp msnt,

349: -- Delete all serial numbers tied to lots
350: delete from mtl_serial_numbers_temp
351: where transaction_temp_id in
352: ( select msnt.transaction_temp_id
353: from mtl_serial_numbers_temp msnt,
354: mtl_transaction_lots_temp mtlt,
355: mtl_material_transactions_temp mmtt
356: where mmtt.transaction_header_id = p_header_id
357: and mtlt.transaction_temp_id = mmtt.transaction_temp_id

Line 362: delete from mtl_serial_numbers_temp

358: and mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
359: );
360:
361: -- Delete all serial numbers (sn control only)
362: delete from mtl_serial_numbers_temp
363: where transaction_temp_id in
364: ( select msnt.transaction_temp_id
365: from mtl_serial_numbers_temp msnt,
366: mtl_material_transactions_temp mmtt

Line 365: from mtl_serial_numbers_temp msnt,

361: -- Delete all serial numbers (sn control only)
362: delete from mtl_serial_numbers_temp
363: where transaction_temp_id in
364: ( select msnt.transaction_temp_id
365: from mtl_serial_numbers_temp msnt,
366: mtl_material_transactions_temp mmtt
367: where mmtt.transaction_header_id = p_header_id
368: and mmtt.transaction_temp_id = msnt.transaction_temp_id
369: );

Line 391: delete from mtl_serial_numbers_temp msnt

387: /* Deletes transaction records from the mtl temp tables */
388: procedure delete_temp_records(p_temp_id IN NUMBER) is
389: begin
390: -- Delete all serial numbers tied to lots
391: delete from mtl_serial_numbers_temp msnt
392: where transaction_temp_id in
393: (select mtlt.serial_transaction_temp_id
394: from mtl_transaction_lots_temp mtlt
395: where mtlt.transaction_temp_id = p_temp_id

Line 399: delete from mtl_serial_numbers_temp

395: where mtlt.transaction_temp_id = p_temp_id
396: );
397:
398: -- Delete all serial numbers (sn control only)
399: delete from mtl_serial_numbers_temp
400: where transaction_temp_id = p_temp_id;
401:
402: -- Delete all lots
403: delete from mtl_transaction_lots_temp

Line 491: from mtl_serial_numbers

487: l_last_txn_source_type_id,
488: l_last_txn_source_name,
489: l_parent_item_id,--20
490: l_parent_serial_number
491: from mtl_serial_numbers
492: where serial_number = p_serial_number
493: and inventory_item_id = p_inventory_item_id
494: and current_organization_id = p_organization_id
495: for update nowait;

Line 779: FROM mtl_serial_numbers

775:
776: CURSOR job_serials (p_org_id NUMBER, p_we_id NUMBER, p_item_id NUMBER)
777: IS
778: SELECT serial_number
779: FROM mtl_serial_numbers
780: WHERE current_organization_id = p_org_id
781: and wip_entity_id = p_we_id
782: AND inventory_item_id = p_item_id;
783:

Line 949: FROM mtl_serial_numbers

945: l_item_id := p_item_id;
946:
947: SELECT wip_entity_id, inventory_item_id
948: INTO l_wip_entity_id, l_item_id
949: FROM mtl_serial_numbers
950: WHERE current_organization_id = p_org_id
951: AND serial_number = p_serial_number
952: AND inventory_item_id = nvl(l_item_id, inventory_item_id);
953:

Line 954: -- For completed serial number, wip_entity_id in mtl_serial_numbers will

950: WHERE current_organization_id = p_org_id
951: AND serial_number = p_serial_number
952: AND inventory_item_id = nvl(l_item_id, inventory_item_id);
953:
954: -- For completed serial number, wip_entity_id in mtl_serial_numbers will
955: -- be null. Link mtl_object_genealogy to get wip_entity_id
956: if(l_wip_entity_id is null) then
957: SELECT we.wip_entity_id
958: INTO l_wip_entity_id

Line 959: FROM mtl_serial_numbers msn,

955: -- be null. Link mtl_object_genealogy to get wip_entity_id
956: if(l_wip_entity_id is null) then
957: SELECT we.wip_entity_id
958: INTO l_wip_entity_id
959: FROM mtl_serial_numbers msn,
960: wip_entities we,
961: mtl_object_genealogy mog
962: WHERE
963: ((mog.genealogy_origin = 1 and