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_INTERFACE

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 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);