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.OKS_QA_DATA_INTEGRITY dependencies on OKX_CUSTOMER_ACCOUNTS_V

Line 2947: FROM okx_customer_accounts_v

2943: **/
2944:
2945: CURSOR Get_Customer_Name (p_cust_acct_id IN NUMBER) IS
2946: SELECT name
2947: FROM okx_customer_accounts_v
2948: WHERE id1 = p_cust_acct_id;
2949:
2950: -- IKON ENHANCEMENT -
2951: CURSOR get_hdr_tax_exemp(p_chr_id NUMBER) IS

Line 6430: -- replaced OKX_CUSTOMER_ACCOUNTS_V with HZ_CUST_ACCOUNTS

6426:
6427: -- If the party id does not belong to the customer or third party then
6428: -- it might belong to the related customer account. If not give an error.
6429: -- replaced OKX_CUST_ACCT_RELATE_ALL_V with HZ_CUST_ACCT_RELATE_ALL
6430: -- replaced OKX_CUSTOMER_ACCOUNTS_V with HZ_CUST_ACCOUNTS
6431: CURSOR get_related_cust_acct_id(orgId NUMBER, relatedCustAccId NUMBER,
6432: custPartyId NUMBER) IS
6433: SELECT A.CUST_ACCOUNT_ID, A.RELATED_CUST_ACCOUNT_ID
6434: FROM HZ_CUST_ACCT_RELATE_ALL A,