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_ORG_CONTACTS

Line 214: SELECT status FROM HZ_ORG_CONTACTS

210: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
211: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
212: IS
213: CURSOR C_Contact IS
214: SELECT status FROM HZ_ORG_CONTACTS
215: WHERE org_contact_id = p_contact_id;
216:
217: l_contact_status VARCHAR2(1);
218:

Line 1923: FROM HZ_ORG_CONTACTS a, HZ_RELATIONSHIPS b

1919: IS
1920:
1921: CURSOR C_Contact(l_contact_id NUMBER) IS
1922: SELECT subject_id, a.status
1923: FROM HZ_ORG_CONTACTS a, HZ_RELATIONSHIPS b
1924: WHERE org_contact_id = l_contact_id
1925: AND a.party_relationship_id = b.relationship_id
1926: AND b.subject_type = 'PERSON';
1927:

Line 2216: HZ_RELATIONSHIPS a, HZ_ORG_CONTACTS b

2212: WHERE party_id= l_pty_id;
2213:
2214: CURSOR C_relation IS
2215: SELECT 'x' FROM
2216: HZ_RELATIONSHIPS a, HZ_ORG_CONTACTS b
2217: WHERE a.relationship_id = b.party_relationship_id
2218: AND a.object_id = p_cust_party_id;
2219:
2220: CURSOR C_org_reltn IS

Line 2222: HZ_RELATIONSHIPS a, HZ_ORG_CONTACTS b,

2218: AND a.object_id = p_cust_party_id;
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;

Line 2364: HZ_RELATIONSHIPS a, hz_org_contacts b

2360: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2361: IS
2362: CURSOR C_val_inv_id(lc_party_id number) IS
2363: SELECT 'x' FROM
2364: HZ_RELATIONSHIPS a, hz_org_contacts b
2365: WHERE
2366: a.party_id = p_inv_party_id
2367: AND a.object_id = lc_party_id
2368: AND b.party_relationship_id = a.relationship_id

Line 2717: SELECT object_id ,a.status FROM HZ_ORG_CONTACTS a,

2713: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2714: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2715: IS
2716: CURSOR C_Contact IS
2717: SELECT object_id ,a.status FROM HZ_ORG_CONTACTS a,
2718: HZ_RELATIONSHIPS b
2719: WHERE org_contact_id = p_contact_id
2720: and a.party_relationship_id = b.relationship_id
2721: and b.object_type = 'ORGANIZATION';

Line 2854: hz_org_contacts org

2850:
2851: CURSOR C_Get_Party_From_Org(l_org_contact_id NUMBER) IS
2852: SELECT par.party_id
2853: FROM hz_relationships par,
2854: hz_org_contacts org
2855: WHERE org.party_relationship_id = par.relationship_id
2856: AND org.org_contact_id = l_org_contact_id
2857: -- AND org.status = 'A' status column obseleted
2858: and par.status = 'A'

Line 3238: hz_org_contacts org

3234:
3235: CURSOR C_Get_Party_From_Org(l_org_contact_id NUMBER) IS
3236: SELECT par.party_id
3237: FROM hz_relationships par,
3238: hz_org_contacts org
3239: WHERE org.party_relationship_id = par.relationship_id
3240: AND org.org_contact_id = l_org_contact_id
3241: -- AND org.status = 'A' -- status column obseleted
3242: and par.status = 'A'