APPS.ASO_VALIDATE_PVT dependencies on HZ_RELATIONSHIPS

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 2230: FROM HZ_RELATIONSHIPS

2226: AND a.object_id = c.party_id;
2227:
2228: CURSOR C_Person_Reltn (l_party NUMBER) IS
2229: SELECT 'X'
2230: FROM HZ_RELATIONSHIPS
2231: WHERE party_id = l_party
2232: AND subject_type = 'PERSON'
2233: AND object_type = 'PERSON';
2234:

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 2387: hz_relationships

2383:
2384: CURSOR C_relation_object IS
2385: select object_id
2386: from
2387: hz_relationships
2388: where party_id = p_party_id
2389: and subject_type ='PERSON'
2390: and subject_table_name = 'HZ_PARTIES'
2391: and object_type = 'ORGANIZATION'

Line 2396: FROM HZ_RELATIONSHIPS

2392: and object_table_name = 'HZ_PARTIES';
2393:
2394: CURSOR C_Person_Reltn (l_party NUMBER) IS
2395: SELECT 'X'
2396: FROM HZ_RELATIONSHIPS
2397: WHERE party_id = l_party
2398: AND subject_type = 'PERSON'
2399: AND object_type = 'PERSON';
2400:

Line 2563: hz_relationships

2559:
2560: CURSOR C_relation_object(px_party_id number) IS
2561: select object_id
2562: from
2563: hz_relationships
2564: where party_id = px_party_id
2565: and subject_type ='PERSON'
2566: and subject_table_name = 'HZ_PARTIES'
2567: and object_type = 'ORGANIZATION'

Line 2718: HZ_RELATIONSHIPS b

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';
2722: CURSOR C_Party(l_party_id NUMBER) IS

Line 2853: FROM hz_relationships par,

2849: lp_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
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

Line 3237: FROM hz_relationships par,

3233: lp_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
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

Line 6227: HZ_RELATIONSHIPS hp_rltn

6223: SELECT 1 FROM DUAL WHERE EXISTS
6224: (
6225: SELECT hp_contact.party_name
6226: FROM HZ_PARTIES hp_contact,
6227: HZ_RELATIONSHIPS hp_rltn
6228: WHERE hp_rltn.object_id = p_cust_party_id --lv_cust_party_id
6229: AND hp_rltn.party_id = p_party_id
6230: AND hp_contact.party_id = hp_rltn.subject_id
6231: AND hp_contact.party_type = 'PERSON'