APPS.POS_WC_VIEW_CANCEL_PVT dependencies on RCV_TRANSACTIONS_INTERFACE

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, Round(RTI.QUANTITY*POLL.PRICE_OVERRIDE,get_currency_precision(poll.po_header_id)))),
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 1021: FROM RCV_TRANSACTIONS_INTERFACE RTI,

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

Line 1178: from RCV_TRANSACTIONS_INTERFACE rti,

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

Line 1285: UPDATE RCV_TRANSACTIONS_INTERFACE

1281: -- Should put business logic here to make sure we can cancel the WC
1282:
1283: IF(p_wc_status = 'PROCESSING') THEN
1284:
1285: UPDATE RCV_TRANSACTIONS_INTERFACE
1286: SET PROCESSING_STATUS_CODE = 'CANCELLED'
1287: WHERE HEADER_INTERFACE_ID = p_wc_id;
1288:
1289:

Line 1827: FROM RCV_TRANSACTIONS_INTERFACE RTI,

1823:
1824: CURSOR l_wc_attach_csr (l_header_intf_id NUMBER)
1825: IS
1826: SELECT DISTINCT RTI.ASN_ATTACH_ID
1827: FROM RCV_TRANSACTIONS_INTERFACE RTI,
1828: FND_ATTACHED_DOCUMENTS FAD
1829: WHERE RTI.HEADER_INTERFACE_ID = L_HEADER_INTF_ID
1830: AND RTI.ASN_ATTACH_ID IS NOT NULL
1831: AND TO_CHAR(RTI.ASN_ATTACH_ID) = FAD.PK1_VALUE

Line 1867: DELETE FROM RCV_TRANSACTIONS_INTERFACE

1863: END LOOP;
1864: CLOSE l_wc_attach_csr;
1865:
1866: /* Delete WC line from interface table. */
1867: DELETE FROM RCV_TRANSACTIONS_INTERFACE
1868: WHERE header_interface_id = l_header_interface_id;
1869:
1870: END IF;
1871: