eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_OPP_CYC_COUNT dependencies on MTL_SERIAL_NUMBERS

Line 122: FROM mtl_serial_numbers

118: BEGIN
119:
120: SELECT NVL ( SUM ( DECODE ( current_status, 3, 1, 0 ) ), 0 )
121: INTO l_tot_qty
122: FROM mtl_serial_numbers
123: WHERE inventory_item_id = p_inventory_item_id
124: AND current_organization_id = p_organization_id
125: AND current_subinventory_code = p_subinventory_code
126: AND current_locator_id = p_loc_id;

Line 144: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt

140: BEGIN
141:
142: SELECT Count(DISTINCT msn.serial_number)
143: INTO l_loaded_sys_qty
144: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt
145: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id (+)
146: AND ((msnt.transaction_temp_id = mmtt.transaction_temp_id and
147: mtlt.lot_number is null) or
148: (msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 620: FROM mtl_serial_numbers

616: BEGIN
617:
618: SELECT NVL ( SUM ( DECODE ( current_status, 3, 1, 0 ) ), 0 )
619: INTO l_tot_qty
620: FROM mtl_serial_numbers
621: WHERE inventory_item_id = p_inventory_item_id
622: AND current_organization_id = p_organization_id
623: AND current_subinventory_code = p_subinventory_code
624: AND current_locator_id = p_loc_id

Line 652: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt

648: BEGIN
649:
650: SELECT Count(DISTINCT msn.serial_number)
651: INTO l_loaded_sys_qty
652: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt
653: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id (+)
654: AND ((msnt.transaction_temp_id = mmtt.transaction_temp_id and
655: mtlt.lot_number is null) or
656: (msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 730: FROM mtl_cycle_count_entries mcce, mtl_serial_numbers msn

726: AND (p_from_Serial_number IS NULL OR p_to_Serial_number IS NULL OR serial_number BETWEEN p_from_Serial_number AND p_to_Serial_number)
727: AND system_quantity_current <> count_quantity_current
728: UNION ALL
729: SELECT mcce.count_uom_current, (mcce.count_quantity_current - mcce.system_quantity_current) adj_cnt_qty
730: FROM mtl_cycle_count_entries mcce, mtl_serial_numbers msn
731: WHERE mcce.inventory_item_id = p_inventory_item_id
732: AND mcce.organization_id = p_organization_id
733: AND mcce.cycle_count_header_id = g_cycle_count_header_id
734: AND mcce.entry_status_code = 2

Line 896: FROM mtl_serial_numbers

892: l_progress := '50';
893:
894: SELECT NVL ( SUM ( DECODE ( current_status, 3, 1, 0 ) ), 0 )
895: INTO x_system_quantity
896: FROM mtl_serial_numbers
897: WHERE inventory_item_id = p_inventory_item_id
898: AND current_organization_id = p_organization_id
899: AND current_subinventory_code = p_subinventory
900: AND current_locator_id = p_locator_id

Line 908: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt

904: AND NVL ( revision, 'XXX' ) = NVL ( p_revision, 'XXX' );
905:
906: SELECT Count(DISTINCT msn.serial_number)
907: INTO l_loaded_sys_qty
908: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt
909: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id (+)
910: AND ((msnt.transaction_temp_id = mmtt.transaction_temp_id AND
911: mtlt.lot_number is null) OR
912: (msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 959: FROM mtl_cycle_count_entries mcce, mtl_serial_numbers msn

955: AND (p_from_Serial_number IS NULL OR p_to_Serial_number IS NULL OR serial_number BETWEEN p_from_Serial_number AND p_to_Serial_number)
956: AND system_quantity_current <> count_quantity_current
957: UNION ALL
958: SELECT mcce.count_uom_current, (mcce.count_quantity_current - mcce.system_quantity_current) adj_cnt_qty
959: FROM mtl_cycle_count_entries mcce, mtl_serial_numbers msn
960: WHERE mcce.inventory_item_id = p_inventory_item_id
961: AND mcce.organization_id = p_organization_id
962: AND mcce.cycle_count_header_id = g_cycle_count_header_id
963: AND mcce.entry_status_code = 2

Line 1159: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt

1155: l_progress := '60';
1156:
1157: SELECT Count(DISTINCT msn.serial_number)
1158: INTO l_allocated_pri_qty
1159: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt
1160: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id (+)
1161: AND ((msnt.transaction_temp_id = mmtt.transaction_temp_id AND
1162: mtlt.lot_number IS NULL) OR
1163: (msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 1184: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt

1180:
1181:
1182: OPEN x_alloc_cur FOR
1183: SELECT DISTINCT mmtt.TRANSACTION_TEMP_ID, Count(DISTINCT msn.serial_number) primary_quantity, Nvl(mmtt.TASK_PRIORITY,0)
1184: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt
1185: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id (+)
1186: AND ((msnt.transaction_temp_id = mmtt.transaction_temp_id AND
1187: mtlt.lot_number is null) OR
1188: (msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 1278: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt

1274: l_progress := '10';
1275:
1276: SELECT Count(DISTINCT msn.serial_number)
1277: INTO l_allocated_pri_qty
1278: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt
1279: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id (+)
1280: AND ((msnt.transaction_temp_id = mmtt.transaction_temp_id AND
1281: mtlt.lot_number is null) OR
1282: (msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 1297: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt

1293:
1294:
1295: OPEN x_det_alloc_cur FOR
1296: SELECT DISTINCT mmtt.TRANSACTION_TEMP_ID, Count(DISTINCT msn.serial_number) primary_quantity, Nvl(mmtt.TASK_PRIORITY,0)
1297: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt
1298: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id (+)
1299: AND ((msnt.transaction_temp_id = mmtt.transaction_temp_id AND
1300: mtlt.lot_number is null) OR
1301: (msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 1635: FROM mtl_serial_numbers

1631:
1632: IF (p_from_serial_number IS NOT NULL AND p_to_serial_number IS NOT NULL) THEN
1633:
1634: FOR ser_cur IN (SELECT current_subinventory_code, current_locator_id, serial_number
1635: FROM mtl_serial_numbers
1636: WHERE inventory_item_id = p_inventory_item_id
1637: AND current_organization_id = p_organization_id
1638: AND serial_number BETWEEN p_from_serial_number AND p_to_serial_number
1639: AND (current_subinventory_code<>p_subinventory

Line 1823: FROM wms_lpn_contents wlc, mtl_serial_numbers msn

1819:
1820: l_progress := '70';
1821:
1822: FOR lpn_contents_cur IN (SELECT DISTINCT wlc.inventory_item_id, wlc.lot_number, wlc.revision, DECODE(NVL(msn.serial_number, 'XXXX'), 'XXXX', wlc.primary_quantity, 1) primary_quantity, msn.serial_number
1823: FROM wms_lpn_contents wlc, mtl_serial_numbers msn
1824: WHERE wlc.parent_lpn_id=p_parent_lpn_id
1825: AND wlc.inventory_item_id = msn.inventory_item_id (+)
1826: AND ( msn.inventory_item_id IS NULL
1827: OR (msn.current_organization_id = p_organization_id

Line 2044: FROM mtl_serial_numbers

2040:
2041: IF (p_from_serial_number IS NOT NULL AND p_to_serial_number IS NOT NULL) THEN
2042:
2043: FOR ser_cur IN (SELECT current_subinventory_code, current_locator_id, Count(DISTINCT serial_number) ser_cnt
2044: FROM mtl_serial_numbers
2045: WHERE inventory_item_id = p_inventory_item_id
2046: AND current_organization_id = p_organization_id
2047: AND serial_number BETWEEN p_from_serial_number AND p_to_serial_number
2048: AND (current_subinventory_code<>p_subinventory

Line 2502: FROM wms_lpn_contents wlc, mtl_serial_numbers msn

2498:
2499: l_progress := '70';
2500:
2501: FOR lpn_contents_cur IN (SELECT DISTINCT wlc.inventory_item_id, wlc.lot_number, wlc.revision, DECODE(NVL(msn.serial_number, 'XXXX'), 'XXXX', wlc.primary_quantity, 1) primary_quantity, msn.serial_number
2502: FROM wms_lpn_contents wlc, mtl_serial_numbers msn
2503: WHERE wlc.parent_lpn_id=p_parent_lpn_id
2504: AND wlc.inventory_item_id = msn.inventory_item_id (+)
2505: AND ( msn.inventory_item_id IS NULL
2506: OR (msn.current_organization_id = p_organization_id