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 651: FROM hz_cust_accounts

647: AND enabled_flag='Y';
648: */
649: CURSOR c_cust_account_id(p_cust_account_id IN NUMBER) IS
650: SELECT cust_account_id
651: FROM hz_cust_accounts
652: WHERE status ='A'
653: AND customer_type ='I'
654: AND cust_account_id =p_cust_account_id;
655:

Line 2245: hz_cust_accounts cust_acct

2241:
2242: CURSOR c_cust_account_id(p_cust_account_id IN NUMBER)IS
2243: SELECT cust_acct.cust_account_id
2244: FROM hz_parties party,
2245: hz_cust_accounts cust_acct
2246: WHERE cust_acct.party_id = party.party_id
2247: AND cust_acct.status = 'A'
2248: AND cust_acct.cust_account_id = p_cust_account_id;
2249:

Line 5024: FROM hz_cust_accounts

5020: WHERE request_number = p_request_number;
5021:
5022: CURSOR c_cust_account_id(p_cust_account_id IN NUMBER) IS
5023: SELECT cust_account_id
5024: FROM hz_cust_accounts
5025: WHERE status ='A'
5026: AND customer_type ='I'
5027: AND cust_account_id =p_cust_account_id;
5028: