APPS.PO_DOCUMENT_CANCEL_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 324: po_line_locations_all POLL

320: SELECT count(*)
321: INTO l_cto_order
322: FROM po_requisition_headers_all PRH,
323: po_requisition_lines_all PRL,
324: po_line_locations_all POLL
325: WHERE PRH.interface_source_code = 'CTO'
326: AND PRH.requisition_header_id = PRL.requisition_header_id
327: AND PRL.line_location_id = POLL.line_location_id
328: AND ((p_doc_type = 'PO') AND (POLL.po_header_id = p_doc_id)

Line 491: po_line_locations_all poll,

487: --: rewrote this SQL state to use the tie between
488: --PO dist and Req dist instead of Req line to PO line loc.
489: SELECT DISTINCT(prd.requisition_line_id)
490: FROM po_req_distributions_all prd,
491: po_line_locations_all poll,
492: po_distributions_all pod
493: WHERE pod.line_location_id = p_doc_line_loc_id
494: AND pod.line_location_id = poll.line_location_id
495: AND pod.req_distribution_id = prd.distribution_id

Line 508: po_line_locations_all poll,

504: --: rewrote this SQL state to use the tie between
505: --PO dist and Req dist instead of Req line to PO line loc.
506: SELECT DISTINCT(prd.requisition_line_id)
507: FROM po_req_distributions_all prd,
508: po_line_locations_all poll,
509: po_distributions_all pod
510: WHERE pod.po_line_id = p_doc_line_id
511: AND pod.line_location_id = poll.line_location_id
512: AND pod.req_distribution_id = prd.distribution_id

Line 525: po_line_locations_all poll,

521: --: rewrote this SQL state to use the tie between
522: --PO dist and Req dist instead of Req line to PO line loc.
523: SELECT DISTINCT(prd.requisition_line_id)
524: FROM po_req_distributions_all prd,
525: po_line_locations_all poll,
526: po_distributions_all pod
527: WHERE pod.po_header_id = p_doc_id
528: AND pod.line_location_id = poll.line_location_id
529: AND pod.req_distribution_id = prd.distribution_id