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 2920: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd

2916: AND NVL(b.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2917: AND a.license_plate_number LIKE (p_lpn_segments)
2918: AND a.parent_lpn_id IS NULL
2919: AND (p_owning_org_id IS NULL
2920: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
2921: ,wms_license_plate_numbers wlpn
2922: WHERE moqd.lpn_id in (wlpn.lpn_id)
2923: AND wlpn.outermost_lpn_id = a.outermost_lpn_id
2924: AND moqd.organization_id = a.organization_id

Line 2928: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd

2924: AND moqd.organization_id = a.organization_id
2925: AND moqd.owning_organization_id = p_owning_org_id
2926: AND moqd.owning_tp_type = p_owning_tp_type))
2927: AND (p_planning_org_id IS NULL
2928: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
2929: ,wms_license_plate_numbers wlpn
2930: WHERE moqd.lpn_id in (wlpn.lpn_id)
2931: AND wlpn.outermost_lpn_id = a.outermost_lpn_id
2932: AND moqd.organization_id = a.organization_id

Line 2978: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd

2974: ,p_to_organization_id
2975: ,p_wms_installed
2976: ,p_transaction_type_id) = 'Y'
2977: AND (p_owning_org_id IS NULL
2978: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
2979: ,wms_license_plate_numbers wlpn
2980: WHERE moqd.lpn_id in (wlpn.lpn_id)
2981: AND wlpn.outermost_lpn_id = a.outermost_lpn_id
2982: AND moqd.organization_id = a.organization_id

Line 2986: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd

2982: AND moqd.organization_id = a.organization_id
2983: AND moqd.owning_organization_id = p_owning_org_id
2984: AND moqd.owning_tp_type = p_owning_tp_type))
2985: AND (p_planning_org_id IS NULL
2986: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
2987: ,wms_license_plate_numbers wlpn
2988: WHERE moqd.lpn_id in (wlpn.lpn_id)
2989: AND wlpn.outermost_lpn_id = a.outermost_lpn_id
2990: AND moqd.organization_id = a.organization_id

Line 3604: FROM mtl_secondary_inventories msi, MTL_ONHAND_QUANTITIES_DETAIL moq

3600: , msi.description
3601: , '0'
3602: , msi.lpn_controlled_flag
3603: , msi.enable_locator_alias
3604: FROM mtl_secondary_inventories msi, MTL_ONHAND_QUANTITIES_DETAIL moq
3605: WHERE msi.secondary_inventory_name = moq.subinventory_code
3606: AND msi.organization_id = moq.organization_id
3607: 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'
3608: AND moq.containerized_flag = 2

Line 3652: FROM wms_item_locations_kfv mil, MTL_ONHAND_QUANTITIES_DETAIL moq

3648: SELECT moq.locator_id
3649: --, mil.concatenated_segments--Bug4398337:Commented this line and added below line
3650: , mil.locator_segments concatenated_segments
3651: , mil.description
3652: FROM wms_item_locations_kfv mil, MTL_ONHAND_QUANTITIES_DETAIL moq
3653: WHERE mil.concatenated_segments LIKE (p_concatenated_segments)
3654: AND mil.inventory_location_id = moq.locator_id
3655: AND mil.organization_id = p_organization_id
3656: -- Bug 2325664 AND mil.physical_location_id is null -- PJM-WMS Integration

Line 3703: FROM wms_item_locations_kfv mil, MTL_ONHAND_QUANTITIES_DETAIL moq

3699: SELECT moq.locator_id
3700: --, mil.concatenated_segments--Bug4398337:Commented this line and added below line
3701: , mil.locator_segments concatenated_segments
3702: , mil.description
3703: FROM wms_item_locations_kfv mil, MTL_ONHAND_QUANTITIES_DETAIL moq
3704: WHERE alias = p_alias
3705: AND mil.inventory_location_id = moq.locator_id
3706: AND mil.organization_id = p_organization_id
3707: -- Bug 2325664 AND mil.physical_location_id is null -- PJM-WMS Integration