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.AHL_OSP_RCV_PVT dependencies on DUAL

Line 1363: SELECT PO.RCV_INTERFACE_GROUPS_S.CURRVAL INTO l_temp FROM DUAL;

1359: 'Submitting the request for calling the Concurrent Program RVCTP.');
1360: END IF;
1361:
1362: -- Get the current value of the sequence PO.RCV_INTERFACE_GROUPS_S, required for submitting the request.
1363: SELECT PO.RCV_INTERFACE_GROUPS_S.CURRVAL INTO l_temp FROM DUAL;
1364:
1365: l_req_id := FND_REQUEST.SUBMIT_REQUEST(
1366: application => 'PO',
1367: program => 'RVCTP',

Line 2192: SELECT PO.RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;

2188: END IF;
2189: END IF;
2190:
2191: --Initialize the sequences that are to be used.
2192: SELECT PO.RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;
2193: SELECT PO.RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM sys.dual;
2194: SELECT PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL INTO l_intf_transaction_id from sys.dual;
2195: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO l_mtl_transaction_id from sys.dual;
2196:

Line 2193: SELECT PO.RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM sys.dual;

2189: END IF;
2190:
2191: --Initialize the sequences that are to be used.
2192: SELECT PO.RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;
2193: SELECT PO.RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM sys.dual;
2194: SELECT PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL INTO l_intf_transaction_id from sys.dual;
2195: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO l_mtl_transaction_id from sys.dual;
2196:
2197: --select the user related ids

Line 2194: SELECT PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL INTO l_intf_transaction_id from sys.dual;

2190:
2191: --Initialize the sequences that are to be used.
2192: SELECT PO.RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;
2193: SELECT PO.RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM sys.dual;
2194: SELECT PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL INTO l_intf_transaction_id from sys.dual;
2195: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO l_mtl_transaction_id from sys.dual;
2196:
2197: --select the user related ids
2198: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;

Line 2195: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO l_mtl_transaction_id from sys.dual;

2191: --Initialize the sequences that are to be used.
2192: SELECT PO.RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;
2193: SELECT PO.RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM sys.dual;
2194: SELECT PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL INTO l_intf_transaction_id from sys.dual;
2195: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO l_mtl_transaction_id from sys.dual;
2196:
2197: --select the user related ids
2198: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;
2199: SELECT FND_GLOBAL.LOGIN_ID INTO l_login_id from sys.dual;

Line 2198: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;

2194: SELECT PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL INTO l_intf_transaction_id from sys.dual;
2195: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO l_mtl_transaction_id from sys.dual;
2196:
2197: --select the user related ids
2198: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;
2199: SELECT FND_GLOBAL.LOGIN_ID INTO l_login_id from sys.dual;
2200: SELECT FND_GLOBAL.EMPLOYEE_ID INTO l_employee_id from sys.dual;
2201:
2202: --Insert values into the RCV_HEADERS_INTERFACE

Line 2199: SELECT FND_GLOBAL.LOGIN_ID INTO l_login_id from sys.dual;

2195: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO l_mtl_transaction_id from sys.dual;
2196:
2197: --select the user related ids
2198: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;
2199: SELECT FND_GLOBAL.LOGIN_ID INTO l_login_id from sys.dual;
2200: SELECT FND_GLOBAL.EMPLOYEE_ID INTO l_employee_id from sys.dual;
2201:
2202: --Insert values into the RCV_HEADERS_INTERFACE
2203: INSERT INTO RCV_HEADERS_INTERFACE

Line 2200: SELECT FND_GLOBAL.EMPLOYEE_ID INTO l_employee_id from sys.dual;

2196:
2197: --select the user related ids
2198: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;
2199: SELECT FND_GLOBAL.LOGIN_ID INTO l_login_id from sys.dual;
2200: SELECT FND_GLOBAL.EMPLOYEE_ID INTO l_employee_id from sys.dual;
2201:
2202: --Insert values into the RCV_HEADERS_INTERFACE
2203: INSERT INTO RCV_HEADERS_INTERFACE
2204: (