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 2200: SELECT a.status FROM HZ_CUST_ACCOUNTS a

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

Line 2221: HZ_CUST_ACCOUNTS c

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

Line 2374: hz_cust_accounts

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

Line 2550: hz_cust_accounts

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

Line 2726: SELECT status from HZ_CUST_ACCOUNTS

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

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

6377: CURSOR C_INVOICE_TO_CUSTOMER IS
6378: --p_quote_header_rec.cust_account_id-->p_cust_acct_id
6379: SELECT 1 FROM DUAL WHERE EXISTS
6380: (
6381: SELECT hp.party_id --Removed HZ_CUST_ACCOUNTS ca
6382: FROM HZ_PARTIES hp
6383: WHERE hp.party_type in ('PERSON','ORGANIZATION')
6384: AND hp.party_id = p_cust_party_id
6385: AND hp.status = 'A'

Line 6825: -- HZ_CUST_ACCOUNTS ca,

6821: --SELECT 1 FROM DUAL WHERE EXISTS
6822: --(
6823: -- SELECT ca.account_number
6824: -- FROM HZ_PARTIES hp,
6825: -- HZ_CUST_ACCOUNTS ca,
6826: -- HZ_CUST_ACCT_RELATE car
6827: -- WHERE hp.party_id = ca.party_id
6828: -- AND ((car.related_cust_account_id = p_sold_to_cust_acct_id
6829: -- AND car.cust_account_id = ca.cust_account_id

Line 6846: HZ_CUST_ACCOUNTS ca,

6842: SELECT 1 FROM DUAL WHERE EXISTS
6843: (
6844: SELECT ca.account_number
6845: FROM HZ_PARTIES hp,
6846: HZ_CUST_ACCOUNTS ca,
6847: HZ_CUST_ACCT_RELATE car
6848: WHERE hp.party_id = ca.party_id
6849: AND car.related_cust_account_id = p_sold_to_cust_acct_id
6850: AND car.cust_account_id = ca.cust_account_id

Line 6864: HZ_CUST_ACCOUNTS ca

6860: AND car.status = 'A'
6861: UNION
6862: SELECT ca.account_number
6863: FROM HZ_PARTIES hp,
6864: HZ_CUST_ACCOUNTS ca
6865: WHERE hp.party_id = ca.party_id
6866: AND ca.cust_account_id = p_sold_to_cust_acct_id
6867: AND hp.party_id = p_cust_party_id
6868: AND ca.cust_account_id = p_cust_acct_id

Line 6884: -- HZ_CUST_ACCOUNTS ca,

6880: --SELECT 1 FROM DUAL WHERE EXISTS
6881: --(
6882: -- SELECT ca.account_number
6883: -- FROM HZ_PARTIES hp,
6884: -- HZ_CUST_ACCOUNTS ca,
6885: -- HZ_CUST_ACCT_RELATE car
6886: -- WHERE hp.party_id = ca.party_id
6887: -- AND ((car.related_cust_account_id = p_sold_to_cust_acct_id
6888: -- AND car.cust_account_id = ca.cust_account_id

Line 6903: HZ_CUST_ACCOUNTS ca,

6899: -- AND car.status = 'A'
6900: --) ;
6901: SELECT ca.account_number
6902: FROM HZ_PARTIES hp,
6903: HZ_CUST_ACCOUNTS ca,
6904: HZ_CUST_ACCT_RELATE car
6905: WHERE hp.party_id = ca.party_id
6906: AND car.related_cust_account_id = p_sold_to_cust_acct_id
6907: AND car.status = 'A'

Line 6919: HZ_CUST_ACCOUNTS ca

6915: AND ca.status = 'A'
6916: UNION
6917: SELECT ca.account_number
6918: FROM HZ_PARTIES hp,
6919: HZ_CUST_ACCOUNTS ca
6920: WHERE hp.party_id = ca.party_id
6921: AND ca.cust_account_id = p_sold_to_cust_acct_id
6922: AND hp.party_id = p_cust_party_id
6923: AND ca.cust_account_id = p_cust_acct_id

Line 6937: HZ_CUST_ACCOUNTS ca

6933: SELECT 1 FROM DUAL WHERE EXISTS
6934: (
6935: SELECT ca.account_number
6936: FROM HZ_PARTIES hp,
6937: HZ_CUST_ACCOUNTS ca
6938: WHERE hp.party_id = ca.party_id
6939: AND hp.party_type in ('PERSON','ORGANIZATION')
6940: AND hp.status = 'A'
6941: AND ca.status = 'A'

Line 6955: ,HZ_CUST_ACCOUNTS CA

6951: SELECT 1 FROM DUAL WHERE EXISTS
6952: (
6953: select null
6954: from HZ_PARTIES P
6955: ,HZ_CUST_ACCOUNTS CA
6956: where CA.status = 'A'
6957: AND p.party_type in ('PERSON','ORGANIZATION')
6958: AND P.party_id = p_cust_party_id
6959: AND P.status = 'A'

Line 7007: HZ_CUST_ACCOUNTS CA

7003: (
7004:
7005: select CA.account_number
7006: from HZ_PARTIES HP ,
7007: HZ_CUST_ACCOUNTS CA
7008: where CA.status = 'A'
7009: AND trunc(nvl(CA.account_activation_date, SYSDATE)) <= trunc(SYSDATE)
7010: AND trunc(nvl(CA.account_termination_date, SYSDATE)) >= trunc(SYSDATE)
7011: AND HP.status = 'A'

Line 7704: HZ_CUST_ACCOUNTS CA

7700: SELECT 1 FROM DUAL WHERE EXISTS
7701: (
7702: SELECT ca.account_number
7703: FROM HZ_PARTIES HP,
7704: HZ_CUST_ACCOUNTS CA
7705: WHERE hp.party_id = ca.party_id
7706: AND hp.status = 'A'
7707: AND ca.status = 'A'
7708: AND trunc(nvl(ca.account_activation_date,sysdate)) <= trunc(sysdate)

Line 7719: , HZ_CUST_ACCOUNTS CA

7715: SELECT 1 FROM DUAL WHERE EXISTS
7716: (
7717: select ca.account_number
7718: from HZ_PARTIES P
7719: , HZ_CUST_ACCOUNTS CA
7720: where CA.status = 'A'
7721: AND trunc(nvl(CA.account_activation_date, SYSDATE)) <= trunc(SYSDATE)
7722: AND trunc(nvl(CA.account_termination_date, SYSDATE)) >= trunc(SYSDATE)
7723: AND P.status = 'A'

Line 7743: ,HZ_CUST_ACCOUNTS CA

7739: (
7740:
7741: select null
7742: from HZ_PARTIES P
7743: ,HZ_CUST_ACCOUNTS CA
7744: where CA.status = 'A'
7745: AND P.status = 'A'
7746: AND P.party_id = CA.party_id
7747: AND P.party_id = p_cust_party_id --Added joins for cust_acct_id and