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.HZ_CUSTOMER_INT dependencies on FND_GLOBAL

Line 1147: m_request_id := FND_GLOBAL.CONC_REQUEST_ID;

1143:
1144: l_sub_request_ids := SUBSTRB( l_sub_request_ids, l_posi1 + 1 );
1145: END LOOP;
1146: ELSE
1147: m_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1148: l_times := 0;
1149: END IF;
1150:
1151: l_times := l_times + 1;

Line 3162: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,

3158: USING
3159: (SELECT 'THIRD_PARTY' PARTY_TYPE_CODE,
3160: party.party_id PARTY_ID,
3161: party.country COUNTRY_CODE, --4742586
3162: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
3163: party.tax_reference TAX_REFERENCE,
3164: SYSDATE CREATION_DATE,
3165: FND_GLOBAL.User_ID CREATED_BY,
3166: SYSDATE LAST_UPDATE_DATE,

Line 3165: FND_GLOBAL.User_ID CREATED_BY,

3161: party.country COUNTRY_CODE, --4742586
3162: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
3163: party.tax_reference TAX_REFERENCE,
3164: SYSDATE CREATION_DATE,
3165: FND_GLOBAL.User_ID CREATED_BY,
3166: SYSDATE LAST_UPDATE_DATE,
3167: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3168: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3169: FROM HZ_PARTIES party, ra_customers_interface_all rci -- Bug 4956131

Line 3167: FND_GLOBAL.User_ID LAST_UPDATED_BY,

3163: party.tax_reference TAX_REFERENCE,
3164: SYSDATE CREATION_DATE,
3165: FND_GLOBAL.User_ID CREATED_BY,
3166: SYSDATE LAST_UPDATE_DATE,
3167: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3168: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3169: FROM HZ_PARTIES party, ra_customers_interface_all rci -- Bug 4956131
3170: WHERE party.orig_system_reference = nvl(rci.orig_system_party_ref, rci.orig_system_customer_ref)
3171: AND party.request_id = p_request_id

Line 3168: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN

3164: SYSDATE CREATION_DATE,
3165: FND_GLOBAL.User_ID CREATED_BY,
3166: SYSDATE LAST_UPDATE_DATE,
3167: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3168: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3169: FROM HZ_PARTIES party, ra_customers_interface_all rci -- Bug 4956131
3170: WHERE party.orig_system_reference = nvl(rci.orig_system_party_ref, rci.orig_system_customer_ref)
3171: AND party.request_id = p_request_id
3172: AND rci.interface_status is null

Line 3239: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,

3235: USING
3236: (SELECT 'THIRD_PARTY' PARTY_TYPE_CODE,
3237: party.party_id PARTY_ID,
3238: party.country COUNTRY_CODE,
3239: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
3240: party.tax_reference TAX_REFERENCE,
3241: SYSDATE CREATION_DATE,
3242: FND_GLOBAL.User_ID CREATED_BY,
3243: SYSDATE LAST_UPDATE_DATE,

Line 3242: FND_GLOBAL.User_ID CREATED_BY,

3238: party.country COUNTRY_CODE,
3239: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
3240: party.tax_reference TAX_REFERENCE,
3241: SYSDATE CREATION_DATE,
3242: FND_GLOBAL.User_ID CREATED_BY,
3243: SYSDATE LAST_UPDATE_DATE,
3244: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3245: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3246: FROM HZ_PARTIES party, RA_CONTACT_PHONES_INT_ALL rcpi

Line 3244: FND_GLOBAL.User_ID LAST_UPDATED_BY,

3240: party.tax_reference TAX_REFERENCE,
3241: SYSDATE CREATION_DATE,
3242: FND_GLOBAL.User_ID CREATED_BY,
3243: SYSDATE LAST_UPDATE_DATE,
3244: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3245: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3246: FROM HZ_PARTIES party, RA_CONTACT_PHONES_INT_ALL rcpi
3247: WHERE party.orig_system_reference = rcpi.orig_system_contact_ref
3248: AND party.request_id = p_request_id

Line 3245: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN

3241: SYSDATE CREATION_DATE,
3242: FND_GLOBAL.User_ID CREATED_BY,
3243: SYSDATE LAST_UPDATE_DATE,
3244: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3245: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3246: FROM HZ_PARTIES party, RA_CONTACT_PHONES_INT_ALL rcpi
3247: WHERE party.orig_system_reference = rcpi.orig_system_contact_ref
3248: AND party.request_id = p_request_id
3249: AND rcpi.interface_status is null

Line 3310: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,

3306: USING
3307: (SELECT 'THIRD_PARTY_SITE' PARTY_TYPE_CODE,
3308: ps.party_site_id PARTY_ID,
3309: loc.country COUNTRY_CODE,--4742586
3310: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
3311: NULL TAX_REFERENCE,
3312: SYSDATE CREATION_DATE,
3313: FND_GLOBAL.User_ID CREATED_BY,
3314: SYSDATE LAST_UPDATE_DATE,

Line 3313: FND_GLOBAL.User_ID CREATED_BY,

3309: loc.country COUNTRY_CODE,--4742586
3310: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
3311: NULL TAX_REFERENCE,
3312: SYSDATE CREATION_DATE,
3313: FND_GLOBAL.User_ID CREATED_BY,
3314: SYSDATE LAST_UPDATE_DATE,
3315: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3316: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3317: FROM HZ_PARTY_SITES ps, ra_customers_interface_all rci, -- Bug 4956131

Line 3315: FND_GLOBAL.User_ID LAST_UPDATED_BY,

3311: NULL TAX_REFERENCE,
3312: SYSDATE CREATION_DATE,
3313: FND_GLOBAL.User_ID CREATED_BY,
3314: SYSDATE LAST_UPDATE_DATE,
3315: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3316: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3317: FROM HZ_PARTY_SITES ps, ra_customers_interface_all rci, -- Bug 4956131
3318: HZ_LOCATIONS loc --4742586
3319: WHERE ps.orig_system_reference = rci.orig_system_address_ref

Line 3316: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN

3312: SYSDATE CREATION_DATE,
3313: FND_GLOBAL.User_ID CREATED_BY,
3314: SYSDATE LAST_UPDATE_DATE,
3315: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3316: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3317: FROM HZ_PARTY_SITES ps, ra_customers_interface_all rci, -- Bug 4956131
3318: HZ_LOCATIONS loc --4742586
3319: WHERE ps.orig_system_reference = rci.orig_system_address_ref
3320: AND loc.location_id = ps.location_id --4742586