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.JTF_RS_RESOURCE_PUB dependencies on HZ_PARTIES

Line 209: FROM HZ_PARTIES PARTY, HZ_PARTIES PARTY2,

205: */
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',

Line 210: HZ_PARTIES PARTY3, HZ_RELATIONSHIPS REL

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')

Line 215: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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')
215: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
216: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
217: AND REL.DIRECTIONAL_FLAG = 'F'
218: AND REL.STATUS = 'A'
219: AND PARTY.STATUS = 'A'

Line 216: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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')
215: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
216: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
217: AND REL.DIRECTIONAL_FLAG = 'F'
218: AND REL.STATUS = 'A'
219: AND PARTY.STATUS = 'A'
220: AND PARTY2.STATUS = 'A'

Line 229: FROM HZ_PARTIES PARTY, HZ_PARTIES PARTY2,

225: AND PARTY3.PARTY_TYPE = 'ORGANIZATION'
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',

Line 230: HZ_PARTIES PARTY3, HZ_RELATIONSHIPS REL

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')

Line 235: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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')
235: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
236: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
237: AND REL.DIRECTIONAL_FLAG = 'F'
238: AND REL.STATUS = 'A'
239: AND PARTY.STATUS = 'A'

Line 236: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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')
235: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
236: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
237: AND REL.DIRECTIONAL_FLAG = 'F'
238: AND REL.STATUS = 'A'
239: AND PARTY.STATUS = 'A'
240: AND PARTY2.STATUS = 'A'

Line 288: FROM HZ_PARTIES PARTY , HZ_RELATIONSHIPS PARTY_REL , HZ_ORG_CONTACTS ORG_CONT ,

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

Line 296: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

292: AND PARTY_REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
293: AND ORG_CONT.ORG_CONTACT_ID = CONT_ROLE.ORG_CONTACT_ID (+)
294: AND CONT_ROLE.PRIMARY_FLAG (+) = 'Y'
295: AND PARTY.PARTY_ID = PARTY_REL.SUBJECT_ID
296: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
297: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
298: AND PARTY_REL.DIRECTIONAL_FLAG = 'F'
299: AND PARTY_REL.STATUS = 'A'
300: AND party.party_id = l_party_id

Line 297: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

293: AND ORG_CONT.ORG_CONTACT_ID = CONT_ROLE.ORG_CONTACT_ID (+)
294: AND CONT_ROLE.PRIMARY_FLAG (+) = 'Y'
295: AND PARTY.PARTY_ID = PARTY_REL.SUBJECT_ID
296: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
297: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
298: AND PARTY_REL.DIRECTIONAL_FLAG = 'F'
299: AND PARTY_REL.STATUS = 'A'
300: AND party.party_id = l_party_id
301: AND ORG_CONT.ORG_CONTACT_ID = l_contact_id

Line 308: FROM HZ_PARTIES PARTY3 , HZ_PARTIES PARTY4 , HZ_PARTIES PARTY5 , HZ_RELATIONSHIPS PARTY_REL ,

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'

Line 323: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

319: AND PARTY4.STATUS = 'A'
320: AND PARTY_REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
321: AND ORG_CONT.ORG_CONTACT_ID = CONT_ROLE.ORG_CONTACT_ID (+)
322: AND CONT_ROLE.PRIMARY_FLAG (+) = 'Y'
323: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
324: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
325: AND PARTY_REL.DIRECTIONAL_FLAG = 'F'
326: AND PARTY_REL.STATUS = 'A'
327: AND party5.party_id = l_party_id

Line 324: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

320: AND PARTY_REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
321: AND ORG_CONT.ORG_CONTACT_ID = CONT_ROLE.ORG_CONTACT_ID (+)
322: AND CONT_ROLE.PRIMARY_FLAG (+) = 'Y'
323: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
324: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
325: AND PARTY_REL.DIRECTIONAL_FLAG = 'F'
326: AND PARTY_REL.STATUS = 'A'
327: AND party5.party_id = l_party_id
328: AND ORG_CONT.ORG_CONTACT_ID = l_contact_id

Line 335: FROM HZ_PARTIES PARTY3 , HZ_PARTIES PARTY4 , HZ_RELATIONSHIPS PARTY_REL ,

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'

Line 348: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

