APPS.RCV_INSPECTION_GRP dependencies on RCV_TRANSACTIONS

Line 43: --BUG 5219112. Replace the view RCV_TRANSACTIONS_V with base tables

39: IS
40: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Inspection';
41: l_api_version CONSTANT NUMBER := 1.1;
42:
43: --BUG 5219112. Replace the view RCV_TRANSACTIONS_V with base tables
44: /*CURSOR C1 IS
45: SELECT RTV.RECEIPT_SOURCE_CODE,
46: RTV.SOURCE_DOCUMENT_CODE,
47: RTV.SHIPMENT_HEADER_ID,

Line 88: FROM RCV_TRANSACTIONS_V RTV

84: -- Bug# 1548597
85: RTV.SECONDARY_QUANTITY,
86: RTV.SECONDARY_UNIT_OF_MEASURE,
87: RTV.ORG_ID --
88: FROM RCV_TRANSACTIONS_V RTV
89: WHERE RTV.RCV_TRANSACTION_ID = p_transaction_id;
90: */
91:
92: /* Bug# 7440432

Line 163: RCV_TRANSACTIONS RT ,

159: , RT.UNIT_LANDED_COST -- lcm changes
160: FROM
161: RCV_SUPPLY RSUP ,
162: RCV_SHIPMENT_LINES RSL,
163: RCV_TRANSACTIONS RT ,
164: RCV_SHIPMENT_HEADERS RSH,
165: PO_LINES_ALL POL,
166: PO_LINE_LOCATIONS_ALL PLL,
167: MTL_SYSTEM_ITEMS MSI,

Line 197: FROM RCV_TRANSACTIONS

193: --REMOVE CURSOR C2 AND MERGE C3 WITH C1
194: /*
195: CURSOR C2 IS
196: SELECT MOVEMENT_ID
197: FROM RCV_TRANSACTIONS
198: WHERE TRANSACTION_ID = p_transaction_id;
199:
200: CURSOR C3(X_PO_LINE_ID NUMBER) IS
201: SELECT UNIT_MEAS_LOOKUP_CODE

Line 215: l_project_id RCV_TRANSACTIONS_INTERFACE.PROJECT_ID%TYPE;

211: l_source_doc_quantity NUMBER;
212: l_primary_quantity NUMBER;
213:
214: -- Bug 5018102
215: l_project_id RCV_TRANSACTIONS_INTERFACE.PROJECT_ID%TYPE;
216: l_task_id RCV_TRANSACTIONS_INTERFACE.TASK_ID%TYPE;
217: BEGIN
218:
219: --dbms_output.enable('1000000');

Line 216: l_task_id RCV_TRANSACTIONS_INTERFACE.TASK_ID%TYPE;

212: l_primary_quantity NUMBER;
213:
214: -- Bug 5018102
215: l_project_id RCV_TRANSACTIONS_INTERFACE.PROJECT_ID%TYPE;
216: l_task_id RCV_TRANSACTIONS_INTERFACE.TASK_ID%TYPE;
217: BEGIN
218:
219: --dbms_output.enable('1000000');
220: -- Standard Start of API savepoint

Line 449: ** Inspection transactions. Updating project_id/task_id in RTI from rcv_transactions.

445: X_unit_landed_cost => RCVT.UNIT_LANDED_COST -- lcm changes
446: );
447:
448: /* Bug 5018102 : INV process_txn() API expects project_id and task_id populated in RTI for
449: ** Inspection transactions. Updating project_id/task_id in RTI from rcv_transactions.
450: */
451:
452: SELECT project_id
453: , task_id

Line 456: FROM rcv_transactions

452: SELECT project_id
453: , task_id
454: INTO l_project_id
455: , l_task_id
456: FROM rcv_transactions
457: WHERE transaction_id = p_transaction_id;
458:
459: IF l_project_id IS NOT NULL THEN
460:

Line 461: UPDATE rcv_transactions_interface

457: WHERE transaction_id = p_transaction_id;
458:
459: IF l_project_id IS NOT NULL THEN
460:
461: UPDATE rcv_transactions_interface
462: SET project_id = l_project_id
463: , task_id = l_task_id
464: WHERE interface_transaction_id = l_interface_id;
465: