[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,Round(RSL.QUANTITY_SHIPPED*POLL.PRICE_OVERRIDE,get_currency_precision(poll.po_header_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
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
1006: ELSIF(l_header_approval_status = 'APPROVED') THEN
1007:
1008: --Get number of shipment lines
1009: SELECT count(*) into l_wc_total_lines
1010: FROM RCV_SHIPMENT_LINES
1011: WHERE SHIPMENT_HEADER_ID = p_wc_id;
1012:
1013: --Get number of the shipment lines that have been processed
1014: SELECT count(*) into l_wc_lines_processed
1019: --Get number of the shipment lines that have been errored out
1020: SELECT count(*) into l_wc_lines_errored
1021: FROM RCV_TRANSACTIONS_INTERFACE RTI,
1022: RCV_SHIPMENT_HEADERS RSH,
1023: RCV_SHIPMENT_LINES RSL
1024: WHERE RTI.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID AND
1025: RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND
1026: RTI.PROCESSING_STATUS_CODE in ('ERROR','COMPLETED') AND
1027: RTI.TRANSACTION_STATUS_CODE = 'ERROR' AND
1153:
1154: /* Get total number of lines */
1155: select count(*)
1156: into x_total_lines
1157: from RCV_SHIPMENT_LINES rsl,
1158: RCV_SHIPMENT_HEADERS rsh
1159: where rsh.shipment_header_id= p_wc_id
1160: and rsh.shipment_header_id = rsl.shipment_header_id;
1161:
1165:
1166: /* Get total number of cancelled lines */
1167: select count(*)
1168: into x_cancelled_lines
1169: from RCV_SHIPMENT_LINES rsl,
1170: RCV_SHIPMENT_HEADERS rsh
1171: where rsh.shipment_header_id = p_wc_id
1172: and rsh.shipment_header_id = rsl.shipment_header_id
1173: and rsl.shipment_line_status_code = 'CANCELLED';
1258: where shipment_header_id = p_header_id;
1259:
1260: CURSOR l_wc_pay_item_csr IS
1261: SELECT rsl.shipment_line_id
1262: FROM RCV_SHIPMENT_LINES rsl,
1263: RCV_SHIPMENT_HEADERS rsh
1264: WHERE rsh.SHIPMENT_HEADER_ID = p_wc_id
1265: AND rsh.shipment_header_id = rsl.shipment_header_id;
1266:
1401: --Function : Cancel a WC Pay Item
1402: --Parameter :
1403: --IN : p_shipment_line_id IN NUMBER Required
1404: -- corresponds to the column SHIPMENT_LINE_ID in
1405: -- the table RCV_SHIPMENT_LINES.
1406: --OUT : x_return_status OUT VARCHAR2
1407: -- return status of the procedure.
1408: -- x_return_msg OUT VARCHAR2
1409: -- return message of the procedure.
1512: l_material_stored_amount,
1513: l_matching_basis,
1514: l_org_id
1515: FROM
1516: RCV_SHIPMENT_LINES RSL,
1517: PO_LINE_LOCATIONS_ALL POLL
1518: WHERE
1519: RSL.shipment_line_id = p_shipment_line_id AND
1520: RSL.po_line_location_id = POLL.line_location_id;