APPS.POS_WC_VIEW_CANCEL_PVT dependencies on RCV_SHIPMENT_HEADERS

Line 163: -- for table RCV_SHIPMENT_HEADERS. It identifies the

159: --Parameter :
160: --IN : p_wc_id IN NUMBER Required
161: -- corresponds to the column HEADER_INTERFACE_ID for
162: -- table RCV_HEADERS_INTERFACE; or SHIPMENT_HEADER_ID
163: -- for table RCV_SHIPMENT_HEADERS. It identifies the
164: -- WC for which the information should be retrieved.
165: -- p_wc_stage IN VARCHAR2 Required
166: -- specifies the stage of the WC (INTERFACE or SHIPMENT)
167: -- p_po_header_id IN NUMBER Required

Line 713: RCV_SHIPMENT_HEADERS RSH,

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
717: RSL.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND

Line 739: RCV_SHIPMENT_HEADERS RSH,

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
743: RSL.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND

Line 847: RCV_SHIPMENT_HEADERS RSH,

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
851: POLL.PAYMENT_TYPE in ('MILESTONE', 'LUMPSUM', 'RATE') AND

Line 857: RCV_SHIPMENT_HEADERS RSH,

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
861: POLL.PAYMENT_TYPE = 'DELIVERY' AND

Line 997: FROM RCV_SHIPMENT_HEADERS RSH

993: IF (l_cancellation_status = 'NO_CANCELLATION') THEN
994:
995: SELECT RSH.APPROVAL_STATUS
996: INTO l_header_approval_status
997: FROM RCV_SHIPMENT_HEADERS RSH
998: WHERE RSH.SHIPMENT_HEADER_ID = p_wc_id;
999:
1000: IF(l_header_approval_status is null) THEN
1001:

Line 1022: RCV_SHIPMENT_HEADERS RSH,

1018:
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

Line 1158: RCV_SHIPMENT_HEADERS rsh

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:
1162: if (x_total_lines = 0) then

Line 1170: RCV_SHIPMENT_HEADERS rsh

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';
1174:

Line 1179: RCV_SHIPMENT_HEADERS rsh

1175: /* Get total number of lines pending cancellation */
1176: select count(*)
1177: into x_pending_cancel
1178: from RCV_TRANSACTIONS_INTERFACE rti,
1179: RCV_SHIPMENT_HEADERS rsh
1180: where rti.transaction_type = 'CANCEL'
1181: and rti.shipment_header_id = rsh.shipment_header_id
1182: and rsh.shipment_header_id = p_wc_id;
1183:

Line 1257: from rcv_shipment_headers

1253: l_wf_itemkey Varchar2(280);
1254:
1255: cursor ship_header_cursor(p_header_id number) is
1256: select wf_item_type, wf_item_key
1257: from rcv_shipment_headers
1258: where shipment_header_id = p_header_id;
1259:
1260: CURSOR l_wc_pay_item_csr IS
1261: SELECT rsl.shipment_line_id

Line 1263: RCV_SHIPMENT_HEADERS rsh

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:
1267: BEGIN