[Home] [Help]
415: POH.CURRENCY_CODE
416: INTO
417: l_po_header_id, x_po_num, x_po_currency_code
418: FROM
419: RCV_SHIPMENT_LINES RSL,
420: PO_HEADERS_ALL POH
421: WHERE
422: POH.PO_HEADER_ID = RSL.PO_HEADER_ID AND
423: RSL.SHIPMENT_HEADER_ID = p_wc_header_id;
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
717: RSL.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
718: (RSL.APPROVAL_STATUS is NULL OR
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
743: RSL.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
744: (RSL.APPROVAL_STATUS is NULL OR
842:
843: SELECT SUM(NVL(RSL.REQUESTED_AMOUNT,RSL.QUANTITY_SHIPPED*POLL.PRICE_OVERRIDE)),
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
852: RSH.SHIPMENT_HEADER_ID = p_wc_id;
853:
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
1005: ELSIF(l_header_approval_status = 'APPROVED') THEN
1006:
1007: --Get number of shipment lines
1008: SELECT count(*) into l_wc_total_lines
1009: FROM RCV_SHIPMENT_LINES
1010: WHERE SHIPMENT_HEADER_ID = p_wc_id;
1011:
1012: --Get number of the shipment lines that have been processed
1013: SELECT count(*) into l_wc_lines_processed
1018: --Get number of the shipment lines that have been errored out
1019: SELECT count(*) into l_wc_lines_errored
1020: FROM RCV_TRANSACTIONS_INTERFACE RTI,
1021: RCV_SHIPMENT_HEADERS RSH,
1022: RCV_SHIPMENT_LINES RSL
1023: WHERE RTI.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID AND
1024: RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND
1025: RTI.PROCESSING_STATUS_CODE in ('ERROR','COMPLETED') AND
1026: RTI.TRANSACTION_STATUS_CODE = 'ERROR' AND
1125:
1126: /* Get total number of lines */
1127: select count(*)
1128: into x_total_lines
1129: from RCV_SHIPMENT_LINES rsl,
1130: RCV_SHIPMENT_HEADERS rsh
1131: where rsh.shipment_header_id= p_wc_id
1132: and rsh.shipment_header_id = rsl.shipment_header_id;
1133:
1137:
1138: /* Get total number of cancelled lines */
1139: select count(*)
1140: into x_cancelled_lines
1141: from RCV_SHIPMENT_LINES rsl,
1142: RCV_SHIPMENT_HEADERS rsh
1143: where rsh.shipment_header_id = p_wc_id
1144: and rsh.shipment_header_id = rsl.shipment_header_id
1145: and rsl.shipment_line_status_code = 'CANCELLED';
1230: where shipment_header_id = p_header_id;
1231:
1232: CURSOR l_wc_pay_item_csr IS
1233: SELECT rsl.shipment_line_id
1234: FROM RCV_SHIPMENT_LINES rsl,
1235: RCV_SHIPMENT_HEADERS rsh
1236: WHERE rsh.SHIPMENT_HEADER_ID = p_wc_id
1237: AND rsh.shipment_header_id = rsl.shipment_header_id;
1238:
1363: --Function : Cancel a WC Pay Item
1364: --Parameter :
1365: --IN : p_shipment_line_id IN NUMBER Required
1366: -- corresponds to the column SHIPMENT_LINE_ID in
1367: -- the table RCV_SHIPMENT_LINES.
1368: --OUT : x_return_status OUT VARCHAR2
1369: -- return status of the procedure.
1370: -- x_return_msg OUT VARCHAR2
1371: -- return message of the procedure.
1474: l_material_stored_amount,
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;