APPS.CSTPALPC dependencies on PO_LINE_LOCATIONS_ALL

Line 332: from po_line_locations_all poll

328: --pick up global procurement receipts even if set to period end accrual,
329: --since period end will apply only to supplier facing org.
330: AND exists (
331: select 1
332: from po_line_locations_all poll
333: where poll.line_location_id = rt.po_line_location_id and
334: poll.shipment_type <>'PREPAYMENT' and -- Added for complex work procurement
335: (poll.transaction_flow_header_id is not null or
336: ( poll.accrue_on_receipt_flag = 'Y' and

Line 378: from po_line_locations_all poll

374: --period end.
375: AND ( nvl(rae.procurement_org_flag, 'N') = 'N'
376: OR EXISTS (
377: select 1
378: from po_line_locations_all poll
379: where poll.line_location_id = rt.po_line_location_id and
380: poll.accrue_on_receipt_flag = 'Y' and
381: not exists (
382: select 1

Line 642: po_line_locations_all poll,

638: AND exists (
639: select
640: 1
641: from
642: po_line_locations_all poll,
643: po_headers_all poh /*Added for bug 5352511 */
644: where poll.line_location_id = rt.po_line_location_id and
645: poll.accrue_on_receipt_flag = 'N' and /* Begin Bug5352511 */
646: poh.po_header_id = poll.po_header_id and