eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POA_DBI_SAVINGS_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 199: ,po_distributions_all sd

195: ,sum(case when sll.approved_flag='Y' then nvl(sd.quantity_ordered,0)-nvl(sd.quantity_cancelled,0) else 0 end) line_all_qty
196: ,sum(sum(nvl(sll.price_override,0)*(nvl(sd.quantity_ordered,0)-nvl(sd.quantity_cancelled,0)))) over () blanket_amt
197: into rline_q, rline_qa, rline_a
198: from po_line_locations_all sll
199: ,po_distributions_all sd
200: ,po_lines_all pol
201: where pol.po_line_id = sll.po_line_id (+)
202: and pol.from_header_id = l_pbline.po_header_id
203: and pol.from_line_id = l_pbline.po_line_id

Line 218: ,po_distributions_all rd

214: nvl(rd.quantity_ordered,0)-nvl(rd.quantity_cancelled,0) else 0 end) line_all_qty
215: ,sum(sum(nvl(rll.price_override,0)*(nvl(rd.quantity_ordered,0)-nvl(rd.quantity_cancelled,0)))) over () blanket_amt
216: into rline_q, rline_qa, rline_a
217: from po_line_locations_all rll
218: ,po_distributions_all rd
219: where rll.po_header_id = l_pbline.po_header_id
220: and rll.po_line_id = l_pbline.po_line_id
221: and rll.shipment_type = 'BLANKET'
222: and nvl(rd.distribution_type,'-99') <> 'AGREEMENT'