DBA Data[Home] [Help]

APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 1304: FROM po_distributions_all pod,

1300: pod.quantity_billed,
1301: NVL(pod.encumbered_flag,'N'),
1302: pod.gl_encumbered_date,
1303: pod.gl_encumbered_period_name
1304: FROM po_distributions_all pod,
1305: po_line_locations_all poll,
1306: po_lines_all pol
1307: WHERE DECODE(poll.accrue_on_receipt_flag,
1308: 'N',

Line 1517: FROM po_distributions_all pod,

1513: pod.unencumbered_quantity,
1514: Nvl(pod.encumbered_flag,'N'),
1515: pod.gl_encumbered_date,
1516: pod.gl_encumbered_period_name
1517: FROM po_distributions_all pod,
1518: po_headers_all poh
1519: WHERE (Nvl(pod.encumbered_amount+ pod.unencumbered_amount,0) > 0
1520: AND Nvl(pod.encumbered_amount+ pod.unencumbered_amount,0) <> Nvl(pod.unencumbered_amount,0)
1521: OR Nvl(pod.encumbered_amount+ pod.unencumbered_amount,0) <> Nvl(poh.blanket_total_amount,0))