DBA Data[Home] [Help]

APPS.POS_WC_CREATE_UPDATE_PVT dependencies on POS_WC_VIEW_CANCEL_PVT

Line 312: SELECT SUM(NVL(RTI.AMOUNT, Round(RTI.QUANTITY*POLL.PRICE_OVERRIDE,POS_WC_VIEW_CANCEL_PVT.get_currency_precision(poll.po_header_id))))

308: BEGIN
309:
310: IF(p_wc_stage = 'INTERFACE') THEN
311:
312: SELECT SUM(NVL(RTI.AMOUNT, Round(RTI.QUANTITY*POLL.PRICE_OVERRIDE,POS_WC_VIEW_CANCEL_PVT.get_currency_precision(poll.po_header_id))))
313: INTO l_intf_request
314: FROM RCV_TRANSACTIONS_INTERFACE RTI,
315: RCV_HEADERS_INTERFACE RHI,
316: PO_LINE_LOCATIONS_ALL POLL

Line 323: SELECT SUM(NVL(RSL.AMOUNT_SHIPPED, Round(RSL.QUANTITY_SHIPPED*POLL.PRICE_OVERRIDE,POS_WC_VIEW_CANCEL_PVT.get_currency_precision(poll.po_header_id))))

319: RHI.HEADER_INTERFACE_ID = p_wc_id;
320:
321: ELSIF(p_wc_stage = 'SHIPMENT') THEN
322:
323: SELECT SUM(NVL(RSL.AMOUNT_SHIPPED, Round(RSL.QUANTITY_SHIPPED*POLL.PRICE_OVERRIDE,POS_WC_VIEW_CANCEL_PVT.get_currency_precision(poll.po_header_id))))
324: INTO l_ship_request
325: FROM RCV_SHIPMENT_LINES RSL,
326: RCV_SHIPMENT_HEADERS RSH,
327: PO_LINE_LOCATIONS_ALL POLL