DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_CHECK dependencies on PO_DISTRIBUTIONS

Line 2288: , po_distributions pod

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
2290: AND pol.po_header_id = poh.po_header_id
2291: AND poll.po_line_id = pol.po_line_id
2292: AND poll.shipment_type <> 'PREPAYMENT' --

Line 2365: FROM po_distributions pod

2361: , pol.item_id
2362: , pol.category_id
2363: , DECODE(nvl(pol.cancel_flag, 'N'), 'N', NVL(poll.cancel_flag, 'N'), pol.cancel_flag)
2364: , DECODE(nvl(pol.closed_code, 'OPEN'), 'OPEN', NVL(poll.closed_code, 'OPEN'), pol.closed_code)
2365: FROM po_distributions pod
2366: , po_line_locations poll
2367: , po_lines pol
2368: WHERE poll.po_release_id = p_document_id
2369: AND poll.po_line_id = pol.po_line_id