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,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
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 996: FROM RCV_SHIPMENT_HEADERS RSH

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

Line 1021: RCV_SHIPMENT_HEADERS RSH,

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

Line 1130: RCV_SHIPMENT_HEADERS rsh

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

Line 1142: RCV_SHIPMENT_HEADERS rsh

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

Line 1151: RCV_SHIPMENT_HEADERS rsh

1147: /* Get total number of lines pending cancellation */
1148: select count(*)
1149: into x_pending_cancel
1150: from RCV_TRANSACTIONS_INTERFACE rti,
1151: RCV_SHIPMENT_HEADERS rsh
1152: where rti.transaction_type = 'CANCEL'
1153: and rti.shipment_header_id = rsh.shipment_header_id
1154: and rsh.shipment_header_id = p_wc_id;
1155:

Line 1229: from rcv_shipment_headers

1225: l_wf_itemkey Varchar2(280);
1226:
1227: cursor ship_header_cursor(p_header_id number) is
1228: select wf_item_type, wf_item_key
1229: from rcv_shipment_headers
1230: where shipment_header_id = p_header_id;
1231:
1232: CURSOR l_wc_pay_item_csr IS
1233: SELECT rsl.shipment_line_id

Line 1235: RCV_SHIPMENT_HEADERS rsh

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