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

Line 1794: FROM HZ_CUST_ACCOUNTS

1790: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1791: IS
1792: CURSOR C_Account(l_account_id NUMBER) IS
1793: SELECT status, account_activation_date, account_termination_date
1794: FROM HZ_CUST_ACCOUNTS
1795: WHERE cust_account_id = l_account_id;
1796:
1797: l_api_name VARCHAR2(40) := 'Validate_CustAccount_bsc' ;
1798: l_account_status VARCHAR2(1);

Line 2202: SELECT a.status FROM HZ_CUST_ACCOUNTS a

2198: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2199: IS
2200:
2201: CURSOR C_Account IS
2202: SELECT a.status FROM HZ_CUST_ACCOUNTS a
2203: WHERE a.party_id = p_cust_party_id AND cust_account_id = p_cust_account_id;
2204:
2205: CURSOR C_Account_Role IS
2206: SELECT begin_date, end_date FROM HZ_CUST_ACCOUNT_ROLES

Line 2223: HZ_CUST_ACCOUNTS c

2219:
2220: CURSOR C_org_reltn IS
2221: SELECT 'x' FROM
2222: HZ_RELATIONSHIPS a, HZ_ORG_CONTACTS b,
2223: HZ_CUST_ACCOUNTS c
2224: WHERE a.relationship_id= b.party_relationship_id
2225: AND c.cust_Account_id = p_cust_account_id
2226: AND a.object_id = c.party_id;
2227:

Line 2376: hz_cust_accounts

2372:
2373:
2374: CURSOR C_Cust_party_id(l_cust_acct_id number) IS
2375: select party_id from
2376: hz_cust_accounts
2377: where
2378: cust_account_id = l_cust_acct_id;
2379: CURSOR C_party_type IS
2380: select party_type

Line 2552: hz_cust_accounts

2548: AND b.party_site_id = l_party_site_id;
2549:
2550: CURSOR C_Cust_party_id(l_cust_acct_id number) IS
2551: select party_id from
2552: hz_cust_accounts
2553: where
2554: cust_account_id = l_cust_acct_id;
2555: CURSOR C_party_type IS
2556: select party_type

Line 2729: SELECT status from HZ_CUST_ACCOUNTS

2725: AND Party_type in('ORGANIZATION','PARTY_RELATIONSHIP');
2726:
2727:
2728: CURSOR C_Cust_account(l_party_id NUMBER) IS
2729: SELECT status from HZ_CUST_ACCOUNTS
2730: WHERE party_id=l_party_id and
2731: cust_account_id = p_cust_account_id;
2732: l_party_relationship_id NUMBER;
2733: l_object_id NUMBER;

Line 6397: SELECT hp.party_id --Removed HZ_CUST_ACCOUNTS ca

