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.ASO_PRICING_INT dependencies on HZ_CUST_ACCOUNTS

Line 393: FROM hz_cust_accounts

389: BEGIN
390:
391: SELECT customer_class_code
392: INTO x_class_code
393: FROM hz_cust_accounts
394: WHERE cust_account_id = p_cust_account_id;
395:
396: RETURN x_class_code;
397:

Line 441: FROM hz_cust_accounts

437: BEGIN
438:
439: SELECT sales_channel_code
440: INTO x_sales_channel_code
441: FROM hz_cust_accounts
442: WHERE cust_account_id = p_cust_account_id;
443:
444: RETURN x_sales_channel_code;
445:

Line 458: FROM hz_cust_accounts cust_acct, hz_parties party

454: BEGIN
455:
456: SELECT DECODE(PARTY.PARTY_TYPE, 'ORGANIZATION',PARTY.GSA_INDICATOR_FLAG,'N') gsa_indicator
457: INTO x_gsa
458: FROM hz_cust_accounts cust_acct, hz_parties party
459: WHERE cust_acct.cust_account_id = p_cust_account_id
460: and CUST_ACCT.PARTY_ID = PARTY.PARTY_ID;
461:
462: RETURN x_gsa;