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 FND_GLOBAL

Line 1036: FND_GLOBAL.USER_ID,

1032: 'PENDING',
1033: 'VENDOR',
1034: 'NEW',
1035: SYSDATE,
1036: FND_GLOBAL.USER_ID,
1037: FND_GLOBAL.LOGIN_ID,
1038: SYSDATE,
1039: FND_GLOBAL.USER_ID,
1040: l_po_vendor_id,

Line 1037: FND_GLOBAL.LOGIN_ID,

1033: 'VENDOR',
1034: 'NEW',
1035: SYSDATE,
1036: FND_GLOBAL.USER_ID,
1037: FND_GLOBAL.LOGIN_ID,
1038: SYSDATE,
1039: FND_GLOBAL.USER_ID,
1040: l_po_vendor_id,
1041: l_po_vendor_site_id,

Line 1039: FND_GLOBAL.USER_ID,

1035: SYSDATE,
1036: FND_GLOBAL.USER_ID,
1037: FND_GLOBAL.LOGIN_ID,
1038: SYSDATE,
1039: FND_GLOBAL.USER_ID,
1040: l_po_vendor_id,
1041: l_po_vendor_site_id,
1042: l_ship_to_org_id
1043: );

Line 1087: FND_GLOBAL.USER_ID,

1083: PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
1084: PO.RCV_HEADERS_INTERFACE_S.CURRVAL,
1085: PO.RCV_INTERFACE_GROUPS_S.CURRVAL,
1086: SYSDATE,
1087: FND_GLOBAL.USER_ID,
1088: FND_GLOBAL.LOGIN_ID,
1089: SYSDATE,
1090: FND_GLOBAL.USER_ID,
1091: 'RECEIVE',

Line 1088: FND_GLOBAL.LOGIN_ID,

1084: PO.RCV_HEADERS_INTERFACE_S.CURRVAL,
1085: PO.RCV_INTERFACE_GROUPS_S.CURRVAL,
1086: SYSDATE,
1087: FND_GLOBAL.USER_ID,
1088: FND_GLOBAL.LOGIN_ID,
1089: SYSDATE,
1090: FND_GLOBAL.USER_ID,
1091: 'RECEIVE',
1092: SYSDATE,

Line 1090: FND_GLOBAL.USER_ID,

1086: SYSDATE,
1087: FND_GLOBAL.USER_ID,
1088: FND_GLOBAL.LOGIN_ID,
1089: SYSDATE,
1090: FND_GLOBAL.USER_ID,
1091: 'RECEIVE',
1092: SYSDATE,
1093: 'PENDING',
1094: 'BATCH',

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

1917: SELECT PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL INTO l_intf_transaction_id from sys.dual;
1918: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO l_mtl_transaction_id from sys.dual;
1919:
1920: --select the user related ids
1921: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;
1922: SELECT FND_GLOBAL.LOGIN_ID INTO l_login_id from sys.dual;
1923: SELECT FND_GLOBAL.EMPLOYEE_ID INTO l_employee_id from sys.dual;
1924:
1925: --Insert values into the RCV_HEADERS_INTERFACE

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

1918: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO l_mtl_transaction_id from sys.dual;
1919:
1920: --select the user related ids
1921: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;
1922: SELECT FND_GLOBAL.LOGIN_ID INTO l_login_id from sys.dual;
1923: SELECT FND_GLOBAL.EMPLOYEE_ID INTO l_employee_id from sys.dual;
1924:
1925: --Insert values into the RCV_HEADERS_INTERFACE
1926: INSERT INTO RCV_HEADERS_INTERFACE

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

1919:
1920: --select the user related ids
1921: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;
1922: SELECT FND_GLOBAL.LOGIN_ID INTO l_login_id from sys.dual;
1923: SELECT FND_GLOBAL.EMPLOYEE_ID INTO l_employee_id from sys.dual;
1924:
1925: --Insert values into the RCV_HEADERS_INTERFACE
1926: INSERT INTO RCV_HEADERS_INTERFACE
1927: (

Line 2140: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,

2136: VALUES
2137: (
2138: l_mtl_transaction_id, --TRANSACTION_INTERFACE_ID,
2139: SYSDATE, --LAST_UPDATE_DATE,
2140: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
2141: SYSDATE, --CREATION_DATE,
2142: FND_GLOBAL.USER_ID, --CREATED_BY,
2143: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,
2144: l_trans_lot_number, --LOT_NUMBER,

Line 2142: FND_GLOBAL.USER_ID, --CREATED_BY,

2138: l_mtl_transaction_id, --TRANSACTION_INTERFACE_ID,
2139: SYSDATE, --LAST_UPDATE_DATE,
2140: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
2141: SYSDATE, --CREATION_DATE,
2142: FND_GLOBAL.USER_ID, --CREATED_BY,
2143: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,
2144: l_trans_lot_number, --LOT_NUMBER,
2145: p_rma_receipt_rec.RECEIPT_QUANTITY, --TRANSACTION_QUANTITY
2146: p_rma_receipt_rec.RECEIPT_QUANTITY, --PRIMARY_QUANTITY

Line 2143: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,

2139: SYSDATE, --LAST_UPDATE_DATE,
2140: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
2141: SYSDATE, --CREATION_DATE,
2142: FND_GLOBAL.USER_ID, --CREATED_BY,
2143: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,
2144: l_trans_lot_number, --LOT_NUMBER,
2145: p_rma_receipt_rec.RECEIPT_QUANTITY, --TRANSACTION_QUANTITY
2146: p_rma_receipt_rec.RECEIPT_QUANTITY, --PRIMARY_QUANTITY
2147: 'RCV', --PRODUCT_CODE,

Line 2171: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,

2167: VALUES
2168: (
2169: l_mtl_transaction_id, --TRANSACTION_INTERFACE_ID,
2170: SYSDATE, --LAST_UPDATE_DATE,
2171: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
2172: SYSDATE, --CREATION_DATE,
2173: FND_GLOBAL.USER_ID, --CREATED_BY,
2174: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,
2175: l_trans_serial_number, --FM_SERIAL_NUMBER,

Line 2173: FND_GLOBAL.USER_ID, --CREATED_BY,

2169: l_mtl_transaction_id, --TRANSACTION_INTERFACE_ID,
2170: SYSDATE, --LAST_UPDATE_DATE,
2171: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
2172: SYSDATE, --CREATION_DATE,
2173: FND_GLOBAL.USER_ID, --CREATED_BY,
2174: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,
2175: l_trans_serial_number, --FM_SERIAL_NUMBER,
2176: l_trans_serial_number, --TO_SERIAL_NUMBER,
2177: 'RCV', --PRODUCT_CODE,

Line 2174: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,

2170: SYSDATE, --LAST_UPDATE_DATE,
2171: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
2172: SYSDATE, --CREATION_DATE,
2173: FND_GLOBAL.USER_ID, --CREATED_BY,
2174: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,
2175: l_trans_serial_number, --FM_SERIAL_NUMBER,
2176: l_trans_serial_number, --TO_SERIAL_NUMBER,
2177: 'RCV', --PRODUCT_CODE,
2178: l_intf_transaction_id --PRODUCT_TRANSACTION_ID