DBA Data[Home] [Help]

APPS.PO_POXPOBPS_XMLP_PKG dependencies on PO_LINES_ALL

Line 249: po_lines_all POL

245: * NVL(PLL.price_override, 0)))
246: INTO X_RELEASED_AMT
247: FROM po_line_locations_all pll,
248: po_headers_all poh,
249: po_lines_all POL
250: WHERE poh.po_header_id = pll.from_header_id
251: AND POH.po_header_id = POL.po_header_id
252: AND POL.po_line_id = PLL.from_line_id
253: AND pll.shipment_type not in ('PRICE BREAK')

Line 302: FROM po_distributions_all pod, po_line_locations_all poll, po_lines_all pol,po_headers poh

298: SELECT (min(poh.blanket_total_amount)- sum( round(
299: (decode (pol.quantity, null, (pod.amount_ordered - pod.amount_cancelled),
300: (( pod.quantity_ordered - pod.quantity_cancelled ) * poll.price_override)))
301: ))) REMAIN into x_remain_amt
302: FROM po_distributions_all pod, po_line_locations_all poll, po_lines_all pol,po_headers poh
303: WHERE pod.line_location_id = poll.line_location_id AND
304: poll.po_line_id = pol.po_line_id AND
305: pol.from_header_id =po_header_id1
306: and poh.po_header_id=po_header_id1;