344: AND TRUNC (PARTY_REL.START_DATE) <= TRUNC (SYSDATE)
345: AND TRUNC (NVL (PARTY_REL.END_DATE, SYSDATE)) >= TRUNC (SYSDATE)
346: AND ORG_CONT.ORG_CONTACT_ID = CONT_ROLE.ORG_CONTACT_ID (+)
347: AND CONT_ROLE.PRIMARY_FLAG (+) = 'Y'
348: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
349: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
350: AND PARTY_REL.DIRECTIONAL_FLAG = 'F'
351: AND PARTY_REL.STATUS = 'A'
352: AND party4.party_id = l_party_id

Line 349: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

345: AND TRUNC (NVL (PARTY_REL.END_DATE, SYSDATE)) >= TRUNC (SYSDATE)
346: AND ORG_CONT.ORG_CONTACT_ID = CONT_ROLE.ORG_CONTACT_ID (+)
347: AND CONT_ROLE.PRIMARY_FLAG (+) = 'Y'
348: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
349: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
350: AND PARTY_REL.DIRECTIONAL_FLAG = 'F'
351: AND PARTY_REL.STATUS = 'A'
352: AND party4.party_id = l_party_id
353: AND ORG_CONT.ORG_CONTACT_ID = l_contact_id

Line 386: AND hzr.subject_table_name ='HZ_PARTIES'

382: WHERE hzr.party_id = l_party_id
383: AND hzoc.org_contact_id = l_contact_id
384: AND hzr.directional_flag = 'F'
385: AND hzr.relationship_code = 'EMPLOYEE_OF'
386: AND hzr.subject_table_name ='HZ_PARTIES'
387: AND hzr.object_table_name ='HZ_PARTIES'
388: AND hzr.start_date <= SYSDATE
389: AND (hzr.end_date is null or hzr.end_date > SYSDATE)
390: AND hzr.status = 'A'

Line 387: AND hzr.object_table_name ='HZ_PARTIES'

383: AND hzoc.org_contact_id = l_contact_id
384: AND hzr.directional_flag = 'F'
385: AND hzr.relationship_code = 'EMPLOYEE_OF'
386: AND hzr.subject_table_name ='HZ_PARTIES'
387: AND hzr.object_table_name ='HZ_PARTIES'
388: AND hzr.start_date <= SYSDATE
389: AND (hzr.end_date is null or hzr.end_date > SYSDATE)
390: AND hzr.status = 'A'
391: AND hzoc.PARTY_RELATIONSHIP_ID = hzr.relationship_id;

Line 2583: FROM HZ_PARTIES PARTY, HZ_PARTIES PARTY2,

2579: */
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',

Line 2584: HZ_PARTIES PARTY3, HZ_RELATIONSHIPS REL

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')

Line 2589: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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')
2589: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2590: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2591: AND REL.DIRECTIONAL_FLAG = 'F'
2592: AND REL.STATUS = 'A'
2593: AND PARTY.STATUS = 'A'

Line 2590: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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')
2589: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2590: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2591: AND REL.DIRECTIONAL_FLAG = 'F'
2592: AND REL.STATUS = 'A'
2593: AND PARTY.STATUS = 'A'
2594: AND PARTY2.STATUS = 'A'

Line 2603: FROM HZ_PARTIES PARTY, HZ_PARTIES PARTY2,

2599: AND PARTY3.PARTY_TYPE = 'ORGANIZATION'
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',

Line 2604: HZ_PARTIES PARTY3, HZ_RELATIONSHIPS REL

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')

Line 2609: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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')
2609: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2610: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2611: AND REL.DIRECTIONAL_FLAG = 'F'
2612: AND REL.STATUS = 'A'
2613: AND PARTY.STATUS = 'A'

Line 2610: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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')
2609: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2610: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2611: AND REL.DIRECTIONAL_FLAG = 'F'
2612: AND REL.STATUS = 'A'
2613: AND PARTY.STATUS = 'A'
2614: AND PARTY2.STATUS = 'A'

Line 2655: FROM HZ_PARTIES PARTY , HZ_RELATIONSHIPS PARTY_REL , HZ_ORG_CONTACTS ORG_CONT ,

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

Line 2663: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2659: AND PARTY_REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
2660: AND ORG_CONT.ORG_CONTACT_ID = CONT_ROLE.ORG_CONTACT_ID (+)
2661: AND CONT_ROLE.PRIMARY_FLAG (+) = 'Y'
2662: AND PARTY.PARTY_ID = PARTY_REL.SUBJECT_ID
2663: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2664: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2665: AND PARTY_REL.DIRECTIONAL_FLAG = 'F'
2666: AND PARTY_REL.STATUS = 'A'
2667: AND party.party_id = l_party_id

