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.GML_OPM_ROI_GRP dependencies on RCV_TRANSACTIONS

Line 71: FROM rcv_transactions_interface

67:
68: IF p_group_id IS NULL THEN
69: SELECT group_id,header_interface_id
70: INTO l_group_id,l_header_interface_id
71: FROM rcv_transactions_interface
72: WHERE interface_transaction_id = p_rti_id ;
73:
74: END IF;
75:

Line 282: l_table_name := 'RCV_TRANSACTIONS_INTERFACE';

278: EXCEPTION
279: WHEN OTHERS THEN
280: x_return_status := fnd_api.g_ret_sts_unexp_error;
281: IF p_lot_id IS NULL THEN
282: l_table_name := 'RCV_TRANSACTIONS_INTERFACE';
283: ELSE
284: l_table_name := 'MTL_TRANSACTION_LOTS_INTERFACE';
285: END IF;
286:

Line 327: -- rcv_transactions_interface table which does hold the latest data. All the latest data

323:
324: -- bug# 3664014
325: -- added some more parameters in x_opm_record type.
326: -- validate_opm_parameters API was reading these extra parameters from
327: -- rcv_transactions_interface table which does hold the latest data. All the latest data
328: -- are in the cascaded table. Removed the select from RTI table.
329:
330: l_progress := '020';
331:

Line 363: p_table_name => 'RCV_TRANSACTIONS_INTERFACE',

359: insert_errors(p_rti_id => x_opm_record.rti_id,
360: p_group_id => x_opm_record.group_id,
361: p_header_interface_id => x_opm_record.header_interface_id,
362: p_column_name => 'ITEM_ID',
363: p_table_name => 'RCV_TRANSACTIONS_INTERFACE',
364: p_error_message => NULL,
365: p_mesg_owner => 'GML',
366: p_Error_Message_name => 'GML_OPM_ITEM_NOT_EXIST' );
367: RETURN ;

Line 406: p_table_name => 'RCV_TRANSACTIONS_INTERFACE',

402: insert_errors(p_rti_id => x_opm_record.rti_id,
403: p_group_id => x_opm_record.group_id,
404: p_header_interface_id => x_opm_record.header_interface_id,
405: p_column_name => 'PRIMARY_QUANTITY',
406: p_table_name => 'RCV_TRANSACTIONS_INTERFACE',
407: p_error_message => FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,p_encoded => 'F'),
408: p_mesg_owner => NULL,
409: p_Error_Message_name => NULL );
410: END IF;

Line 481: p_table_name => 'RCV_TRANSACTIONS_INTERFACE',

477: insert_errors(p_rti_id => x_opm_record.rti_id,
478: p_group_id => x_opm_record.group_id,
479: p_header_interface_id => x_opm_record.header_interface_id,
480: p_column_name => 'SECONDARY_QUANTITY',
481: p_table_name => 'RCV_TRANSACTIONS_INTERFACE',
482: p_error_message => l_msg_data,
483: p_mesg_owner => NULL,
484: p_Error_Message_name => NULL );
485:

Line 508: p_table_name => 'RCV_TRANSACTIONS_INTERFACE',

504: insert_errors( p_rti_id => x_opm_record.rti_id,
505: p_group_id => x_opm_record.group_id,
506: p_header_interface_id => x_opm_record.header_interface_id,
507: p_column_name => 'OPM_COLUMNS',
508: p_table_name => 'RCV_TRANSACTIONS_INTERFACE',
509: p_error_message => 'UNHANDLED EXCEPTION IN VALIDATE_OPM_PARAMETERS :' || l_progress||'-' ||
510: substr(sqlerrm,1,1000),
511: p_mesg_owner => NULL,
512: p_Error_Message_name => NULL);

Line 1302: l_transaction_type rcv_transactions_interface.transaction_type%TYPE ;

1298: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Opm_Lot';
1299: l_api_version CONSTANT NUMBER := 1.0;
1300: l_pkg_name CONSTANT VARCHAR2(30) := 'GML_OPM_ROI_GRP';
1301:
1302: l_transaction_type rcv_transactions_interface.transaction_type%TYPE ;
1303: l_source_document_code rcv_transactions_interface.source_document_code%TYPE ;
1304: l_item_id NUMBER;
1305: l_org_id NUMBER;
1306: l_to_locator_id NUMBER;

Line 1303: l_source_document_code rcv_transactions_interface.source_document_code%TYPE ;

1299: l_api_version CONSTANT NUMBER := 1.0;
1300: l_pkg_name CONSTANT VARCHAR2(30) := 'GML_OPM_ROI_GRP';
1301:
1302: l_transaction_type rcv_transactions_interface.transaction_type%TYPE ;
1303: l_source_document_code rcv_transactions_interface.source_document_code%TYPE ;
1304: l_item_id NUMBER;
1305: l_org_id NUMBER;
1306: l_to_locator_id NUMBER;
1307: l_from_locator_id NUMBER;

Line 1309: l_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE;

1305: l_org_id NUMBER;
1306: l_to_locator_id NUMBER;
1307: l_from_locator_id NUMBER;
1308: l_locator_id NUMBER;
1309: l_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE;
1310: l_secondary_unit_of_measure rcv_transactions_interface.secondary_unit_of_measure%TYPE;
1311: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
1312: l_lot_attribute_rec gml_opm_roi_grp.lot_attributes_rec_type ;
1313:

