APPS.POA_DBI_SAVINGS_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 115: from po_line_locations_all pb

111: or (p_price_break_lookup_code = 'CUMULATIVE' and p_quantity + p_line_all_qty >= pb.quantity))
112: then pb.price_override else null end) generic_price,
113: creation_date,
114: pb.quantity
115: from po_line_locations_all pb
116: where pb.po_line_id = p_po_line_id
117: and pb.shipment_type = 'PRICE BREAK'
118: and p_quantity * nvl(pb.price_override,p_unit_price) >= nvl(p_bl_min,0)
119: and p_quantity * nvl(pb.price_override,p_unit_price) >= nvl(p_b_min,0)

Line 198: from po_line_locations_all sll

194: sum(case when sll.approved_flag='Y' and sll.ship_to_location_id=p_ship_to_location_id then nvl(sd.quantity_ordered,0)-nvl(sd.quantity_cancelled,0) else 0 end) line_qty
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

Line 217: from po_line_locations_all rll

213: ,sum(case when rll.approved_flag='Y' then
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'