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

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

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

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

Line 2394: FROM HZ_RELATIONSHIPS

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

Line 2561: hz_relationships

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

Line 2716: HZ_RELATIONSHIPS b

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
2720: SELECT status from HZ_PARTIES a

Line 2850: FROM hz_relationships par,

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

Line 3234: FROM hz_relationships par,

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

Line 6211: HZ_RELATIONSHIPS hp_rltn

6207: SELECT 1 FROM DUAL WHERE EXISTS
6208: (
6209: SELECT hp_contact.party_name
6210: FROM HZ_PARTIES hp_contact,
6211: HZ_RELATIONSHIPS hp_rltn
6212: WHERE hp_rltn.object_id = p_cust_party_id --lv_cust_party_id
6213: AND hp_rltn.party_id = p_party_id
6214: AND hp_contact.party_id = hp_rltn.subject_id
6215: AND hp_contact.party_type = 'PERSON'