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.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 2543: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd

2539: AND NVL(b.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2540: AND a.license_plate_number LIKE (p_lpn_segments)
2541: AND a.parent_lpn_id IS NULL
2542: AND (p_owning_org_id IS NULL
2543: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
2544: ,wms_license_plate_numbers wlpn
2545: WHERE moqd.lpn_id in (wlpn.lpn_id)
2546: AND wlpn.outermost_lpn_id = a.outermost_lpn_id
2547: AND moqd.organization_id = a.organization_id

Line 2551: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd

2547: AND moqd.organization_id = a.organization_id
2548: AND moqd.owning_organization_id = p_owning_org_id
2549: AND moqd.owning_tp_type = p_owning_tp_type))
2550: AND (p_planning_org_id IS NULL
2551: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
2552: ,wms_license_plate_numbers wlpn
2553: WHERE moqd.lpn_id in (wlpn.lpn_id)
2554: AND wlpn.outermost_lpn_id = a.outermost_lpn_id
2555: AND moqd.organization_id = a.organization_id

Line 2601: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd

2597: ,p_to_organization_id
2598: ,p_wms_installed
2599: ,p_transaction_type_id) = 'Y'
2600: AND (p_owning_org_id IS NULL
2601: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
2602: ,wms_license_plate_numbers wlpn
2603: WHERE moqd.lpn_id in (wlpn.lpn_id)
2604: AND wlpn.outermost_lpn_id = a.outermost_lpn_id
2605: AND moqd.organization_id = a.organization_id

Line 2609: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd

2605: AND moqd.organization_id = a.organization_id
2606: AND moqd.owning_organization_id = p_owning_org_id
2607: AND moqd.owning_tp_type = p_owning_tp_type))
2608: AND (p_planning_org_id IS NULL
2609: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
2610: ,wms_license_plate_numbers wlpn
2611: WHERE moqd.lpn_id in (wlpn.lpn_id)
2612: AND wlpn.outermost_lpn_id = a.outermost_lpn_id
2613: AND moqd.organization_id = a.organization_id

Line 3207: FROM mtl_secondary_inventories msi, MTL_ONHAND_QUANTITIES_DETAIL moq

3203: , msi.description
3204: , '0'
3205: , msi.lpn_controlled_flag
3206: , msi.enable_locator_alias
3207: FROM mtl_secondary_inventories msi, MTL_ONHAND_QUANTITIES_DETAIL moq
3208: WHERE msi.secondary_inventory_name = moq.subinventory_code
3209: AND msi.organization_id = moq.organization_id
3210: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, 86, NULL, NULL, p_organization_id, p_inventory_item_id, moq.subinventory_code, NULL, NULL, NULL, 'Z') = 'Y'
3211: AND moq.containerized_flag = 2

Line 3255: FROM wms_item_locations_kfv mil, MTL_ONHAND_QUANTITIES_DETAIL moq

3251: SELECT moq.locator_id
3252: --, mil.concatenated_segments--Bug4398337:Commented this line and added below line
3253: , mil.locator_segments concatenated_segments
3254: , mil.description
3255: FROM wms_item_locations_kfv mil, MTL_ONHAND_QUANTITIES_DETAIL moq
3256: WHERE mil.concatenated_segments LIKE (p_concatenated_segments)
3257: AND mil.inventory_location_id = moq.locator_id
3258: AND mil.organization_id = p_organization_id
3259: -- Bug 2325664 AND mil.physical_location_id is null -- PJM-WMS Integration

Line 3304: FROM wms_item_locations_kfv mil, MTL_ONHAND_QUANTITIES_DETAIL moq

3300: SELECT moq.locator_id
3301: --, mil.concatenated_segments--Bug4398337:Commented this line and added below line
3302: , mil.locator_segments concatenated_segments
3303: , mil.description
3304: FROM wms_item_locations_kfv mil, MTL_ONHAND_QUANTITIES_DETAIL moq
3305: WHERE alias = p_alias
3306: AND mil.inventory_location_id = moq.locator_id
3307: AND mil.organization_id = p_organization_id
3308: -- Bug 2325664 AND mil.physical_location_id is null -- PJM-WMS Integration