[Home] [Help]
135: NVL((POLL.QUANTITY - NVL(POLL.QUANTITY_CANCELLED,0))
136: *POLL.PRICE_OVERRIDE,
137: (POLL.AMOUNT - NVL(POLL.AMOUNT_CANCELLED,0))))
138: INTO x_pay_item_total
139: FROM PO_LINE_LOCATIONS_ALL POLL
140: WHERE POLL.PO_HEADER_ID = p_po_header_id AND
141: POLL.PAYMENT_TYPE in ('MILESTONE', 'RATE', 'LUMPSUM');
142:
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
445: NVL((POLL.QUANTITY - NVL(POLL.QUANTITY_CANCELLED,0))
446: *POLL.PRICE_OVERRIDE,
447: (POLL.AMOUNT - NVL(POLL.AMOUNT_CANCELLED,0))))
448: INTO x_po_lines_ordered
449: FROM PO_LINE_LOCATIONS_ALL POLL
450: WHERE POLL.PO_HEADER_ID = l_po_header_id AND
451: POLL.PAYMENT_TYPE in ('MILESTONE', 'RATE', 'LUMPSUM');
452:
453: x_po_header_id := l_po_header_id;
523: CURSOR l_amt_approved_csr IS
524: select SUM(DECODE(PLL.matching_basis,
525: 'AMOUNT', NVL(PLL.amount_received, 0),
526: 'QUANTITY', NVL(PLL.quantity_received, 0)*NVL(PLL.price_override, 0)))
527: from PO_LINE_LOCATIONS_ALL PLL
528: where PLL.po_header_id = p_po_header_id
529: and PLL.payment_type in ('MILESTONE', 'RATE', 'LUMPSUM');
530:
531: BEGIN
652: */
653: SELECT SUM( NVL(RTI.AMOUNT, RTI.QUANTITY*POLL.PRICE_OVERRIDE))
654: INTO l_wc_intf_prev_submitted
655: FROM
656: PO_LINE_LOCATIONS_ALL POLL,
657: RCV_TRANSACTIONS_INTERFACE RTI,
658: RCV_HEADERS_INTERFACE RHI
659: WHERE
660: RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
678: */
679: SELECT SUM( NVL(RTI.AMOUNT, RTI.QUANTITY*POLL.PRICE_OVERRIDE))
680: INTO l_wc_intf_prev_delivered
681: FROM
682: PO_LINE_LOCATIONS_ALL POLL,
683: RCV_TRANSACTIONS_INTERFACE RTI,
684: RCV_HEADERS_INTERFACE RHI
685: WHERE
686: RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
708: */
709: SELECT SUM(NVL(RSL.AMOUNT_SHIPPED,RSL.QUANTITY_SHIPPED*POLL.PRICE_OVERRIDE))
710: INTO l_wc_ship_prev_submitted
711: FROM
712: PO_LINE_LOCATIONS_ALL POLL,
713: RCV_SHIPMENT_HEADERS RSH,
714: RCV_SHIPMENT_LINES RSL
715: WHERE
716: RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND
734: */
735: SELECT SUM(NVL(RSL.AMOUNT_SHIPPED,RSL.QUANTITY_SHIPPED*POLL.PRICE_OVERRIDE))
736: INTO l_wc_ship_prev_delivered
737: FROM
738: PO_LINE_LOCATIONS_ALL POLL,
739: RCV_SHIPMENT_HEADERS RSH,
740: RCV_SHIPMENT_LINES RSL
741: WHERE
742: RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND
821: SUM(NVL(RTI.MATERIAL_STORED_AMOUNT,0))
822: INTO l_requested, l_material
823: FROM RCV_TRANSACTIONS_INTERFACE RTI,
824: RCV_HEADERS_INTERFACE RHI,
825: PO_LINE_LOCATIONS_ALL POLL
826: WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
827: RTI.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
828: POLL.PAYMENT_TYPE in ('MILESTONE', 'LUMPSUM', 'RATE') AND
829: RHI.HEADER_INTERFACE_ID = p_wc_id;
831: SELECT SUM(NVL(RTI.AMOUNT, RTI.QUANTITY*POLL.PRICE_OVERRIDE))
832: INTO l_delivery
833: FROM RCV_TRANSACTIONS_INTERFACE RTI,
834: RCV_HEADERS_INTERFACE RHI,
835: PO_LINE_LOCATIONS_ALL POLL
836: WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
837: RTI.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
838: POLL.PAYMENT_TYPE = 'DELIVERY' AND
839: RHI.HEADER_INTERFACE_ID = p_wc_id;
844: SUM(NVL(RSL.MATERIAL_STORED_AMOUNT,0))
845: INTO l_requested, l_material
846: FROM RCV_SHIPMENT_LINES RSL,
847: RCV_SHIPMENT_HEADERS RSH,
848: PO_LINE_LOCATIONS_ALL POLL
849: WHERE RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND
850: RSL.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
851: POLL.PAYMENT_TYPE in ('MILESTONE', 'LUMPSUM', 'RATE') AND
852: RSH.SHIPMENT_HEADER_ID = p_wc_id;
854: SELECT SUM(NVL(RSL.AMOUNT_SHIPPED,RSL.QUANTITY_SHIPPED*POLL.PRICE_OVERRIDE))
855: INTO l_delivery
856: FROM RCV_SHIPMENT_LINES RSL,
857: RCV_SHIPMENT_HEADERS RSH,
858: PO_LINE_LOCATIONS_ALL POLL
859: WHERE RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND
860: RSL.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
861: POLL.PAYMENT_TYPE = 'DELIVERY' AND
862: RSH.SHIPMENT_HEADER_ID = p_wc_id;
1475: l_matching_basis,
1476: l_org_id
1477: FROM
1478: RCV_SHIPMENT_LINES RSL,
1479: PO_LINE_LOCATIONS_ALL POLL
1480: WHERE
1481: RSL.shipment_line_id = p_shipment_line_id AND
1482: RSL.po_line_location_id = POLL.line_location_id;
1483: EXCEPTION