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

Line 472: FROM hz_cust_accounts

468: AND enabled_flag='Y';
469:
470: CURSOR c_cust_account_id(p_cust_account_id IN NUMBER) IS
471: SELECT cust_account_id
472: FROM hz_cust_accounts
473: WHERE status ='A'
474: AND customer_type ='I'
475: AND cust_account_id =p_cust_account_id;
476:

Line 1845: hz_cust_accounts cust_acct

1841:
1842: CURSOR c_cust_account_id(p_cust_account_id IN NUMBER)IS
1843: SELECT cust_acct.cust_account_id
1844: FROM hz_parties party,
1845: hz_cust_accounts cust_acct
1846: WHERE cust_acct.party_id = party.party_id
1847: AND cust_acct.status = 'A'
1848: AND cust_acct.cust_account_id = p_cust_account_id;
1849:

Line 4440: FROM hz_cust_accounts

4436: WHERE request_number = p_request_number;
4437:
4438: CURSOR c_cust_account_id(p_cust_account_id IN NUMBER) IS
4439: SELECT cust_account_id
4440: FROM hz_cust_accounts
4441: WHERE status ='A'
4442: AND customer_type ='I'
4443: AND cust_account_id =p_cust_account_id;
4444: