DBA Data[Home] [Help]

APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 1305: FROM po_distributions_all pod,

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

Line 1518: FROM po_distributions_all pod,

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