DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 7325: FROM wms_license_plate_numbers wlpn,

7321: wlpn.content_volume_uom_code,
7322: NVL(wlpn.content_volume, 0),
7323: milk.concatenated_segments,
7324: wlpn.lpn_context
7325: FROM wms_license_plate_numbers wlpn,
7326: mtl_item_locations_kfv milk,
7327: wms_lpn_contents wlc
7328: WHERE wlpn.organization_id = milk.organization_id (+)
7329: AND wlpn.locator_id = milk.inventory_location_id(+)

Line 7366: FROM wms_license_plate_numbers wlpn,

7362: wlpn.content_volume_uom_code,
7363: NVL(wlpn.content_volume, 0),
7364: milk.concatenated_segments,
7365: wlpn.lpn_context
7366: FROM wms_license_plate_numbers wlpn,
7367: mtl_item_locations_kfv milk,
7368: wms_lpn_contents wlc
7369: WHERE wlpn.organization_id = milk.organization_id (+)
7370: AND wlpn.locator_id = milk.inventory_location_id(+)

Line 7407: FROM wms_license_plate_numbers wlpn,

7403: INV_PROJECT.GET_PROJECT_NUMBER,
7404: INV_PROJECT.GET_TASK_ID,
7405: INV_PROJECT.GET_TASK_NUMBER,
7406: wlpn.lpn_context
7407: FROM wms_license_plate_numbers wlpn,
7408: mtl_item_locations_kfv milk,
7409: wms_lpn_contents wlc
7410: WHERE wlpn.organization_id = milk.organization_id (+)
7411: AND wlpn.locator_id = milk.inventory_location_id(+)