APPS.INV_UI_RCV_LOVS dependencies on PO_LINE_LOCATIONS_ALL

Line 351: FROM po_line_locations_all poll

347: and nvl(pr.cancel_flag, 'N') = 'N'
348: and nvl(pr.approved_flag, 'N') <> 'N'
349: and nvl(pr.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
350: AND exists (SELECT 'Valid PO Shipments' --Added the exists to fix bug4350175
351: FROM po_line_locations_all poll
352: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
353: , mtl_parameters mp,
354: rcv_parameters rp
355: -- End for Bug 7440217

Line 722: PO_LINE_LOCATIONS_ALL PLL,

718: RCV_SHIPMENT_LINES RSL,
719: RCV_TRANSACTIONS RT,
720: RCV_SHIPMENT_HEADERS RSH,
721: PO_LOOKUP_CODES PLC,
722: PO_LINE_LOCATIONS_ALL PLL,
723: HR_ALL_ORGANIZATION_UNITS_TL OOD
724: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
725: , mtl_parameters mp,
726: rcv_parameters rp

Line 1117: PO_LINE_LOCATIONS_ALL PLL,

1113: RCV_TRANSACTIONS RT,
1114: RCV_SHIPMENT_HEADERS RSH,
1115: RCV_SHIPMENT_LINES RSL,
1116: PO_LOOKUP_CODES PLC,
1117: PO_LINE_LOCATIONS_ALL PLL,
1118: mtl_parameters mp --BUG 5166887
1119: WHERE RSUP.SUPPLY_TYPE_CODE = 'RECEIVING'
1120: AND RT.TRANSACTION_TYPE <> 'UNORDERED'
1121: AND RT.TRANSACTION_TYPE = PLC.LOOKUP_CODE

Line 3247: , po_line_locations_all pll

3243: select distinct pr.release_num
3244: , pr.po_release_id
3245: , pr.release_date
3246: from po_releases_all pr
3247: , po_line_locations_all pll
3248: , po_lines_all pl
3249: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3250: , mtl_parameters mp
3251: , rcv_parameters rp