DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 8385: FROM wms_license_plate_numbers wlpn,

8381: wlpn.content_volume_uom_code,
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(+)

Line 8426: FROM wms_license_plate_numbers wlpn,

8422: wlpn.content_volume_uom_code,
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(+)

Line 8467: FROM wms_license_plate_numbers wlpn,

8463: INV_PROJECT.GET_PROJECT_NUMBER,
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(+)