DBA Data[Home] [Help]

APPS.POA_DBI_SAVINGS_PKG dependencies on PO_LINES_ALL

Line 43: from po_lines_all bl

39: select bl.po_header_id,b.vendor_id,bl.po_line_id,bl.price_break_lookup_code
40: ,bl.unit_price,bl.min_release_amount bl_min,bl.expiration_date
41: ,b.min_release_amount b_min,b.amount_limit , b.global_agreement_flag
42: ,0 line_qty,0 line_all_qty, gl.currency_code bl_func_cur_code, b.rate bl_rate
43: from po_lines_all bl
44: ,po_headers_all b
45: ,financials_system_params_all fsp
46: ,gl_sets_of_books gl
47: where bl.item_id = p_item_id

Line 200: ,po_lines_all pol

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
204: and sll.shipment_type (+) = 'STANDARD'