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_CYCLE_COUNT_ENTRIES

Line 235: FROM mtl_cycle_count_entries

231: END IF;
232:
233: SELECT NVL((Trunc(SYSDATE) - Trunc(Max(count_date_current))),l_opp_cyc_count_days)
234: INTO l_no_of_days
235: FROM mtl_cycle_count_entries
236: WHERE subinventory = p_subinventory_code
237: AND inventory_item_id = p_inventory_item_id
238: AND organization_id = p_organization_id
239: AND locator_id = p_loc_id

Line 465: FROM mtl_cycle_count_entries

461: -- Delete WDT
462:
463: DELETE FROM wms_dispatched_tasks
464: WHERE transaction_temp_id IN (SELECT CYCLE_COUNT_ENTRY_ID
465: FROM mtl_cycle_count_entries
466: WHERE ENTRY_STATUS_CODE IN (1,3)
467: AND ORGANIZATION_ID=p_organization_id
468: AND SUBINVENTORY=p_subinventory
469: AND LOCATOR_ID=p_locator_id

Line 479: DELETE FROM mtl_cycle_count_entries

475: END IF;
476:
477: -- delete MCCE
478:
479: DELETE FROM mtl_cycle_count_entries
480: WHERE ENTRY_STATUS_CODE IN (1, 3)
481: AND ORGANIZATION_ID=p_organization_id
482: AND SUBINVENTORY=p_subinventory
483: AND LOCATOR_ID=p_locator_id

Line 710: FROM mtl_cycle_count_entries

706: )
707: ),0)
708: INTO l_cnt_qty
709: FROM (SELECT count_uom_current, (system_quantity_current - count_quantity_current) adj_cnt_qty
710: FROM mtl_cycle_count_entries
711: WHERE inventory_item_id = p_inventory_item_id
712: AND organization_id = p_organization_id
713: AND subinventory = p_subinventory_code
714: AND locator_id = p_loc_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 944: FROM mtl_cycle_count_entries

940: )
941: ),0)
942: INTO l_cnt_qty
943: FROM (SELECT count_uom_current, (system_quantity_current - count_quantity_current) adj_cnt_qty
944: FROM mtl_cycle_count_entries
945: WHERE inventory_item_id = p_inventory_item_id
946: AND organization_id = p_organization_id
947: AND subinventory = p_subinventory
948: AND locator_id = p_locator_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