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 2364: FROM HZ_PARTIES PARTY, HZ_PARTIES PARTY2,

2360: */
2361: CURSOR c_validate_partner(l_party_id IN NUMBER)
2362: IS
2363: SELECT 'Y'
2364: FROM HZ_PARTIES PARTY, HZ_PARTIES PARTY2,
2365: HZ_PARTIES PARTY3, HZ_RELATIONSHIPS REL
2366: WHERE (PARTY.PARTY_TYPE = 'ORGANIZATION' AND PARTY.PARTY_ID = REL.SUBJECT_ID)
2367: AND REL.RELATIONSHIP_CODE IN ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF',
2368: 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER',

Line 2365: HZ_PARTIES PARTY3, HZ_RELATIONSHIPS REL

2361: CURSOR c_validate_partner(l_party_id IN NUMBER)
2362: IS
2363: SELECT 'Y'
2364: FROM HZ_PARTIES PARTY, HZ_PARTIES PARTY2,
2365: HZ_PARTIES PARTY3, HZ_RELATIONSHIPS REL
2366: WHERE (PARTY.PARTY_TYPE = 'ORGANIZATION' AND PARTY.PARTY_ID = REL.SUBJECT_ID)
2367: AND REL.RELATIONSHIP_CODE IN ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF',
2368: 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER',
2369: 'CUSTOMER_INDIRECTLY_MANAGED_BY')

Line 2370: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2366: WHERE (PARTY.PARTY_TYPE = 'ORGANIZATION' AND PARTY.PARTY_ID = REL.SUBJECT_ID)
2367: AND REL.RELATIONSHIP_CODE IN ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF',
2368: 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER',
2369: 'CUSTOMER_INDIRECTLY_MANAGED_BY')
2370: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2371: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2372: AND REL.DIRECTIONAL_FLAG = 'F'
2373: AND REL.STATUS = 'A'
2374: AND PARTY.STATUS = 'A'

Line 2371: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2367: AND REL.RELATIONSHIP_CODE IN ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF',
2368: 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER',
2369: 'CUSTOMER_INDIRECTLY_MANAGED_BY')
2370: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2371: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2372: AND REL.DIRECTIONAL_FLAG = 'F'
2373: AND REL.STATUS = 'A'
2374: AND PARTY.STATUS = 'A'
2375: AND PARTY2.STATUS = 'A'

Line 2384: FROM HZ_PARTIES PARTY, HZ_PARTIES PARTY2,

2380: AND PARTY3.PARTY_TYPE = 'ORGANIZATION'
2381: AND party.party_id = l_party_id
2382: UNION ALL
2383: SELECT 'Y'
2384: FROM HZ_PARTIES PARTY, HZ_PARTIES PARTY2,
2385: HZ_PARTIES PARTY3, HZ_RELATIONSHIPS REL
2386: WHERE (PARTY.PARTY_TYPE = 'PARTY_RELATIONSHIP' AND PARTY.PARTY_ID = REL.PARTY_ID )
2387: AND REL.RELATIONSHIP_CODE IN ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF',
2388: 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER',

Line 2385: HZ_PARTIES PARTY3, HZ_RELATIONSHIPS REL

2381: AND party.party_id = l_party_id
2382: UNION ALL
2383: SELECT 'Y'
2384: FROM HZ_PARTIES PARTY, HZ_PARTIES PARTY2,
2385: HZ_PARTIES PARTY3, HZ_RELATIONSHIPS REL
2386: WHERE (PARTY.PARTY_TYPE = 'PARTY_RELATIONSHIP' AND PARTY.PARTY_ID = REL.PARTY_ID )
2387: AND REL.RELATIONSHIP_CODE IN ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF',
2388: 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER',
2389: 'CUSTOMER_INDIRECTLY_MANAGED_BY')

Line 2390: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2386: WHERE (PARTY.PARTY_TYPE = 'PARTY_RELATIONSHIP' AND PARTY.PARTY_ID = REL.PARTY_ID )
2387: AND REL.RELATIONSHIP_CODE IN ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF',
2388: 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER',
2389: 'CUSTOMER_INDIRECTLY_MANAGED_BY')
2390: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2391: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2392: AND REL.DIRECTIONAL_FLAG = 'F'
2393: AND REL.STATUS = 'A'
2394: AND PARTY.STATUS = 'A'

