APPS.POS_WC_VIEW_CANCEL_PVT dependencies on RCV_TRANSACTIONS

Line 404: RCV_TRANSACTIONS_INTERFACE RTI,

400: POH.CURRENCY_CODE
401: INTO
402: l_po_header_id, x_po_num, x_po_currency_code
403: FROM
404: RCV_TRANSACTIONS_INTERFACE RTI,
405: PO_HEADERS_ALL POH
406: WHERE
407: POH.PO_HEADER_ID = RTI.PO_HEADER_ID AND
408: RTI.HEADER_INTERFACE_ID = p_wc_header_id;

Line 657: RCV_TRANSACTIONS_INTERFACE RTI,

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
661: RTI.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND

Line 683: RCV_TRANSACTIONS_INTERFACE RTI,

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
687: RTI.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND

Line 823: FROM RCV_TRANSACTIONS_INTERFACE RTI,

819:
820: SELECT SUM(NVL(RTI.REQUESTED_AMOUNT, RTI.QUANTITY*POLL.PRICE_OVERRIDE)),
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

Line 833: FROM RCV_TRANSACTIONS_INTERFACE RTI,

829: RHI.HEADER_INTERFACE_ID = p_wc_id;
830:
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

Line 1014: FROM RCV_TRANSACTIONS

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
1014: FROM RCV_TRANSACTIONS
1015: WHERE TRANSACTION_TYPE = 'DELIVER' AND
1016: SHIPMENT_HEADER_ID = p_wc_id;
1017:
1018: --Get number of the shipment lines that have been errored out

Line 1020: FROM RCV_TRANSACTIONS_INTERFACE RTI,

1016: SHIPMENT_HEADER_ID = p_wc_id;
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

Line 1150: from RCV_TRANSACTIONS_INTERFACE rti,

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

Line 1257: UPDATE RCV_TRANSACTIONS_INTERFACE

1253: -- Should put business logic here to make sure we can cancel the WC
1254:
1255: IF(p_wc_status = 'PROCESSING') THEN
1256:
1257: UPDATE RCV_TRANSACTIONS_INTERFACE
1258: SET PROCESSING_STATUS_CODE = 'CANCELLED'
1259: WHERE HEADER_INTERFACE_ID = p_wc_id;
1260:
1261:

Line 1789: FROM RCV_TRANSACTIONS_INTERFACE RTI,

1785:
1786: CURSOR l_wc_attach_csr (l_header_intf_id NUMBER)
1787: IS
1788: SELECT DISTINCT RTI.ASN_ATTACH_ID
1789: FROM RCV_TRANSACTIONS_INTERFACE RTI,
1790: FND_ATTACHED_DOCUMENTS FAD
1791: WHERE RTI.HEADER_INTERFACE_ID = L_HEADER_INTF_ID
1792: AND RTI.ASN_ATTACH_ID IS NOT NULL
1793: AND TO_CHAR(RTI.ASN_ATTACH_ID) = FAD.PK1_VALUE

Line 1829: DELETE FROM RCV_TRANSACTIONS_INTERFACE

1825: END LOOP;
1826: CLOSE l_wc_attach_csr;
1827:
1828: /* Delete WC line from interface table. */
1829: DELETE FROM RCV_TRANSACTIONS_INTERFACE
1830: WHERE header_interface_id = l_header_interface_id;
1831:
1832: END IF;
1833: