eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JMF_PROCESS_SHIKYU_RCV_TRX_PVT dependencies on RCV_TRANSACTIONS

Line 44: --1. Get all records from history table rcv_transactions corresponding to records in staging table.

40: -- COMMENT : This concurrent program will be called to process OSA Receipt,
41: -- OSA Return and RTV of SHIKYU Components at MP site. RTV of SHIKYU
42: -- Component is triggered by SHIKYU RMA at OEM site.
43: -- Following is core logic:
44: --1. Get all records from history table rcv_transactions corresponding to records in staging table.
45: --
46: --2. Club correction related records to their parent records if parent transactions are also present in staging table.
47: --
48: -- Currently only correction transaction are clubbed parent records

Line 79: -- Define a record type to contain required transaction details from rcv_transactions.

75: x_return_status OUT NOCOPY VARCHAR2
76: ) IS
77: -- p_request_id and p_group_id are optional parameters that can be specified to limit the scope of transactions to process
78:
79: -- Define a record type to contain required transaction details from rcv_transactions.
80: TYPE rcv_pending_trx_rec IS RECORD
81: ( transaction_id rcv_transactions.transaction_id%Type
82: , source_document_code rcv_transactions.source_document_code%Type
83: , transaction_type rcv_transactions.transaction_type%Type

Line 81: ( transaction_id rcv_transactions.transaction_id%Type

77: -- p_request_id and p_group_id are optional parameters that can be specified to limit the scope of transactions to process
78:
79: -- Define a record type to contain required transaction details from rcv_transactions.
80: TYPE rcv_pending_trx_rec IS RECORD
81: ( transaction_id rcv_transactions.transaction_id%Type
82: , source_document_code rcv_transactions.source_document_code%Type
83: , transaction_type rcv_transactions.transaction_type%Type
84: , primary_quantity rcv_transactions.primary_quantity%Type
85: , primary_unit_of_measure rcv_transactions.primary_unit_of_measure%Type

Line 82: , source_document_code rcv_transactions.source_document_code%Type

78:
79: -- Define a record type to contain required transaction details from rcv_transactions.
80: TYPE rcv_pending_trx_rec IS RECORD
81: ( transaction_id rcv_transactions.transaction_id%Type
82: , source_document_code rcv_transactions.source_document_code%Type
83: , transaction_type rcv_transactions.transaction_type%Type
84: , primary_quantity rcv_transactions.primary_quantity%Type
85: , primary_unit_of_measure rcv_transactions.primary_unit_of_measure%Type
86: , parent_transaction_id rcv_transactions.parent_transaction_id%Type

Line 83: , transaction_type rcv_transactions.transaction_type%Type

79: -- Define a record type to contain required transaction details from rcv_transactions.
80: TYPE rcv_pending_trx_rec IS RECORD
81: ( transaction_id rcv_transactions.transaction_id%Type
82: , source_document_code rcv_transactions.source_document_code%Type
83: , transaction_type rcv_transactions.transaction_type%Type
84: , primary_quantity rcv_transactions.primary_quantity%Type
85: , primary_unit_of_measure rcv_transactions.primary_unit_of_measure%Type
86: , parent_transaction_id rcv_transactions.parent_transaction_id%Type
87: , po_line_location_id rcv_transactions.po_line_location_id%Type

Line 84: , primary_quantity rcv_transactions.primary_quantity%Type

80: TYPE rcv_pending_trx_rec IS RECORD
81: ( transaction_id rcv_transactions.transaction_id%Type
82: , source_document_code rcv_transactions.source_document_code%Type
83: , transaction_type rcv_transactions.transaction_type%Type
84: , primary_quantity rcv_transactions.primary_quantity%Type
85: , primary_unit_of_measure rcv_transactions.primary_unit_of_measure%Type
86: , parent_transaction_id rcv_transactions.parent_transaction_id%Type
87: , po_line_location_id rcv_transactions.po_line_location_id%Type
88: , project_id rcv_transactions.project_id%Type

Line 85: , primary_unit_of_measure rcv_transactions.primary_unit_of_measure%Type

81: ( transaction_id rcv_transactions.transaction_id%Type
82: , source_document_code rcv_transactions.source_document_code%Type
83: , transaction_type rcv_transactions.transaction_type%Type
84: , primary_quantity rcv_transactions.primary_quantity%Type
85: , primary_unit_of_measure rcv_transactions.primary_unit_of_measure%Type
86: , parent_transaction_id rcv_transactions.parent_transaction_id%Type
87: , po_line_location_id rcv_transactions.po_line_location_id%Type
88: , project_id rcv_transactions.project_id%Type
89: , task_id rcv_transactions.task_id%Type

Line 86: , parent_transaction_id rcv_transactions.parent_transaction_id%Type

82: , source_document_code rcv_transactions.source_document_code%Type
83: , transaction_type rcv_transactions.transaction_type%Type
84: , primary_quantity rcv_transactions.primary_quantity%Type
85: , primary_unit_of_measure rcv_transactions.primary_unit_of_measure%Type
86: , parent_transaction_id rcv_transactions.parent_transaction_id%Type
87: , po_line_location_id rcv_transactions.po_line_location_id%Type
88: , project_id rcv_transactions.project_id%Type
89: , task_id rcv_transactions.task_id%Type
90: , oe_order_line_id rcv_transactions.oe_order_line_id%Type

Line 87: , po_line_location_id rcv_transactions.po_line_location_id%Type

83: , transaction_type rcv_transactions.transaction_type%Type
84: , primary_quantity rcv_transactions.primary_quantity%Type
85: , primary_unit_of_measure rcv_transactions.primary_unit_of_measure%Type
86: , parent_transaction_id rcv_transactions.parent_transaction_id%Type
87: , po_line_location_id rcv_transactions.po_line_location_id%Type
88: , project_id rcv_transactions.project_id%Type
89: , task_id rcv_transactions.task_id%Type
90: , oe_order_line_id rcv_transactions.oe_order_line_id%Type
91: , process_type VARCHAR2(10)

Line 88: , project_id rcv_transactions.project_id%Type

84: , primary_quantity rcv_transactions.primary_quantity%Type
85: , primary_unit_of_measure rcv_transactions.primary_unit_of_measure%Type
86: , parent_transaction_id rcv_transactions.parent_transaction_id%Type
87: , po_line_location_id rcv_transactions.po_line_location_id%Type
88: , project_id rcv_transactions.project_id%Type
89: , task_id rcv_transactions.task_id%Type
90: , oe_order_line_id rcv_transactions.oe_order_line_id%Type
91: , process_type VARCHAR2(10)
92: , clubbed_transaction_id rcv_transactions.transaction_id%Type

Line 89: , task_id rcv_transactions.task_id%Type

85: , primary_unit_of_measure rcv_transactions.primary_unit_of_measure%Type
86: , parent_transaction_id rcv_transactions.parent_transaction_id%Type
87: , po_line_location_id rcv_transactions.po_line_location_id%Type
88: , project_id rcv_transactions.project_id%Type
89: , task_id rcv_transactions.task_id%Type
90: , oe_order_line_id rcv_transactions.oe_order_line_id%Type
91: , process_type VARCHAR2(10)
92: , clubbed_transaction_id rcv_transactions.transaction_id%Type
93: , error_status rcv_staging_table.status%Type

Line 90: , oe_order_line_id rcv_transactions.oe_order_line_id%Type

86: , parent_transaction_id rcv_transactions.parent_transaction_id%Type
87: , po_line_location_id rcv_transactions.po_line_location_id%Type
88: , project_id rcv_transactions.project_id%Type
89: , task_id rcv_transactions.task_id%Type
90: , oe_order_line_id rcv_transactions.oe_order_line_id%Type
91: , process_type VARCHAR2(10)
92: , clubbed_transaction_id rcv_transactions.transaction_id%Type
93: , error_status rcv_staging_table.status%Type
94: );

Line 92: , clubbed_transaction_id rcv_transactions.transaction_id%Type

88: , project_id rcv_transactions.project_id%Type
89: , task_id rcv_transactions.task_id%Type
90: , oe_order_line_id rcv_transactions.oe_order_line_id%Type
91: , process_type VARCHAR2(10)
92: , clubbed_transaction_id rcv_transactions.transaction_id%Type
93: , error_status rcv_staging_table.status%Type
94: );
95:
96: -- Define a table of above record type

Line 107: l_parent_transaction_type rcv_transactions.transaction_type%Type;

103: rcv_error_trx_ids DBMS_SQL.number_table;
104: l_net_Quantity NUMBER;
105: l_primary_uom_code VARCHAR2(3);
106: l_exists BOOLEAN;
107: l_parent_transaction_type rcv_transactions.transaction_type%Type;
108: l_error_trx_index NUMBER;
109:
110: -- Define standard variables.
111: l_msg_count NUMBER;

Line 116: -- vmutyala changed the cursor get_rcv_transactions to fetch transactions from

112: l_msg_data VARCHAR2(2000);
113: l_api_name CONSTANT VARCHAR2(30) := 'Process_Shikyu_Rcv_trx';
114: l_api_version CONSTANT NUMBER := 1.0;
115:
116: -- vmutyala changed the cursor get_rcv_transactions to fetch transactions from
117: -- rcv_transactions and rcv_staging_table only if the Shipment_ID of the
118: -- transaction in RCV_STAGING_TABLE exists in jmf_subcontract_orders Bug 4670527
119:
120:

Line 117: -- rcv_transactions and rcv_staging_table only if the Shipment_ID of the

113: l_api_name CONSTANT VARCHAR2(30) := 'Process_Shikyu_Rcv_trx';
114: l_api_version CONSTANT NUMBER := 1.0;
115:
116: -- vmutyala changed the cursor get_rcv_transactions to fetch transactions from
117: -- rcv_transactions and rcv_staging_table only if the Shipment_ID of the
118: -- transaction in RCV_STAGING_TABLE exists in jmf_subcontract_orders Bug 4670527
119:
120:
121:

Line 122: CURSOR get_rcv_transactions_case1 IS

118: -- transaction in RCV_STAGING_TABLE exists in jmf_subcontract_orders Bug 4670527
119:
120:
121:
122: CURSOR get_rcv_transactions_case1 IS
123: SELECT distinct (rt.TRANSACTION_ID), rt.SOURCE_DOCUMENT_CODE,
124: rt.TRANSACTION_TYPE, rt.PRIMARY_QUANTITY, rt.PRIMARY_UNIT_OF_MEASURE,
125: rt.PARENT_TRANSACTION_ID,rt.PO_LINE_LOCATION_ID,
126: rt.PROJECT_ID, rt.TASK_ID, rt.OE_ORDER_LINE_ID, null, null, rst.status

Line 127: FROM rcv_transactions rt, rcv_staging_table rst

123: SELECT distinct (rt.TRANSACTION_ID), rt.SOURCE_DOCUMENT_CODE,
124: rt.TRANSACTION_TYPE, rt.PRIMARY_QUANTITY, rt.PRIMARY_UNIT_OF_MEASURE,
125: rt.PARENT_TRANSACTION_ID,rt.PO_LINE_LOCATION_ID,
126: rt.PROJECT_ID, rt.TASK_ID, rt.OE_ORDER_LINE_ID, null, null, rst.status
127: FROM rcv_transactions rt, rcv_staging_table rst
128: WHERE rst.transaction_id = rt.transaction_id
129: AND rst.transaction_request_id = p_request_id
130: AND rst.transaction_group_id = p_group_id
131: AND rst.team = g_team_name

Line 147: CURSOR get_rcv_transactions_case2 IS

143: )
144: ORDER BY rt.transaction_id;
145:
146:
147: CURSOR get_rcv_transactions_case2 IS
148: SELECT distinct (rt.TRANSACTION_ID), rt.SOURCE_DOCUMENT_CODE,
149: rt.TRANSACTION_TYPE, rt.PRIMARY_QUANTITY, rt.PRIMARY_UNIT_OF_MEASURE,
150: rt.PARENT_TRANSACTION_ID,rt.PO_LINE_LOCATION_ID,
151: rt.PROJECT_ID, rt.TASK_ID, rt.OE_ORDER_LINE_ID, null, null, rst.status

Line 152: FROM rcv_transactions rt, rcv_staging_table rst

148: SELECT distinct (rt.TRANSACTION_ID), rt.SOURCE_DOCUMENT_CODE,
149: rt.TRANSACTION_TYPE, rt.PRIMARY_QUANTITY, rt.PRIMARY_UNIT_OF_MEASURE,
150: rt.PARENT_TRANSACTION_ID,rt.PO_LINE_LOCATION_ID,
151: rt.PROJECT_ID, rt.TASK_ID, rt.OE_ORDER_LINE_ID, null, null, rst.status
152: FROM rcv_transactions rt, rcv_staging_table rst
153: WHERE rst.transaction_id = rt.transaction_id
154: AND rst.transaction_request_id = p_request_id
155: AND rst.team = g_team_name
156: AND EXISTS(

Line 170: CURSOR get_rcv_transactions_case3 IS

166: AND OOLA.REFERENCE_LINE_ID = JSR.REPLENISHMENT_SO_LINE_ID
167: )
168: ORDER BY rt.transaction_id;
169:
170: CURSOR get_rcv_transactions_case3 IS
171: SELECT distinct (rt.TRANSACTION_ID), rt.SOURCE_DOCUMENT_CODE,
172: rt.TRANSACTION_TYPE, rt.PRIMARY_QUANTITY, rt.PRIMARY_UNIT_OF_MEASURE,
173: rt.PARENT_TRANSACTION_ID,rt.PO_LINE_LOCATION_ID,
174: rt.PROJECT_ID, rt.TASK_ID, rt.OE_ORDER_LINE_ID, null, null, rst.status

Line 175: FROM rcv_transactions rt, rcv_staging_table rst

171: SELECT distinct (rt.TRANSACTION_ID), rt.SOURCE_DOCUMENT_CODE,
172: rt.TRANSACTION_TYPE, rt.PRIMARY_QUANTITY, rt.PRIMARY_UNIT_OF_MEASURE,
173: rt.PARENT_TRANSACTION_ID,rt.PO_LINE_LOCATION_ID,
174: rt.PROJECT_ID, rt.TASK_ID, rt.OE_ORDER_LINE_ID, null, null, rst.status
175: FROM rcv_transactions rt, rcv_staging_table rst
176: WHERE rst.transaction_id = rt.transaction_id
177: AND rst.transaction_group_id = p_group_id
178: AND rst.team = g_team_name
179: AND EXISTS(

Line 193: CURSOR get_rcv_transactions_case4 IS

189: AND OOLA.REFERENCE_LINE_ID = JSR.REPLENISHMENT_SO_LINE_ID
190: )
191: ORDER BY rt.transaction_id;
192:
193: CURSOR get_rcv_transactions_case4 IS
194: SELECT distinct (rt.TRANSACTION_ID), rt.SOURCE_DOCUMENT_CODE,
195: rt.TRANSACTION_TYPE, rt.PRIMARY_QUANTITY, rt.PRIMARY_UNIT_OF_MEASURE,
196: rt.PARENT_TRANSACTION_ID,rt.PO_LINE_LOCATION_ID,
197: rt.PROJECT_ID, rt.TASK_ID, rt.OE_ORDER_LINE_ID, null, null, rst.status

Line 198: FROM rcv_transactions rt, rcv_staging_table rst

194: SELECT distinct (rt.TRANSACTION_ID), rt.SOURCE_DOCUMENT_CODE,
195: rt.TRANSACTION_TYPE, rt.PRIMARY_QUANTITY, rt.PRIMARY_UNIT_OF_MEASURE,
196: rt.PARENT_TRANSACTION_ID,rt.PO_LINE_LOCATION_ID,
197: rt.PROJECT_ID, rt.TASK_ID, rt.OE_ORDER_LINE_ID, null, null, rst.status
198: FROM rcv_transactions rt, rcv_staging_table rst
199: WHERE rst.transaction_id = rt.transaction_id
200: AND rst.team = g_team_name
201: AND EXISTS(
202: SELECT 1

Line 245: -- collect relevant records from rcv_transactions in table data type.

241: x_return_status := FND_API.G_RET_STS_ERROR;
242:
243: -- End API initialization
244:
245: -- collect relevant records from rcv_transactions in table data type.
246:
247: IF p_request_id is NOT NULL and p_group_id is NOT NULL then
248: OPEN get_rcv_transactions_case1;
249: FETCH get_rcv_transactions_case1 BULK COLLECT INTO l_rcv_pending_trx_tbl;

Line 248: OPEN get_rcv_transactions_case1;

244:
245: -- collect relevant records from rcv_transactions in table data type.
246:
247: IF p_request_id is NOT NULL and p_group_id is NOT NULL then
248: OPEN get_rcv_transactions_case1;
249: FETCH get_rcv_transactions_case1 BULK COLLECT INTO l_rcv_pending_trx_tbl;
250: CLOSE get_rcv_transactions_case1;
251:
252: ELSIF p_request_id is NOT NULL then

Line 249: FETCH get_rcv_transactions_case1 BULK COLLECT INTO l_rcv_pending_trx_tbl;

245: -- collect relevant records from rcv_transactions in table data type.
246:
247: IF p_request_id is NOT NULL and p_group_id is NOT NULL then
248: OPEN get_rcv_transactions_case1;
249: FETCH get_rcv_transactions_case1 BULK COLLECT INTO l_rcv_pending_trx_tbl;
250: CLOSE get_rcv_transactions_case1;
251:
252: ELSIF p_request_id is NOT NULL then
253: OPEN get_rcv_transactions_case2;

Line 250: CLOSE get_rcv_transactions_case1;

246:
247: IF p_request_id is NOT NULL and p_group_id is NOT NULL then
248: OPEN get_rcv_transactions_case1;
249: FETCH get_rcv_transactions_case1 BULK COLLECT INTO l_rcv_pending_trx_tbl;
250: CLOSE get_rcv_transactions_case1;
251:
252: ELSIF p_request_id is NOT NULL then
253: OPEN get_rcv_transactions_case2;
254: FETCH get_rcv_transactions_case2 BULK COLLECT INTO l_rcv_pending_trx_tbl;

Line 253: OPEN get_rcv_transactions_case2;

249: FETCH get_rcv_transactions_case1 BULK COLLECT INTO l_rcv_pending_trx_tbl;
250: CLOSE get_rcv_transactions_case1;
251:
252: ELSIF p_request_id is NOT NULL then
253: OPEN get_rcv_transactions_case2;
254: FETCH get_rcv_transactions_case2 BULK COLLECT INTO l_rcv_pending_trx_tbl;
255: CLOSE get_rcv_transactions_case2;
256:
257: ELSIF p_group_id is NOT NULL then

Line 254: FETCH get_rcv_transactions_case2 BULK COLLECT INTO l_rcv_pending_trx_tbl;

250: CLOSE get_rcv_transactions_case1;
251:
252: ELSIF p_request_id is NOT NULL then
253: OPEN get_rcv_transactions_case2;
254: FETCH get_rcv_transactions_case2 BULK COLLECT INTO l_rcv_pending_trx_tbl;
255: CLOSE get_rcv_transactions_case2;
256:
257: ELSIF p_group_id is NOT NULL then
258: OPEN get_rcv_transactions_case3;

Line 255: CLOSE get_rcv_transactions_case2;

251:
252: ELSIF p_request_id is NOT NULL then
253: OPEN get_rcv_transactions_case2;
254: FETCH get_rcv_transactions_case2 BULK COLLECT INTO l_rcv_pending_trx_tbl;
255: CLOSE get_rcv_transactions_case2;
256:
257: ELSIF p_group_id is NOT NULL then
258: OPEN get_rcv_transactions_case3;
259: FETCH get_rcv_transactions_case3 BULK COLLECT INTO l_rcv_pending_trx_tbl;

Line 258: OPEN get_rcv_transactions_case3;

254: FETCH get_rcv_transactions_case2 BULK COLLECT INTO l_rcv_pending_trx_tbl;
255: CLOSE get_rcv_transactions_case2;
256:
257: ELSIF p_group_id is NOT NULL then
258: OPEN get_rcv_transactions_case3;
259: FETCH get_rcv_transactions_case3 BULK COLLECT INTO l_rcv_pending_trx_tbl;
260: CLOSE get_rcv_transactions_case3;
261:
262: ELSE

Line 259: FETCH get_rcv_transactions_case3 BULK COLLECT INTO l_rcv_pending_trx_tbl;

255: CLOSE get_rcv_transactions_case2;
256:
257: ELSIF p_group_id is NOT NULL then
258: OPEN get_rcv_transactions_case3;
259: FETCH get_rcv_transactions_case3 BULK COLLECT INTO l_rcv_pending_trx_tbl;
260: CLOSE get_rcv_transactions_case3;
261:
262: ELSE
263: OPEN get_rcv_transactions_case4;

Line 260: CLOSE get_rcv_transactions_case3;

256:
257: ELSIF p_group_id is NOT NULL then
258: OPEN get_rcv_transactions_case3;
259: FETCH get_rcv_transactions_case3 BULK COLLECT INTO l_rcv_pending_trx_tbl;
260: CLOSE get_rcv_transactions_case3;
261:
262: ELSE
263: OPEN get_rcv_transactions_case4;
264: FETCH get_rcv_transactions_case4 BULK COLLECT INTO l_rcv_pending_trx_tbl;

Line 263: OPEN get_rcv_transactions_case4;

259: FETCH get_rcv_transactions_case3 BULK COLLECT INTO l_rcv_pending_trx_tbl;
260: CLOSE get_rcv_transactions_case3;
261:
262: ELSE
263: OPEN get_rcv_transactions_case4;
264: FETCH get_rcv_transactions_case4 BULK COLLECT INTO l_rcv_pending_trx_tbl;
265: CLOSE get_rcv_transactions_case4;
266:
267: END IF;

Line 264: FETCH get_rcv_transactions_case4 BULK COLLECT INTO l_rcv_pending_trx_tbl;

260: CLOSE get_rcv_transactions_case3;
261:
262: ELSE
263: OPEN get_rcv_transactions_case4;
264: FETCH get_rcv_transactions_case4 BULK COLLECT INTO l_rcv_pending_trx_tbl;
265: CLOSE get_rcv_transactions_case4;
266:
267: END IF;
268:

Line 265: CLOSE get_rcv_transactions_case4;

261:
262: ELSE
263: OPEN get_rcv_transactions_case4;
264: FETCH get_rcv_transactions_case4 BULK COLLECT INTO l_rcv_pending_trx_tbl;
265: CLOSE get_rcv_transactions_case4;
266:
267: END IF;
268:
269:

Line 346: from rcv_transactions

342: l_rcv_pending_clubbed_trx_tbl(l_rcv_pending_clubbed_trx_tbl.COUNT+1) :=
343: l_rcv_pending_trx_tbl(i);
344: select transaction_type
345: into l_parent_transaction_type
346: from rcv_transactions
347: where transaction_id =
348: (select PARENT_TRANSACTION_ID
349: from rcv_transactions
350: where transaction_id = l_rcv_pending_trx_tbl(i).transaction_id);

Line 349: from rcv_transactions

345: into l_parent_transaction_type
346: from rcv_transactions
347: where transaction_id =
348: (select PARENT_TRANSACTION_ID
349: from rcv_transactions
350: where transaction_id = l_rcv_pending_trx_tbl(i).transaction_id);
351:
352: /*vmutyala added the following code.
353: For independent correction transactions to set the process type depending on parent transaction type

Line 565: from hr_organization_information hoi, rcv_transactions rt, rcv_staging_table rst, mtl_parameters mp

561: Bug 4670527 */
562: delete rcv_staging_table
563: where transaction_id IN
564: (select distinct(rst.transaction_id)
565: from hr_organization_information hoi, rcv_transactions rt, rcv_staging_table rst, mtl_parameters mp
566: where rt.SOURCE_DOCUMENT_CODE = 'PO'
567: and hoi.ORG_INFORMATION_CONTEXT = 'Customer/Supplier Association'
568: and hoi.ORG_INFORMATION3 = to_char(rt.vendor_id)
569: and hoi.ORG_INFORMATION4 = to_char(rt.vendor_site_id)

Line 582: from OE_ORDER_LINES_ALL OOLA, rcv_transactions rt, rcv_staging_table rst

578: Bug 4670527 */
579: delete rcv_staging_table
580: where transaction_id IN
581: (select distinct(rst.transaction_id)
582: from OE_ORDER_LINES_ALL OOLA, rcv_transactions rt, rcv_staging_table rst
583: where rt.SOURCE_DOCUMENT_CODE = 'RMA'
584: and rt.OE_ORDER_LINE_ID = OOLA.LINE_ID
585: and (OOLA.REFERENCE_LINE_ID is NULL OR NOT EXISTS (select 1 from JMF_SHIKYU_REPLENISHMENTS
586: where REPLENISHMENT_SO_LINE_ID=

Line 1160: -- B. Enter records into rcv_transactions_interface

1156: --Follwing is logic:
1157: --1. Find all records eligible for SHIKYU RTV at MP site
1158: ---2. Perform SHIKYU RTV at MP site
1159: -- A. Enter records into rcv_headers_interface
1160: -- B. Enter records into rcv_transactions_interface
1161: -- C. Submit RVCTP ( Receiving Transaction Processor)
1162: -- D. Wait till concurrent request completes
1163: -- E. Confirm that RTV happened succefully. Received quantity against
1164: -- replenishment PO should be reduced by RTV quantity.

Line 1224: l_transaction_type RCV_TRANSACTIONS.TRANSACTION_TYPE%Type;

1220: l_rtv_unsuccessful EXCEPTION;
1221:
1222: l_workers JMF_SHIKYU_UTIL.g_request_tbl_type;
1223:
1224: l_transaction_type RCV_TRANSACTIONS.TRANSACTION_TYPE%Type;
1225: l_parent_transaction_id NUMBER;
1226: l_subinventory RCV_TRANSACTIONS.SUBINVENTORY%Type;
1227: l_locator_id NUMBER;
1228: l_project_id NUMBER;

Line 1226: l_subinventory RCV_TRANSACTIONS.SUBINVENTORY%Type;

1222: l_workers JMF_SHIKYU_UTIL.g_request_tbl_type;
1223:
1224: l_transaction_type RCV_TRANSACTIONS.TRANSACTION_TYPE%Type;
1225: l_parent_transaction_id NUMBER;
1226: l_subinventory RCV_TRANSACTIONS.SUBINVENTORY%Type;
1227: l_locator_id NUMBER;
1228: l_project_id NUMBER;
1229:
1230: l_returned_qty_parent_txn_uom NUMBER;

Line 1306: FROM rcv_transactions rt,

1302: IF p_status <> 'DA_ERROR' THEN
1303:
1304: SELECT rt.transaction_type, rt.transaction_id, rt.subinventory, rt.locator_id, rt.project_id
1305: INTO l_transaction_type, l_parent_transaction_id, l_subinventory, l_locator_id, l_project_id
1306: FROM rcv_transactions rt,
1307: rcv_shipment_lines rsl
1308: WHERE rt.organization_id = l_tp_organization_id
1309: AND rt.po_header_id = l_replen_po_header_id
1310: AND rt.po_line_id = l_replen_po_line_id

Line 1329: FROM RCV_TRANSACTIONS_INTERFACE RTI

1325: AND RS.TO_ORG_PRIMARY_QUANTITY >
1326: (
1327: SELECT
1328: NVL(SUM(RTI.PRIMARY_QUANTITY),0)
1329: FROM RCV_TRANSACTIONS_INTERFACE RTI
1330: WHERE RTI.PARENT_TRANSACTION_ID = RT.TRANSACTION_ID
1331: AND RTI.TRANSACTION_STATUS_CODE = 'PENDING'
1332: AND RTI.PROCESSING_STATUS_CODE = 'PENDING'
1333: )