Line 2391: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2387: AND REL.RELATIONSHIP_CODE IN ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF',
2388: 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER',
2389: 'CUSTOMER_INDIRECTLY_MANAGED_BY')
2390: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2391: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2392: AND REL.DIRECTIONAL_FLAG = 'F'
2393: AND REL.STATUS = 'A'
2394: AND PARTY.STATUS = 'A'
2395: AND PARTY2.STATUS = 'A'

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

2432: IS
2433: SELECT 'Y'
2434: -- SELECT PARTY.PARTY_ID PARTY_ID , ORG_CONT.PARTY_SITE_ID PARTY_SITE_ID , ORG_CONT.ORG_CONTACT_ID CONTACT_ID ,
2435: -- ORG_CONT.CONTACT_NUMBER CONTACT_NUMBER , PARTY.PARTY_NAME CONTACT_NAME , CONT_ROLE.PRIMARY_FLAG PRIMARY_FLAG
2436: FROM HZ_PARTIES PARTY , HZ_RELATIONSHIPS PARTY_REL , HZ_ORG_CONTACTS ORG_CONT ,
2437: HZ_ORG_CONTACT_ROLES CONT_ROLE
2438: WHERE PARTY.STATUS = 'A'
2439: AND PARTY.PARTY_TYPE = 'PERSON'
2440: AND PARTY_REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID

Line 2444: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2440: AND PARTY_REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
2441: AND ORG_CONT.ORG_CONTACT_ID = CONT_ROLE.ORG_CONTACT_ID (+)
2442: AND CONT_ROLE.PRIMARY_FLAG (+) = 'Y'
2443: AND PARTY.PARTY_ID = PARTY_REL.SUBJECT_ID
2444: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2445: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2446: AND PARTY_REL.DIRECTIONAL_FLAG = 'F'
2447: AND PARTY_REL.STATUS = 'A'
2448: AND party.party_id = l_party_id

Line 2445: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2441: AND ORG_CONT.ORG_CONTACT_ID = CONT_ROLE.ORG_CONTACT_ID (+)
2442: AND CONT_ROLE.PRIMARY_FLAG (+) = 'Y'
2443: AND PARTY.PARTY_ID = PARTY_REL.SUBJECT_ID
2444: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2445: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2446: AND PARTY_REL.DIRECTIONAL_FLAG = 'F'
2447: AND PARTY_REL.STATUS = 'A'
2448: AND party.party_id = l_party_id
2449: AND ORG_CONT.ORG_CONTACT_ID = l_contact_id

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

2452: SELECT 'Y'
2453: -- SELECT PARTY5.PARTY_ID PARTY_ID , ORG_CONT.PARTY_SITE_ID PARTY_SITE_ID ,
2454: -- ORG_CONT.ORG_CONTACT_ID CONTACT_ID , ORG_CONT.CONTACT_NUMBER CONTACT_NUMBER ,
2455: -- PARTY5.PARTY_NAME CONTACT_NAME , CONT_ROLE.PRIMARY_FLAG PRIMARY_FLAG
2456: FROM HZ_PARTIES PARTY3 , HZ_PARTIES PARTY4 , HZ_PARTIES PARTY5 , HZ_RELATIONSHIPS PARTY_REL ,
2457: HZ_ORG_CONTACTS ORG_CONT , HZ_ORG_CONTACT_ROLES CONT_ROLE
2458: WHERE PARTY_REL.PARTY_ID = PARTY5.PARTY_ID
2459: AND PARTY5.PARTY_TYPE = 'PARTY_RELATIONSHIP'
2460: AND PARTY5.STATUS = 'A'

Line 2471: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2467: AND PARTY4.STATUS = 'A'
2468: AND PARTY_REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
2469: AND ORG_CONT.ORG_CONTACT_ID = CONT_ROLE.ORG_CONTACT_ID (+)
2470: AND CONT_ROLE.PRIMARY_FLAG (+) = 'Y'
2471: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2472: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2473: AND PARTY_REL.DIRECTIONAL_FLAG = 'F'
2474: AND PARTY_REL.STATUS = 'A'
2475: AND party5.party_id = l_party_id

