APPS.PO_POXPOBPS_XMLP_PKG dependencies on PO_LINE_LOCATIONS

Line 146: FROM PO_LINE_LOCATIONS PLL

142: SELECT SUM( (nvl(PLL.quantity,0) -
143: nvl(PLL.quantity_cancelled,0) ) *
144: nvl(PLL.price_override,0))
145: INTO X_TOTAL
146: FROM PO_LINE_LOCATIONS PLL
147: WHERE PLL.po_header_id = po_header_id1
148: AND PLL.shipment_type = 'PLANNED';
149:
150: ELSE

Line 182: FROM PO_LINE_LOCATIONS PLL

178: SELECT sum((pll.quantity -
179: nvl(pll.quantity_cancelled,0))*
180: nvl(pll.price_override,0))
181: INTO X_TOTAL
182: FROM PO_LINE_LOCATIONS PLL
183: WHERE PLL.po_header_id = PO_HEADER_ID1
184: AND PLL.shipment_type = 'SCHEDULED';
185:
186:

Line 229: FROM po_line_locations pll,

225: 'FIXED PRICE', PLL.amount - NVL(PLL.amount_cancelled, 0),
226: (NVL(PLL.quantity, 0) - NVL(PLL.quantity_cancelled, 0))
227: * NVL(PLL.price_override, 0)))
228: INTO X_RELEASED_AMT
229: FROM po_line_locations pll,
230: po_headers poh,
231: po_lines POL
232: WHERE poh.po_header_id = POL.po_header_id
233: AND POL.po_line_id = PLL.po_line_id

Line 247: FROM po_line_locations_all pll,

243: 'FIXED PRICE', PLL.amount - NVL(PLL.amount_cancelled, 0),
244: (NVL(PLL.quantity, 0) - NVL(PLL.quantity_cancelled, 0))
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

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;

Line 324: FROM po_line_locations pll

320: 'FIXED PRICE', PLL.amount - NVL(PLL.amount_cancelled, 0),
321: (nvl(pll.quantity,0) - nvl(pll.quantity_cancelled,0))
322: * nvl(price_override,0)))) REMAIN
323: INTO X_REMAIN_AMT
324: FROM po_line_locations pll
325: , po_headers poh
326: , po_lines POL
327: WHERE poh.po_header_id = POL.po_header_id(+)
328: AND POL.po_line_id = PLL.po_line_id (+)