[Home] [Help]
206: CURSOR c_validate_partner(l_party_id IN NUMBER)
207: IS
208: SELECT 'Y'
209: FROM HZ_PARTIES PARTY, HZ_PARTIES PARTY2,
210: HZ_PARTIES PARTY3, HZ_RELATIONSHIPS REL
211: WHERE (PARTY.PARTY_TYPE = 'ORGANIZATION' AND PARTY.PARTY_ID = REL.SUBJECT_ID)
212: AND REL.RELATIONSHIP_CODE IN ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF',
213: 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER',
214: 'CUSTOMER_INDIRECTLY_MANAGED_BY')
226: AND party.party_id = l_party_id
227: UNION ALL
228: SELECT 'Y'
229: FROM HZ_PARTIES PARTY, HZ_PARTIES PARTY2,
230: HZ_PARTIES PARTY3, HZ_RELATIONSHIPS REL
231: WHERE (PARTY.PARTY_TYPE = 'PARTY_RELATIONSHIP' AND PARTY.PARTY_ID = REL.PARTY_ID )
232: AND REL.RELATIONSHIP_CODE IN ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF',
233: 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER',
234: 'CUSTOMER_INDIRECTLY_MANAGED_BY')
284: IS
285: SELECT 'Y'
286: -- SELECT PARTY.PARTY_ID PARTY_ID , ORG_CONT.PARTY_SITE_ID PARTY_SITE_ID , ORG_CONT.ORG_CONTACT_ID CONTACT_ID ,
287: -- ORG_CONT.CONTACT_NUMBER CONTACT_NUMBER , PARTY.PARTY_NAME CONTACT_NAME , CONT_ROLE.PRIMARY_FLAG PRIMARY_FLAG
288: FROM HZ_PARTIES PARTY , HZ_RELATIONSHIPS PARTY_REL , HZ_ORG_CONTACTS ORG_CONT ,
289: HZ_ORG_CONTACT_ROLES CONT_ROLE
290: WHERE PARTY.STATUS = 'A'
291: AND PARTY.PARTY_TYPE = 'PERSON'
292: AND PARTY_REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
304: SELECT 'Y'
305: -- SELECT PARTY5.PARTY_ID PARTY_ID , ORG_CONT.PARTY_SITE_ID PARTY_SITE_ID ,
306: -- ORG_CONT.ORG_CONTACT_ID CONTACT_ID , ORG_CONT.CONTACT_NUMBER CONTACT_NUMBER ,
307: -- PARTY5.PARTY_NAME CONTACT_NAME , CONT_ROLE.PRIMARY_FLAG PRIMARY_FLAG
308: FROM HZ_PARTIES PARTY3 , HZ_PARTIES PARTY4 , HZ_PARTIES PARTY5 , HZ_RELATIONSHIPS PARTY_REL ,
309: HZ_ORG_CONTACTS ORG_CONT , HZ_ORG_CONTACT_ROLES CONT_ROLE
310: WHERE PARTY_REL.PARTY_ID = PARTY5.PARTY_ID
311: AND PARTY5.PARTY_TYPE = 'PARTY_RELATIONSHIP'
312: AND PARTY5.STATUS = 'A'
331: SELECT 'Y'
332: -- SELECT PARTY4.PARTY_ID PARTY_ID , ORG_CONT.PARTY_SITE_ID PARTY_SITE_ID ,
333: -- ORG_CONT.ORG_CONTACT_ID CONTACT_ID , ORG_CONT.CONTACT_NUMBER CONTACT_NUMBER ,
334: -- PARTY3.PARTY_NAME CONTACT_NAME , CONT_ROLE.PRIMARY_FLAG PRIMARY_FLAG
335: FROM HZ_PARTIES PARTY3 , HZ_PARTIES PARTY4 , HZ_RELATIONSHIPS PARTY_REL ,
336: HZ_ORG_CONTACTS ORG_CONT , HZ_ORG_CONTACT_ROLES CONT_ROLE
337: WHERE PARTY_REL.SUBJECT_ID = PARTY3.PARTY_ID
338: AND PARTY3.PARTY_TYPE = 'PERSON'
339: AND PARTY3.STATUS = 'A'
376: WHERE party_id = l_party_id
377: AND nvl(party_site_id, 0) = nvl(l_party_site_id, 0)
378: AND contact_id = l_contact_id; */
379: -- changed the query the validate party contact id according to bug 2954064 as provided by the PRM team , sudarsana 2nd july 2004
380: FROM hz_relationships hzr,
381: hz_org_contacts hzoc
382: WHERE hzr.party_id = l_party_id
383: AND hzoc.org_contact_id = l_contact_id
384: AND hzr.directional_flag = 'F'
2580: CURSOR c_validate_partner(l_party_id IN NUMBER)
2581: IS
2582: SELECT 'Y'
2583: FROM HZ_PARTIES PARTY, HZ_PARTIES PARTY2,
2584: HZ_PARTIES PARTY3, HZ_RELATIONSHIPS REL
2585: WHERE (PARTY.PARTY_TYPE = 'ORGANIZATION' AND PARTY.PARTY_ID = REL.SUBJECT_ID)
2586: AND REL.RELATIONSHIP_CODE IN ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF',
2587: 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER',
2588: 'CUSTOMER_INDIRECTLY_MANAGED_BY')
2600: AND party.party_id = l_party_id
2601: UNION ALL
2602: SELECT 'Y'
2603: FROM HZ_PARTIES PARTY, HZ_PARTIES PARTY2,
2604: HZ_PARTIES PARTY3, HZ_RELATIONSHIPS REL
2605: WHERE (PARTY.PARTY_TYPE = 'PARTY_RELATIONSHIP' AND PARTY.PARTY_ID = REL.PARTY_ID )
2606: AND REL.RELATIONSHIP_CODE IN ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF',
2607: 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER',
2608: 'CUSTOMER_INDIRECTLY_MANAGED_BY')
2651: IS
2652: SELECT 'Y'
2653: -- SELECT PARTY.PARTY_ID PARTY_ID , ORG_CONT.PARTY_SITE_ID PARTY_SITE_ID , ORG_CONT.ORG_CONTACT_ID CONTACT_ID ,
2654: -- ORG_CONT.CONTACT_NUMBER CONTACT_NUMBER , PARTY.PARTY_NAME CONTACT_NAME , CONT_ROLE.PRIMARY_FLAG PRIMARY_FLAG
2655: FROM HZ_PARTIES PARTY , HZ_RELATIONSHIPS PARTY_REL , HZ_ORG_CONTACTS ORG_CONT ,
2656: HZ_ORG_CONTACT_ROLES CONT_ROLE
2657: WHERE PARTY.STATUS = 'A'
2658: AND PARTY.PARTY_TYPE = 'PERSON'
2659: AND PARTY_REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
2671: SELECT 'Y'
2672: -- SELECT PARTY5.PARTY_ID PARTY_ID , ORG_CONT.PARTY_SITE_ID PARTY_SITE_ID ,
2673: -- ORG_CONT.ORG_CONTACT_ID CONTACT_ID , ORG_CONT.CONTACT_NUMBER CONTACT_NUMBER ,
2674: -- PARTY5.PARTY_NAME CONTACT_NAME , CONT_ROLE.PRIMARY_FLAG PRIMARY_FLAG
2675: FROM HZ_PARTIES PARTY3 , HZ_PARTIES PARTY4 , HZ_PARTIES PARTY5 , HZ_RELATIONSHIPS PARTY_REL ,
2676: HZ_ORG_CONTACTS ORG_CONT , HZ_ORG_CONTACT_ROLES CONT_ROLE
2677: WHERE PARTY_REL.PARTY_ID = PARTY5.PARTY_ID
2678: AND PARTY5.PARTY_TYPE = 'PARTY_RELATIONSHIP'
2679: AND PARTY5.STATUS = 'A'
2698: SELECT 'Y'
2699: -- SELECT PARTY4.PARTY_ID PARTY_ID , ORG_CONT.PARTY_SITE_ID PARTY_SITE_ID ,
2700: -- ORG_CONT.ORG_CONTACT_ID CONTACT_ID , ORG_CONT.CONTACT_NUMBER CONTACT_NUMBER ,
2701: -- PARTY3.PARTY_NAME CONTACT_NAME , CONT_ROLE.PRIMARY_FLAG PRIMARY_FLAG
2702: FROM HZ_PARTIES PARTY3 , HZ_PARTIES PARTY4 , HZ_RELATIONSHIPS PARTY_REL ,
2703: HZ_ORG_CONTACTS ORG_CONT , HZ_ORG_CONTACT_ROLES CONT_ROLE
2704: WHERE PARTY_REL.SUBJECT_ID = PARTY3.PARTY_ID
2705: AND PARTY3.PARTY_TYPE = 'PERSON'
2706: AND PARTY3.STATUS = 'A'
2740: WHERE party_id = l_party_id
2741: AND nvl(party_site_id, 0) = nvl(l_party_site_id, 0)
2742: AND contact_id = l_contact_id; */
2743: -- changed the query the validate party contact id according to bug 2954064 as provided by the PRM team , sudarsana 2nd july 2004
2744: FROM hz_relationships hzr,
2745: hz_org_contacts hzoc
2746: WHERE hzr.party_id = l_party_id
2747: AND hzoc.org_contact_id = l_contact_id
2748: AND hzr.directional_flag = 'F'