Line 1310: l_secondary_unit_of_measure rcv_transactions_interface.secondary_unit_of_measure%TYPE;

1306: l_to_locator_id NUMBER;
1307: l_from_locator_id NUMBER;
1308: l_locator_id NUMBER;
1309: l_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE;
1310: l_secondary_unit_of_measure rcv_transactions_interface.secondary_unit_of_measure%TYPE;
1311: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
1312: l_lot_attribute_rec gml_opm_roi_grp.lot_attributes_rec_type ;
1313:
1314: l_new_lot_rec GMIGAPI.lot_rec_typ;

Line 1311: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;

1307: l_from_locator_id NUMBER;
1308: l_locator_id NUMBER;
1309: l_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE;
1310: l_secondary_unit_of_measure rcv_transactions_interface.secondary_unit_of_measure%TYPE;
1311: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
1312: l_lot_attribute_rec gml_opm_roi_grp.lot_attributes_rec_type ;
1313:
1314: l_new_lot_rec GMIGAPI.lot_rec_typ;
1315: l_lot_no ic_lots_mst.lot_no%TYPE;

Line 1335: l_comment rcv_transactions.comments%TYPE;

1331: l_parent_transaction_id NUMBER;
1332: l_shipment_header_id NUMBER;
1333: l_shipment_line_id NUMBER;
1334: l_net_received_lot_qty NUMBER;
1335: l_comment rcv_transactions.comments%TYPE;
1336: l_lot_primary_quantity NUMBER;
1337: l_old_recv_qty NUMBER;
1338: l_recv_id NUMBER;
1339: l_recvline_id NUMBER;

Line 1361: FROM rcv_transactions rt , ic_tran_pnd itp

1357: l_rti_secondary_quantity NUMBER;
1358:
1359: Cursor Cr_get_total_qty_available IS
1360: SELECT sum(itp.trans_qty)
1361: FROM rcv_transactions rt , ic_tran_pnd itp
1362: WHERE
1363: rt.shipment_header_id = l_shipment_header_id
1364: AND rt.shipment_line_id = l_shipment_line_id
1365: AND itp.doc_id = rt.shipment_header_id

Line 1375: from rcv_transactions rcv,

1371: Cursor Cr_old_recv_qty Is
1372: Select sum(itp.trans_qty),
1373: itp.doc_id,
1374: itp.line_id
1375: from rcv_transactions rcv,
1376: gml_recv_trans_map grm,
1377: ic_tran_pnd itp
1378: where rcv.transaction_id = l_parent_transaction_id
1379: and rcv.comments = 'OPM RECEIPT'

Line 1492: FROM RCV_TRANSACTIONS_INTERFACE

1488: , l_oe_order_header_id
1489: , l_oe_order_line_id
1490: , l_rti_quantity
1491: , l_rti_secondary_quantity
1492: FROM RCV_TRANSACTIONS_INTERFACE
1493: WHERE INTERFACE_TRANSACTION_ID = l_rti_id;
1494:
1495: IF l_inv_debug = 1 THEN
1496: print_debug('Interface Record fetched =>'||l_rti_id, 1);

Line 1754: FROM rcv_transactions

1750:
1751: IF (l_shipment_header_id IS NULL) OR (l_shipment_line_id IS NULL) THEN
1752: SELECT shipment_header_id, shipment_line_id
1753: INTO l_shipment_header_id , l_shipment_line_id
1754: FROM rcv_transactions
1755: WHERE transaction_id = l_parent_transaction_id ;
1756:
1757: END IF;
1758:

Line 1940: from rcv_transactions rcv

1936: -- to check if it is an OLD OPM RECEIPT(Common Purchasing)
1937: BEGIN
1938: select rcv.comments
1939: into l_comment
1940: from rcv_transactions rcv
1941: where rcv.transaction_id = l_parent_transaction_id;
1942:
1943: EXCEPTION
1944: WHEN OTHERS THEN

Line 1967: FROM rcv_transactions rcv,gml_recv_trans_map grm,ic_tran_pnd itp

1963: and itp.lot_id = p_lot_id ;
1964:
1965: ELSE
1966: SELECT 'X' INTO l_temp
1967: FROM rcv_transactions rcv,gml_recv_trans_map grm,ic_tran_pnd itp
1968: WHERE rcv.transaction_id = l_parent_transaction_id
1969: and rcv.interface_transaction_id = grm.interface_transaction_id
1970: and grm.recv_id = itp.doc_id
1971: and itp.doc_type = 'RECV'

Line 2413: from rcv_transactions rcv

2409: -- to check if it is an OLD OPM RECEIPT(Common Purchasing)
2410: BEGIN
2411: select rcv.comments
2412: into l_comment
2413: from rcv_transactions rcv
2414: where rcv.transaction_id = l_parent_transaction_id;
2415:
2416: EXCEPTION
2417: WHEN OTHERS THEN

Line 2438: FROM rcv_transactions rcv,gml_recv_trans_map grm,ic_tran_pnd itp

2434: and itp.lot_id = p_lot_id ;
2435:
2436: ELSE
2437: SELECT 'X' INTO l_temp
2438: FROM rcv_transactions rcv,gml_recv_trans_map grm,ic_tran_pnd itp
2439: WHERE rcv.transaction_id = l_parent_transaction_id
2440: and rcv.interface_transaction_id = grm.interface_transaction_id
2441: and grm.recv_id = itp.doc_id
2442: and itp.doc_type = 'RECV'