6393: CURSOR C_INVOICE_TO_CUSTOMER IS
6394: --p_quote_header_rec.cust_account_id-->p_cust_acct_id
6395: SELECT 1 FROM DUAL WHERE EXISTS
6396: (
6397: SELECT hp.party_id --Removed HZ_CUST_ACCOUNTS ca
6398: FROM HZ_PARTIES hp
6399: WHERE hp.party_type in ('PERSON','ORGANIZATION')
6400: AND hp.party_id = p_cust_party_id
6401: AND hp.status = 'A'

Line 6841: -- HZ_CUST_ACCOUNTS ca,

6837: --SELECT 1 FROM DUAL WHERE EXISTS
6838: --(
6839: -- SELECT ca.account_number
6840: -- FROM HZ_PARTIES hp,
6841: -- HZ_CUST_ACCOUNTS ca,
6842: -- HZ_CUST_ACCT_RELATE car
6843: -- WHERE hp.party_id = ca.party_id
6844: -- AND ((car.related_cust_account_id = p_sold_to_cust_acct_id
6845: -- AND car.cust_account_id = ca.cust_account_id

Line 6862: HZ_CUST_ACCOUNTS ca,

6858: SELECT 1 FROM DUAL WHERE EXISTS
6859: (
6860: SELECT ca.account_number
6861: FROM HZ_PARTIES hp,
6862: HZ_CUST_ACCOUNTS ca,
6863: HZ_CUST_ACCT_RELATE car
6864: WHERE hp.party_id = ca.party_id
6865: AND car.related_cust_account_id = p_sold_to_cust_acct_id
6866: AND car.cust_account_id = ca.cust_account_id

Line 6880: HZ_CUST_ACCOUNTS ca

6876: AND car.status = 'A'
6877: UNION
6878: SELECT ca.account_number
6879: FROM HZ_PARTIES hp,
6880: HZ_CUST_ACCOUNTS ca
6881: WHERE hp.party_id = ca.party_id
6882: AND ca.cust_account_id = p_sold_to_cust_acct_id
6883: AND hp.party_id = p_cust_party_id
6884: AND ca.cust_account_id = p_cust_acct_id

Line 6900: -- HZ_CUST_ACCOUNTS ca,

6896: --SELECT 1 FROM DUAL WHERE EXISTS
6897: --(
6898: -- SELECT ca.account_number
6899: -- FROM HZ_PARTIES hp,
6900: -- HZ_CUST_ACCOUNTS ca,
6901: -- HZ_CUST_ACCT_RELATE car
6902: -- WHERE hp.party_id = ca.party_id
6903: -- AND ((car.related_cust_account_id = p_sold_to_cust_acct_id
6904: -- AND car.cust_account_id = ca.cust_account_id

Line 6919: HZ_CUST_ACCOUNTS ca,

6915: -- AND car.status = 'A'
6916: --) ;
6917: SELECT ca.account_number
6918: FROM HZ_PARTIES hp,
6919: HZ_CUST_ACCOUNTS ca,
6920: HZ_CUST_ACCT_RELATE car
6921: WHERE hp.party_id = ca.party_id
6922: AND car.related_cust_account_id = p_sold_to_cust_acct_id
6923: AND car.status = 'A'

Line 6935: HZ_CUST_ACCOUNTS ca

6931: AND ca.status = 'A'
6932: UNION
6933: SELECT ca.account_number
6934: FROM HZ_PARTIES hp,
6935: HZ_CUST_ACCOUNTS ca
6936: WHERE hp.party_id = ca.party_id
6937: AND ca.cust_account_id = p_sold_to_cust_acct_id
6938: AND hp.party_id = p_cust_party_id
6939: AND ca.cust_account_id = p_cust_acct_id

Line 6953: HZ_CUST_ACCOUNTS ca

6949: SELECT 1 FROM DUAL WHERE EXISTS
6950: (
6951: SELECT ca.account_number
6952: FROM HZ_PARTIES hp,
6953: HZ_CUST_ACCOUNTS ca
6954: WHERE hp.party_id = ca.party_id
6955: AND hp.party_type in ('PERSON','ORGANIZATION')
6956: AND hp.status = 'A'
6957: AND ca.status = 'A'

Line 6971: ,HZ_CUST_ACCOUNTS CA

6967: SELECT 1 FROM DUAL WHERE EXISTS
6968: (
6969: select null
6970: from HZ_PARTIES P
6971: ,HZ_CUST_ACCOUNTS CA
6972: where CA.status = 'A'
6973: AND p.party_type in ('PERSON','ORGANIZATION')
6974: AND P.party_id = p_cust_party_id
6975: AND P.status = 'A'

Line 7023: HZ_CUST_ACCOUNTS CA

7019: (
7020:
7021: select CA.account_number
7022: from HZ_PARTIES HP ,
7023: HZ_CUST_ACCOUNTS CA
7024: where CA.status = 'A'
7025: AND trunc(nvl(CA.account_activation_date, SYSDATE)) <= trunc(SYSDATE)
7026: AND trunc(nvl(CA.account_termination_date, SYSDATE)) >= trunc(SYSDATE)
7027: AND HP.status = 'A'

Line 7720: HZ_CUST_ACCOUNTS CA

7716: SELECT 1 FROM DUAL WHERE EXISTS
7717: (
7718: SELECT ca.account_number
7719: FROM HZ_PARTIES HP,
7720: HZ_CUST_ACCOUNTS CA
7721: WHERE hp.party_id = ca.party_id
7722: AND hp.status = 'A'
7723: AND ca.status = 'A'
7724: AND trunc(nvl(ca.account_activation_date,sysdate)) <= trunc(sysdate)

Line 7735: , HZ_CUST_ACCOUNTS CA

7731: SELECT 1 FROM DUAL WHERE EXISTS
7732: (
7733: select ca.account_number
7734: from HZ_PARTIES P
7735: , HZ_CUST_ACCOUNTS CA
7736: where CA.status = 'A'
7737: AND trunc(nvl(CA.account_activation_date, SYSDATE)) <= trunc(SYSDATE)
7738: AND trunc(nvl(CA.account_termination_date, SYSDATE)) >= trunc(SYSDATE)
7739: AND P.status = 'A'

Line 7759: ,HZ_CUST_ACCOUNTS CA

7755: (
7756:
7757: select null
7758: from HZ_PARTIES P
7759: ,HZ_CUST_ACCOUNTS CA
7760: where CA.status = 'A'
7761: AND P.status = 'A'
7762: AND P.party_id = CA.party_id
7763: AND P.party_id = p_cust_party_id --Added joins for cust_acct_id and