DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on MTL_ITEM_LOCATIONS_KFV

Line 7326: mtl_item_locations_kfv milk,

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(+)
7330: AND wlc.parent_lpn_id (+) = wlpn.lpn_id

Line 7367: mtl_item_locations_kfv milk,

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(+)
7371: AND wlc.parent_lpn_id (+) = wlpn.lpn_id

Line 7408: mtl_item_locations_kfv milk,

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(+)
7412: AND wlc.parent_lpn_id (+) = wlpn.lpn_id