APPS.PO_DOCUMENT_ACTION_CHECK dependencies on PO_HEADERS

Line 2251: FROM po_headers poh

2247: , pol.item_id
2248: , pol.category_id
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

Line 2362: FROM po_headers poh

2358: , NULL
2359: , NULL
2360: , 'N'
2361: , 'OPEN' -- Bug 4610058
2362: FROM po_headers poh
2363: WHERE poh.po_header_id = p_document_id;
2364:
2365: d_progress := 60;
2366:

Line 2392: FROM po_headers poh

2388: , pol.item_id -- Bug 4610058
2389: , pol.category_id -- Bug 4610058
2390: , NVL(pol.cancel_flag, 'N') -- Bug 4610058
2391: , 'OPEN' -- Bug 4610058
2392: FROM po_headers poh
2393: , po_lines pol
2394: WHERE poh.po_header_id = p_document_id
2395: AND pol.po_header_id = poh.po_header_id
2396: AND NVL(pol.cancel_flag, 'N') = 'N';