APPS.PO_DOCUMENT_ACTION_CHECK dependencies on PO_LINE_LOCATIONS

Line 2253: , po_line_locations poll

2249: , DECODE(nvl(pol.cancel_flag, 'N'), 'N', NVL(poll.cancel_flag, 'N'), pol.cancel_flag)
2250: , DECODE(nvl(pol.closed_code, 'OPEN'), 'OPEN', NVL(poll.closed_code, 'OPEN'), pol.closed_code)
2251: FROM po_headers poh
2252: , po_lines pol
2253: , po_line_locations poll
2254: , po_distributions pod
2255: WHERE poh.po_header_id = p_document_id
2256: AND pol.po_header_id = poh.po_header_id
2257: AND poll.po_line_id = pol.po_line_id

Line 2330: , po_line_locations poll

2326: , pol.category_id
2327: , DECODE(nvl(pol.cancel_flag, 'N'), 'N', NVL(poll.cancel_flag, 'N'), pol.cancel_flag)
2328: , DECODE(nvl(pol.closed_code, 'OPEN'), 'OPEN', NVL(poll.closed_code, 'OPEN'), pol.closed_code)
2329: FROM po_distributions pod
2330: , po_line_locations poll
2331: , po_lines pol
2332: WHERE poll.po_release_id = p_document_id
2333: AND poll.po_line_id = pol.po_line_id
2334: AND pod.line_location_id = poll.line_location_id;