APPS.POS_WC_CREATE_UPDATE_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 229: PO_LINE_LOCATIONS_ALL POLL

225: SUM(NVL(RSL.AMOUNT, RSL.QUANTITY_SHIPPED*POLL.PRICE_OVERRIDE))
226: INTO x_po_approved
227: FROM RCV_SHIPMENT_HEADERS RSH,
228: RCV_SHIPMENT_LINES RSL,
229: PO_LINE_LOCATIONS_ALL POLL
230: WHERE RSL.po_header_id = p_po_header_id
231: AND RSL.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
232: AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
233: AND RSH.APPROVAL_STATUS = 'APPROVED'

Line 284: FROM PO_LINE_LOCATIONS_ALL POLL

280: NVL((POLL.QUANTITY - NVL(POLL.QUANTITY_CANCELLED,0))
281: *POLL.PRICE_OVERRIDE,
282: (POLL.AMOUNT - NVL(POLL.AMOUNT_CANCELLED,0))))
283: INTO l_po_ordered
284: FROM PO_LINE_LOCATIONS_ALL POLL
285: WHERE POLL.PO_HEADER_ID = p_po_header_id;
286:
287: x_po_ordered := l_po_ordered;
288: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 316: PO_LINE_LOCATIONS_ALL POLL

312: SELECT SUM(NVL(RTI.AMOUNT, RTI.QUANTITY*POLL.PRICE_OVERRIDE))
313: INTO l_intf_request
314: FROM RCV_TRANSACTIONS_INTERFACE RTI,
315: RCV_HEADERS_INTERFACE RHI,
316: PO_LINE_LOCATIONS_ALL POLL
317: WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID and
318: RTI.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
319: RHI.HEADER_INTERFACE_ID = p_wc_id;
320:

Line 327: PO_LINE_LOCATIONS_ALL POLL

323: SELECT SUM(NVL(RSL.AMOUNT_SHIPPED, RSL.QUANTITY_SHIPPED*POLL.PRICE_OVERRIDE))
324: INTO l_ship_request
325: FROM RCV_SHIPMENT_LINES RSL,
326: RCV_SHIPMENT_HEADERS RSH,
327: PO_LINE_LOCATIONS_ALL POLL
328: WHERE RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND
329: RSL.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
330: RSH.SHIPMENT_HEADER_ID = p_wc_id;
331: END IF;

Line 412: PO_LINE_LOCATIONS_ALL POLL

408: l_quantity_ordered,
409: l_matching_basis,
410: l_line_location_id
411: FROM RCV_SHIPMENT_LINES RSL,
412: PO_LINE_LOCATIONS_ALL POLL
413: WHERE RSL.shipment_line_id = p_wc_pay_item_id and
414: POLL.line_location_id = RSL.po_line_location_id;
415:
416: else --currently not supporting 'INTERFACE' stage

Line 526: FROM PO_LINE_LOCATIONS_ALL POLL,

522: --First dig through the Interface table (PROCESSING)
523: BEGIN
524: SELECT sum(NVL(RTI.AMOUNT,RTI.QUANTITY))
525: INTO l_wc_prev_submitted_intf
526: FROM PO_LINE_LOCATIONS_ALL POLL,
527: RCV_TRANSACTIONS_INTERFACE RTI,
528: RCV_HEADERS_INTERFACE RHI
529: WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
530: RTI.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND

Line 552: FROM PO_LINE_LOCATIONS_ALL POLL,

548: BEGIN
549:
550: SELECT sum(NVL(RSL.AMOUNT_SHIPPED, RSL.QUANTITY_SHIPPED))
551: INTO l_wc_prev_submitted_ship
552: FROM PO_LINE_LOCATIONS_ALL POLL,
553: RCV_SHIPMENT_HEADERS RSH,
554: RCV_SHIPMENT_LINES RSL
555: WHERE RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND
556: RSL.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND