APPS.WIP_UTILITIES dependencies on MTL_SERIAL_NUMBERS

Line 407: delete from mtl_serial_numbers_temp

403: /* Deletes transaction records from the mtl temp tables */
404: procedure delete_temp_records(p_header_id IN NUMBER) is
405: begin
406: -- Delete all serial numbers tied to lots
407: delete from mtl_serial_numbers_temp
408: where transaction_temp_id in
409: ( select msnt.transaction_temp_id
410: from mtl_serial_numbers_temp msnt,
411: mtl_transaction_lots_temp mtlt,

Line 410: from mtl_serial_numbers_temp msnt,

406: -- Delete all serial numbers tied to lots
407: delete from mtl_serial_numbers_temp
408: where transaction_temp_id in
409: ( select msnt.transaction_temp_id
410: from mtl_serial_numbers_temp msnt,
411: mtl_transaction_lots_temp mtlt,
412: mtl_material_transactions_temp mmtt
413: where mmtt.transaction_header_id = p_header_id
414: and mtlt.transaction_temp_id = mmtt.transaction_temp_id

Line 419: delete from mtl_serial_numbers_temp

415: and mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
416: );
417:
418: -- Delete all serial numbers (sn control only)
419: delete from mtl_serial_numbers_temp
420: where transaction_temp_id in
421: ( select msnt.transaction_temp_id
422: from mtl_serial_numbers_temp msnt,
423: mtl_material_transactions_temp mmtt

Line 422: from mtl_serial_numbers_temp msnt,

418: -- Delete all serial numbers (sn control only)
419: delete from mtl_serial_numbers_temp
420: where transaction_temp_id in
421: ( select msnt.transaction_temp_id
422: from mtl_serial_numbers_temp msnt,
423: mtl_material_transactions_temp mmtt
424: where mmtt.transaction_header_id = p_header_id
425: and mmtt.transaction_temp_id = msnt.transaction_temp_id
426: );

Line 448: delete from mtl_serial_numbers_temp msnt

444: /* Deletes transaction records from the mtl temp tables */
445: procedure delete_temp_records(p_temp_id IN NUMBER) is
446: begin
447: -- Delete all serial numbers tied to lots
448: delete from mtl_serial_numbers_temp msnt
449: where transaction_temp_id in
450: (select mtlt.serial_transaction_temp_id
451: from mtl_transaction_lots_temp mtlt
452: where mtlt.transaction_temp_id = p_temp_id

Line 456: delete from mtl_serial_numbers_temp

452: where mtlt.transaction_temp_id = p_temp_id
453: );
454:
455: -- Delete all serial numbers (sn control only)
456: delete from mtl_serial_numbers_temp
457: where transaction_temp_id = p_temp_id;
458:
459: -- Delete all lots
460: delete from mtl_transaction_lots_temp

Line 499: l_last_txn_source_name MTL_SERIAL_NUMBERS.LAST_TXN_SOURCE_NAME%TYPE;

495: l_last_receipt_issue_type NUMBER;
496: l_last_txn_source_id NUMBER;
497: l_last_txn_source_type_id NUMBER;
498: --Bug 12960198 Modified the size limit of variable per requirement from Inv
499: l_last_txn_source_name MTL_SERIAL_NUMBERS.LAST_TXN_SOURCE_NAME%TYPE;
500: l_parent_item_id NUMBER;
501: l_parent_serial_number VARCHAR2(30);
502: l_dummy VARCHAR2(1);
503: l_last_status NUMBER;

Line 549: from mtl_serial_numbers

545: l_last_txn_source_type_id,
546: l_last_txn_source_name,
547: l_parent_item_id,--20
548: l_parent_serial_number
549: from mtl_serial_numbers
550: where serial_number = p_serial_number
551: and inventory_item_id = p_inventory_item_id
552: and current_organization_id = p_organization_id
553: for update nowait;

Line 837: FROM mtl_serial_numbers

833:
834: CURSOR job_serials (p_org_id NUMBER, p_we_id NUMBER, p_item_id NUMBER)
835: IS
836: SELECT serial_number
837: FROM mtl_serial_numbers
838: WHERE current_organization_id = p_org_id
839: and wip_entity_id = p_we_id
840: AND inventory_item_id = p_item_id;
841:

Line 1007: FROM mtl_serial_numbers

1003: l_item_id := p_item_id;
1004:
1005: SELECT wip_entity_id, inventory_item_id
1006: INTO l_wip_entity_id, l_item_id
1007: FROM mtl_serial_numbers
1008: WHERE current_organization_id = p_org_id
1009: AND serial_number = p_serial_number
1010: AND inventory_item_id = nvl(l_item_id, inventory_item_id);
1011:

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

1008: WHERE current_organization_id = p_org_id
1009: AND serial_number = p_serial_number
1010: AND inventory_item_id = nvl(l_item_id, inventory_item_id);
1011:
1012: -- For completed serial number, wip_entity_id in mtl_serial_numbers will
1013: -- be null. Link mtl_object_genealogy to get wip_entity_id
1014: if(l_wip_entity_id is null) then
1015: SELECT we.wip_entity_id
1016: INTO l_wip_entity_id

Line 1017: FROM mtl_serial_numbers msn,

1013: -- be null. Link mtl_object_genealogy to get wip_entity_id
1014: if(l_wip_entity_id is null) then
1015: SELECT we.wip_entity_id
1016: INTO l_wip_entity_id
1017: FROM mtl_serial_numbers msn,
1018: wip_entities we,
1019: mtl_object_genealogy mog
1020: WHERE
1021: ((mog.genealogy_origin = 1 and