APPS.CSTPALPC dependencies on PO_LINE_LOCATIONS_ALL

Line 306: from po_line_locations_all poll

302: --pick up global procurement receipts even if set to period end accrual,
303: --since period end will apply only to supplier facing org.
304: AND exists (
305: select 1
306: from po_line_locations_all poll
307: where poll.line_location_id = rt.po_line_location_id and
308: poll.shipment_type <>'PREPAYMENT' and -- Added for complex work procurement
309: (poll.transaction_flow_header_id is not null or
310: ( poll.accrue_on_receipt_flag = 'Y' and

Line 353: from po_line_locations_all poll

349: --period end.
350: AND ( nvl(rae.procurement_org_flag, 'N') = 'N'
351: OR EXISTS (
352: select 1
353: from po_line_locations_all poll
354: where poll.line_location_id = rt.po_line_location_id and
355: poll.accrue_on_receipt_flag = 'Y' and
356: not exists (
357: select 1

Line 617: po_line_locations_all poll,

613: AND exists (
614: select
615: 1
616: from
617: po_line_locations_all poll,
618: po_headers_all poh /*Added for bug 5352511 */
619: where poll.line_location_id = rt.po_line_location_id and
620: poll.accrue_on_receipt_flag = 'N' and /* Begin Bug5352511 */
621: poh.po_header_id = poll.po_header_id and