APPS.WSH_OPSM_ASN_ITEM_GENEALOGY dependencies on MTL_SERIAL_NUMBERS

Line 234: mtl_serial_numbers msn ,

230: we.wip_entity_name job_name
231: FROM mtl_object_genealogy mog ,
232: mtl_transaction_lot_numbers mtln ,
233: mtl_unit_transactions mut ,
234: mtl_serial_numbers msn ,
235: mtl_material_transactions mmt ,
236: wip_entities we
237: WHERE msn.serial_number = r_serial_number
238: AND msn.inventory_item_id = r_item_id

Line 306: mtl_serial_numbers msn ,

302: AND mcr.cross_reference_type ='OPSM INTEGRATED'
303: AND mcr.cross_reference = 'YES') serial_type
304: FROM wip_entities we ,
305: mtl_system_items_vl msi ,
306: mtl_serial_numbers msn ,
307: mtl_lot_numbers mtln ,
308: org_organization_definitions ood,
309: mtl_cross_references mcr
310: WHERE msn.gen_object_id = r_gen_object_id

Line 2197: FROM mtl_serial_numbers

2193: SELECT serial_number,
2194: NVL(parent_serial_number, serial_number || TO_CHAR(i))
2195: INTO v_top(i).serial_number,
2196: v_top(i).parent_serial_number
2197: FROM mtl_serial_numbers
2198: WHERE gen_object_id = v_top(i).object_id
2199: AND (serial_number <> parent_serial_number
2200: OR parent_serial_number IS NULL);
2201: ----dbms_output.put_line(109);

Line 2221: FROM mtl_serial_numbers

2217: SELECT serial_number,
2218: serial_number
2219: INTO v_top(i).serial_number,
2220: v_top(i).parent_serial_number
2221: FROM mtl_serial_numbers
2222: WHERE gen_object_id = v_top(i).object_id;
2223:
2224: v_sem(v_top(i).serial_number) := 1;
2225: EXCEPTION

Line 2568: mtl_serial_numbers msn ,

2564: we.wip_entity_name job_name
2565: FROM mtl_object_genealogy mog ,
2566: mtl_transaction_lot_numbers mtln ,
2567: mtl_unit_transactions mut ,
2568: mtl_serial_numbers msn ,
2569: mtl_material_transactions mmt ,
2570: wip_entities we
2571: WHERE msn.serial_number = r_serial_number
2572: AND msn.inventory_item_id = r_item_id

Line 2640: mtl_serial_numbers msn ,

2636: AND mcr.cross_reference_type ='OPSM INTEGRATED'
2637: AND mcr.cross_reference = 'YES') serial_type
2638: FROM wip_entities we ,
2639: mtl_system_items_vl msi ,
2640: mtl_serial_numbers msn ,
2641: mtl_lot_numbers mtln ,
2642: org_organization_definitions ood,
2643: mtl_cross_references mcr
2644: WHERE msn.gen_object_id = r_gen_object_id

Line 4423: FROM mtl_serial_numbers

4419: SELECT serial_number,
4420: NVL(parent_serial_number, serial_number || TO_CHAR(i))
4421: INTO v_top(i).serial_number,
4422: v_top(i).parent_serial_number
4423: FROM mtl_serial_numbers
4424: WHERE gen_object_id = v_top(i).object_id
4425: AND (serial_number <> parent_serial_number
4426: OR parent_serial_number IS NULL);
4427: ----dbms_output.put_line(109);

Line 4447: FROM mtl_serial_numbers

4443: SELECT serial_number,
4444: serial_number
4445: INTO v_top(i).serial_number,
4446: v_top(i).parent_serial_number
4447: FROM mtl_serial_numbers
4448: WHERE gen_object_id = v_top(i).object_id;
4449:
4450: v_sem(v_top(i).serial_number) := 1;
4451: EXCEPTION