2281: , pol.item_id
2282: , pol.category_id
2283: , DECODE(nvl(pol.cancel_flag, 'N'), 'N', NVL(poll.cancel_flag, 'N'), pol.cancel_flag)
2284: , DECODE(nvl(pol.closed_code, 'OPEN'), 'OPEN', NVL(poll.closed_code, 'OPEN'), pol.closed_code)
2285: FROM po_headers poh
2286: , po_lines pol
2287: , po_line_locations poll
2288: , po_distributions pod
2289: WHERE poh.po_header_id = p_document_id
2394: , NULL
2395: , NULL
2396: , 'N'
2397: , 'OPEN' -- Bug 4610058
2398: FROM po_headers poh
2399: WHERE poh.po_header_id = p_document_id;
2400:
2401: d_progress := 60;
2402:
2424: , pol.item_id -- Bug 4610058
2425: , pol.category_id -- Bug 4610058
2426: , NVL(pol.cancel_flag, 'N') -- Bug 4610058
2427: , 'OPEN' -- Bug 4610058
2428: FROM po_headers poh
2429: , po_lines pol
2430: WHERE poh.po_header_id = p_document_id
2431: AND pol.po_header_id = poh.po_header_id
2432: AND NVL(pol.cancel_flag, 'N') = 'N';