Line 2664: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2660: AND ORG_CONT.ORG_CONTACT_ID = CONT_ROLE.ORG_CONTACT_ID (+)
2661: AND CONT_ROLE.PRIMARY_FLAG (+) = 'Y'
2662: AND PARTY.PARTY_ID = PARTY_REL.SUBJECT_ID
2663: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2664: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2665: AND PARTY_REL.DIRECTIONAL_FLAG = 'F'
2666: AND PARTY_REL.STATUS = 'A'
2667: AND party.party_id = l_party_id
2668: AND ORG_CONT.ORG_CONTACT_ID = l_contact_id

Line 2675: FROM HZ_PARTIES PARTY3 , HZ_PARTIES PARTY4 , HZ_PARTIES PARTY5 , HZ_RELATIONSHIPS PARTY_REL ,

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'

Line 2690: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2686: AND PARTY4.STATUS = 'A'
2687: AND PARTY_REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
2688: AND ORG_CONT.ORG_CONTACT_ID = CONT_ROLE.ORG_CONTACT_ID (+)
2689: AND CONT_ROLE.PRIMARY_FLAG (+) = 'Y'
2690: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2691: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2692: AND PARTY_REL.DIRECTIONAL_FLAG = 'F'
2693: AND PARTY_REL.STATUS = 'A'
2694: AND party5.party_id = l_party_id

Line 2691: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2687: AND PARTY_REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
2688: AND ORG_CONT.ORG_CONTACT_ID = CONT_ROLE.ORG_CONTACT_ID (+)
2689: AND CONT_ROLE.PRIMARY_FLAG (+) = 'Y'
2690: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2691: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2692: AND PARTY_REL.DIRECTIONAL_FLAG = 'F'
2693: AND PARTY_REL.STATUS = 'A'
2694: AND party5.party_id = l_party_id
2695: AND ORG_CONT.ORG_CONTACT_ID = l_contact_id

Line 2702: FROM HZ_PARTIES PARTY3 , HZ_PARTIES PARTY4 , HZ_RELATIONSHIPS PARTY_REL ,

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'

Line 2715: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2711: AND TRUNC (PARTY_REL.START_DATE) <= TRUNC (SYSDATE)
2712: AND TRUNC (NVL (PARTY_REL.END_DATE, SYSDATE)) >= TRUNC (SYSDATE)
2713: AND ORG_CONT.ORG_CONTACT_ID = CONT_ROLE.ORG_CONTACT_ID (+)
2714: AND CONT_ROLE.PRIMARY_FLAG (+) = 'Y'
2715: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2716: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2717: AND PARTY_REL.DIRECTIONAL_FLAG = 'F'
2718: AND PARTY_REL.STATUS = 'A'
2719: AND party4.party_id = l_party_id

Line 2716: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2712: AND TRUNC (NVL (PARTY_REL.END_DATE, SYSDATE)) >= TRUNC (SYSDATE)
2713: AND ORG_CONT.ORG_CONTACT_ID = CONT_ROLE.ORG_CONTACT_ID (+)
2714: AND CONT_ROLE.PRIMARY_FLAG (+) = 'Y'
2715: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2716: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2717: AND PARTY_REL.DIRECTIONAL_FLAG = 'F'
2718: AND PARTY_REL.STATUS = 'A'
2719: AND party4.party_id = l_party_id
2720: AND ORG_CONT.ORG_CONTACT_ID = l_contact_id

Line 2750: AND hzr.subject_table_name ='HZ_PARTIES'

2746: WHERE hzr.party_id = l_party_id
2747: AND hzoc.org_contact_id = l_contact_id
2748: AND hzr.directional_flag = 'F'
2749: AND hzr.relationship_code = 'EMPLOYEE_OF'
2750: AND hzr.subject_table_name ='HZ_PARTIES'
2751: AND hzr.object_table_name ='HZ_PARTIES'
2752: AND hzr.start_date <= SYSDATE
2753: AND (hzr.end_date is null or hzr.end_date > SYSDATE)
2754: AND hzr.status = 'A'

Line 2751: AND hzr.object_table_name ='HZ_PARTIES'

2747: AND hzoc.org_contact_id = l_contact_id
2748: AND hzr.directional_flag = 'F'
2749: AND hzr.relationship_code = 'EMPLOYEE_OF'
2750: AND hzr.subject_table_name ='HZ_PARTIES'
2751: AND hzr.object_table_name ='HZ_PARTIES'
2752: AND hzr.start_date <= SYSDATE
2753: AND (hzr.end_date is null or hzr.end_date > SYSDATE)
2754: AND hzr.status = 'A'
2755: AND hzoc.PARTY_RELATIONSHIP_ID = hzr.relationship_id;