APPS.WMS_RULE_PVT dependencies on MTL_SERIAL_NUMBERS

Line 502: from mtl_serial_numbers msn

498: ,loc.task_id task_id
499: ,NULL locator_inventory_item_id
500: ,NULL empty_flag
501: ,NULL location_current_units
502: from mtl_serial_numbers msn
503: ,mtl_secondary_inventories sub
504: ,mtl_item_locations loc
505: ,mtl_lot_numbers lot
506: where msn.current_status = 3

Line 558: from mtl_serial_numbers msn

554: ,loc.task_id task_id
555: ,NULL locator_inventory_item_id
556: ,NULL empty_flag
557: ,NULL location_current_units
558: from mtl_serial_numbers msn
559: ,mtl_secondary_inventories sub
560: ,mtl_item_locations loc
561: ,mtl_lot_numbers lot
562: where msn.current_status = 3

Line 614: from mtl_serial_numbers msn

610: ,loc.task_id task_id
611: ,NULL locator_inventory_item_id
612: ,NULL empty_flag
613: ,NULL location_current_units
614: from mtl_serial_numbers msn
615: ,mtl_secondary_inventories sub
616: ,mtl_item_locations loc
617: ,mtl_lot_numbers lot
618: where msn.current_status = 3

Line 7424: from mtl_serial_numbers

7420: l_serial_status_id := 0;
7421: IF ((l_serial_number IS NOT NULL) AND (NVL(l_serial_status, 'N') = 'Y')) THEN
7422: select status_id
7423: into l_serial_status_id
7424: from mtl_serial_numbers
7425: where inventory_item_id = p_inventory_item_id
7426: and current_organization_id = p_organization_id
7427: and serial_number = l_serial_number;
7428:

Line 7774: from mtl_serial_numbers

7770: IF v_current_row.serial_number IS NOT NULL THEN
7771: IF l_detail_serial = 1 THEN
7772: select status_id
7773: into l_serial_status_id
7774: from mtl_serial_numbers
7775: where inventory_item_id = p_inventory_item_id
7776: and current_organization_id = p_organization_id
7777: and serial_number = v_current_row.serial_number;
7778:

Line 8956: from mtl_serial_numbers

8952:
8953: IF l_detail_serial = 1 THEN
8954: select status_id
8955: into l_serial_status_id
8956: from mtl_serial_numbers
8957: where inventory_item_id = p_inventory_item_id
8958: and current_organization_id = p_organization_id
8959: and serial_number = v_current_row.serial_number;
8960:

Line 15099: SELECT STATUS_ID FROM MTL_SERIAL_NUMBERS

15095: l_default_status_id NUMBER ;
15096: -- LPN Status Project
15097:
15098: cursor lpn_serial_cur(l_lpn_id NUMBER ) is
15099: SELECT STATUS_ID FROM MTL_SERIAL_NUMBERS
15100: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
15101: AND LPN_ID = l_lpn_id;
15102:
15103: