DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on MTL_ITEM_LOCATIONS_KFV

Line 8386: mtl_item_locations_kfv milk,

8382: NVL(wlpn.content_volume, 0),
8383: milk.concatenated_segments,
8384: wlpn.lpn_context
8385: FROM wms_license_plate_numbers wlpn,
8386: mtl_item_locations_kfv milk,
8387: wms_lpn_contents wlc
8388: WHERE wlpn.organization_id = milk.organization_id (+)
8389: AND wlpn.locator_id = milk.inventory_location_id(+)
8390: AND wlc.parent_lpn_id (+) = wlpn.lpn_id

Line 8427: mtl_item_locations_kfv milk,

8423: NVL(wlpn.content_volume, 0),
8424: milk.concatenated_segments,
8425: wlpn.lpn_context
8426: FROM wms_license_plate_numbers wlpn,
8427: mtl_item_locations_kfv milk,
8428: wms_lpn_contents wlc
8429: WHERE wlpn.organization_id = milk.organization_id (+)
8430: AND wlpn.locator_id = milk.inventory_location_id(+)
8431: AND wlc.parent_lpn_id (+) = wlpn.lpn_id

Line 8468: mtl_item_locations_kfv milk,

8464: INV_PROJECT.GET_TASK_ID,
8465: INV_PROJECT.GET_TASK_NUMBER,
8466: wlpn.lpn_context
8467: FROM wms_license_plate_numbers wlpn,
8468: mtl_item_locations_kfv milk,
8469: wms_lpn_contents wlc
8470: WHERE wlpn.organization_id = milk.organization_id (+)
8471: AND wlpn.locator_id = milk.inventory_location_id(+)
8472: AND wlc.parent_lpn_id (+) = wlpn.lpn_id