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.

[Home] [Help]

APPS.WSH_BATCH_PROCESS dependencies on HZ_CUST_ACCOUNTS

Line 2897: FROM hz_parties Party, hz_cust_accounts cust_acct

2893: --TCA View Changes Start
2894: --RTV changes
2895: CURSOR get_customer_name(c_customer_id varchar2) IS
2896: SELECT substrb ( party.party_name, 1, 50 ) customer_name
2897: FROM hz_parties Party, hz_cust_accounts cust_acct
2898: WHERE cust_acct.party_id = party.party_id AND
2899: cust_acct.cust_account_id = to_number(SubStr(c_customer_id,3))
2900: AND SubStr(c_customer_id,1,1) = 'C'
2901: UNION

Line 3634: FROM hz_parties Party, hz_cust_accounts cust_acct

3630: --TCA View Changes Start
3631: --RTV changes
3632: CURSOR get_customer_name(c_customer_id varchar2) IS
3633: SELECT substrb ( party.party_name, 1, 50 ) customer_name
3634: FROM hz_parties Party, hz_cust_accounts cust_acct
3635: WHERE cust_acct.party_id = party.party_id AND
3636: cust_acct.cust_account_id = to_number(SubStr(c_customer_id,3))
3637: AND SubStr(c_customer_id,1,1) = 'C'
3638: UNION