Line 2472: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2468: AND PARTY_REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
2469: AND ORG_CONT.ORG_CONTACT_ID = CONT_ROLE.ORG_CONTACT_ID (+)
2470: AND CONT_ROLE.PRIMARY_FLAG (+) = 'Y'
2471: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2472: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2473: AND PARTY_REL.DIRECTIONAL_FLAG = 'F'
2474: AND PARTY_REL.STATUS = 'A'
2475: AND party5.party_id = l_party_id
2476: AND ORG_CONT.ORG_CONTACT_ID = l_contact_id

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

2479: SELECT 'Y'
2480: -- SELECT PARTY4.PARTY_ID PARTY_ID , ORG_CONT.PARTY_SITE_ID PARTY_SITE_ID ,
2481: -- ORG_CONT.ORG_CONTACT_ID CONTACT_ID , ORG_CONT.CONTACT_NUMBER CONTACT_NUMBER ,
2482: -- PARTY3.PARTY_NAME CONTACT_NAME , CONT_ROLE.PRIMARY_FLAG PRIMARY_FLAG
2483: FROM HZ_PARTIES PARTY3 , HZ_PARTIES PARTY4 , HZ_RELATIONSHIPS PARTY_REL ,
2484: HZ_ORG_CONTACTS ORG_CONT , HZ_ORG_CONTACT_ROLES CONT_ROLE
2485: WHERE PARTY_REL.SUBJECT_ID = PARTY3.PARTY_ID
2486: AND PARTY3.PARTY_TYPE = 'PERSON'
2487: AND PARTY3.STATUS = 'A'

Line 2496: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2492: AND TRUNC (PARTY_REL.START_DATE) <= TRUNC (SYSDATE)
2493: AND TRUNC (NVL (PARTY_REL.END_DATE, SYSDATE)) >= TRUNC (SYSDATE)
2494: AND ORG_CONT.ORG_CONTACT_ID = CONT_ROLE.ORG_CONTACT_ID (+)
2495: AND CONT_ROLE.PRIMARY_FLAG (+) = 'Y'
2496: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2497: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2498: AND PARTY_REL.DIRECTIONAL_FLAG = 'F'
2499: AND PARTY_REL.STATUS = 'A'
2500: AND party4.party_id = l_party_id

Line 2497: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2493: AND TRUNC (NVL (PARTY_REL.END_DATE, SYSDATE)) >= TRUNC (SYSDATE)
2494: AND ORG_CONT.ORG_CONTACT_ID = CONT_ROLE.ORG_CONTACT_ID (+)
2495: AND CONT_ROLE.PRIMARY_FLAG (+) = 'Y'
2496: AND PARTY_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2497: AND PARTY_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2498: AND PARTY_REL.DIRECTIONAL_FLAG = 'F'
2499: AND PARTY_REL.STATUS = 'A'
2500: AND party4.party_id = l_party_id
2501: AND ORG_CONT.ORG_CONTACT_ID = l_contact_id

Line 2531: AND hzr.subject_table_name ='HZ_PARTIES'

2527: WHERE hzr.party_id = l_party_id
2528: AND hzoc.org_contact_id = l_contact_id
2529: AND hzr.directional_flag = 'F'
2530: AND hzr.relationship_code = 'EMPLOYEE_OF'
2531: AND hzr.subject_table_name ='HZ_PARTIES'
2532: AND hzr.object_table_name ='HZ_PARTIES'
2533: AND hzr.start_date <= SYSDATE
2534: AND (hzr.end_date is null or hzr.end_date > SYSDATE)
2535: AND hzr.status = 'A'

Line 2532: AND hzr.object_table_name ='HZ_PARTIES'

2528: AND hzoc.org_contact_id = l_contact_id
2529: AND hzr.directional_flag = 'F'
2530: AND hzr.relationship_code = 'EMPLOYEE_OF'
2531: AND hzr.subject_table_name ='HZ_PARTIES'
2532: AND hzr.object_table_name ='HZ_PARTIES'
2533: AND hzr.start_date <= SYSDATE
2534: AND (hzr.end_date is null or hzr.end_date > SYSDATE)
2535: AND hzr.status = 'A'
2536: AND hzoc.PARTY_RELATIONSHIP_ID = hzr.relationship_id;