APPS.WMS_RULE_PVT dependencies on MTL_SERIAL_NUMBERS

Line 522: from mtl_serial_numbers msn

518: ,loc.task_id task_id
519: ,NULL locator_inventory_item_id
520: ,NULL empty_flag
521: ,NULL location_current_units
522: from mtl_serial_numbers msn
523: ,mtl_secondary_inventories sub
524: ,mtl_item_locations loc
525: ,mtl_lot_numbers lot
526: where msn.current_status = 3

Line 578: from mtl_serial_numbers msn

574: ,loc.task_id task_id
575: ,NULL locator_inventory_item_id
576: ,NULL empty_flag
577: ,NULL location_current_units
578: from mtl_serial_numbers msn
579: ,mtl_secondary_inventories sub
580: ,mtl_item_locations loc
581: ,mtl_lot_numbers lot
582: where msn.current_status = 3

Line 634: from mtl_serial_numbers msn

630: ,loc.task_id task_id
631: ,NULL locator_inventory_item_id
632: ,NULL empty_flag
633: ,NULL location_current_units
634: from mtl_serial_numbers msn
635: ,mtl_secondary_inventories sub
636: ,mtl_item_locations loc
637: ,mtl_lot_numbers lot
638: where msn.current_status = 3

Line 9362: FROM mtl_serial_numbers

9358: l_serial_status_id := 0;
9359: IF ((l_serial_number IS NOT NULL) AND (NVL(l_serial_status, 'N') = 'Y')) THEN
9360: SELECT status_id
9361: INTO l_serial_status_id
9362: FROM mtl_serial_numbers
9363: WHERE inventory_item_id = p_inventory_item_id
9364: AND current_organization_id = p_organization_id
9365: AND serial_number = l_serial_number;
9366:

Line 9799: FROM mtl_serial_numbers

9795: IF v_current_row.serial_number IS NOT NULL THEN
9796: IF l_detail_serial = 1 THEN
9797: SELECT status_id
9798: INTO l_serial_status_id
9799: FROM mtl_serial_numbers
9800: WHERE inventory_item_id = p_inventory_item_id
9801: AND current_organization_id = p_organization_id
9802: AND serial_number = v_current_row.serial_number;
9803:

Line 11308: FROM mtl_serial_numbers

11304: IF v_current_row.serial_number IS NOT NULL THEN
11305: IF l_detail_serial = 1 THEN
11306: SELECT status_id
11307: INTO l_serial_status_id
11308: FROM mtl_serial_numbers
11309: WHERE inventory_item_id = p_inventory_item_id
11310: AND current_organization_id = p_organization_id
11311: AND serial_number = v_current_row.serial_number;
11312:

Line 17757: SELECT STATUS_ID FROM MTL_SERIAL_NUMBERS

17753: l_default_status_id NUMBER ;
17754: -- LPN Status Project
17755:
17756: cursor lpn_serial_cur(l_lpn_id NUMBER ) is
17757: SELECT STATUS_ID FROM MTL_SERIAL_NUMBERS
17758: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
17759: AND LPN_ID = l_lpn_id;
17760:
17761: