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 HZ_CUST_ACCOUNTS

Line 4934: hz_cust_accounts accts

4930: SELECT accts.party_id,
4931: sites.cust_account_id
4932: FROM hz_cust_site_uses_all site_uses,
4933: hz_cust_acct_sites_all sites,
4934: hz_cust_accounts accts
4935: WHERE site_uses.site_use_id = p_site_use_id
4936: AND site_uses.site_use_code = p_site_use_code
4937: AND site_uses.cust_acct_site_id = sites.cust_acct_site_id
4938: AND sites.cust_account_id = accts.cust_account_id;

Line 6547: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P

6543: l_rel_cust_flag VARCHAR2 (5) := 'Y';
6544:
6545: CURSOR get_cust_id(l_cust_acct_id NUMBER) IS
6546: SELECT P.PARTY_NAME name, CA.PARTY_ID party_id
6547: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P
6548: WHERE CA.PARTY_ID = P.PARTY_ID AND
6549: CA.CUST_ACCOUNT_ID = l_cust_acct_id;
6550:
6551: -- This cursor will return the party id of the customer or third party

Line 6577: -- replaced OKX_CUSTOMER_ACCOUNTS_V with HZ_CUST_ACCOUNTS

6573:
6574: -- If the party id does not belong to the customer or third party then
6575: -- it might belong to the related customer account. If not give an error.
6576: -- replaced OKX_CUST_ACCT_RELATE_ALL_V with HZ_CUST_ACCT_RELATE_ALL
6577: -- replaced OKX_CUSTOMER_ACCOUNTS_V with HZ_CUST_ACCOUNTS
6578: CURSOR get_related_cust_acct_id(orgId NUMBER, relatedCustAccId NUMBER,
6579: custPartyId NUMBER) IS
6580: SELECT A.CUST_ACCOUNT_ID, A.RELATED_CUST_ACCOUNT_ID
6581: FROM HZ_CUST_ACCT_RELATE_ALL A,

Line 6582: HZ_CUST_ACCOUNTS CA

6578: CURSOR get_related_cust_acct_id(orgId NUMBER, relatedCustAccId NUMBER,
6579: custPartyId NUMBER) IS
6580: SELECT A.CUST_ACCOUNT_ID, A.RELATED_CUST_ACCOUNT_ID
6581: FROM HZ_CUST_ACCT_RELATE_ALL A,
6582: HZ_CUST_ACCOUNTS CA
6583: WHERE CA.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID
6584: AND CA.PARTY_ID = custPartyId
6585: AND A.RELATED_CUST_ACCOUNT_ID = relatedCustAccId
6586: AND CA.STATUS = 'A'

Line 6717: FROM hz_cust_accounts

6713: AND CS.cust_acct_site_id = CA.cust_acct_site_id;
6714:
6715: CURSOR is_cust_active(l_cust_acct_id NUMBER) IS
6716: SELECT status
6717: FROM hz_cust_accounts
6718: WHERE cust_account_id = l_cust_acct_id
6719: AND status = 'A';
6720:
6721: CURSOR get_contr_cust IS

Line 6732: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P

6728: CURSOR is_cust_hdr_active(l_party_id NUMBER) IS
6729: SELECT CA.CUST_ACCOUNT_ID,
6730: ca.status,
6731: decode(CA.ACCOUNT_NAME, NULL, P.PARTY_NAME, CA.Account_NAME) NAME
6732: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P
6733: WHERE CA.PARTY_ID = P.PARTY_ID
6734: AND P.PARTY_ID = l_party_id;
6735:
6736: -- GCHADHA --

Line 6755: hz_cust_accounts c,

6751: c.cust_account_id CUST_ID1,
6752: p.party_id party_id
6753:
6754: FROM OKX_CUST_SITE_USES_V a,
6755: hz_cust_accounts c,
6756: hz_parties p
6757: WHERE a.id1 = p_bill_to_site_use_id
6758: AND c.cust_account_id = a.cust_account_id
6759: AND a.site_use_code = 'BILL_TO'

Line 6767: hz_cust_accounts c,

6763: SELECT
6764: c.cust_account_id CUST_ID1,
6765: p.party_id party_id
6766: FROM OKX_CUST_SITE_USES_V a,
6767: hz_cust_accounts c,
6768: hz_parties p
6769: WHERE a.id1 = p_ship_to_site_use_id
6770: AND c.cust_account_id = a.cust_account_id
6771: AND a.site_use_code = 'SHIP_TO'

Line 6777: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P

6773:
6774: CURSOR Get_Status_Party (l_cust_acct_id IN NUMBER, l_party_id IN NUMBER) IS
6775: SELECT CA.CUST_ACCOUNT_ID, ca.status,
6776: decode(CA.ACCOUNT_NAME, NULL, P.PARTY_NAME, CA.Account_NAME) NAME
6777: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P
6778: WHERE CA.PARTY_ID = P.PARTY_ID
6779: AND P.PARTY_ID = l_party_id
6780: AND CA.CUST_ACCOUNT_ID = l_cust_acct_id;
6781:

Line 6796: SELECT /+ index(B.CA HZ_CUST_ACCOUNTS_N2) / rle_code, B.Status, B.PARTY_STATUS

6792: /*added hint based upon appsperf team suggestion - bug9789087*/
6793: -- Use this Cursor to find Customer /Third Party related to the
6794: -- Customer_account which is inactive
6795: CURSOR get_parent_party (p_org_id IN NUMBER, p_id IN NUMBER) IS
6796: SELECT /*+ index(B.CA HZ_CUST_ACCOUNTS_N2) */ rle_code, B.Status, B.PARTY_STATUS
6797: FROM okc_k_party_roles_b A,
6798: (SELECT CA.PARTY_ID, A.Status, CA.STATUS PARTY_STATUS FROM HZ_CUST_ACCT_RELATE_ALL A,
6799: HZ_CUST_ACCOUNTS CA WHERE CA.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID
6800: AND A.RELATED_CUST_ACCOUNT_ID = p_id

Line 6799: HZ_CUST_ACCOUNTS CA WHERE CA.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID

6795: CURSOR get_parent_party (p_org_id IN NUMBER, p_id IN NUMBER) IS
6796: SELECT /*+ index(B.CA HZ_CUST_ACCOUNTS_N2) */ rle_code, B.Status, B.PARTY_STATUS
6797: FROM okc_k_party_roles_b A,
6798: (SELECT CA.PARTY_ID, A.Status, CA.STATUS PARTY_STATUS FROM HZ_CUST_ACCT_RELATE_ALL A,
6799: HZ_CUST_ACCOUNTS CA WHERE CA.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID
6800: AND A.RELATED_CUST_ACCOUNT_ID = p_id
6801: AND A.org_id = p_org_id) B
6802: WHERE A.rle_code NOT IN ('VENDOR', 'MERCHANT')
6803: AND A.dnz_chr_id = p_chr_id

Line 6813: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P

6809: -- Check whether the customer/third party is active or not.
6810: CURSOR Get_Status_Party_Main (l_party_id IN NUMBER) IS
6811: SELECT CA.CUST_ACCOUNT_ID, ca.status,
6812: decode(CA.ACCOUNT_NAME, NULL, P.PARTY_NAME, CA.Account_NAME) NAME
6813: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES P
6814: WHERE CA.PARTY_ID = P.PARTY_ID
6815: AND P.PARTY_ID = l_party_id
6816: AND CA.STATUS = 'A';
6817: