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:
1927: CURSOR C_Party_Cust(l_party_id NUMBER) IS

Line 2214: HZ_RELATIONSHIPS a, HZ_ORG_CONTACTS b

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

Line 2220: HZ_RELATIONSHIPS a, HZ_ORG_CONTACTS b,

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

Line 2362: HZ_RELATIONSHIPS a, hz_org_contacts b

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

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

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

Line 2851: hz_org_contacts org

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

Line 3235: hz_org_contacts org

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