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.ARP_PAY_REL_CUST_PKG dependencies on HZ_RELATIONSHIP_TYPES

Line 54: ,hz_relationship_types rt

50: a UNION clause for that type in the dynamic sql. */
51: cursor c_rel_grp IS
52: SELECT distinct ca.class_code class
53: FROM hz_code_assignments ca
54: ,hz_relationship_types rt
55: WHERE ca.class_category = 'RELATIONSHIP_TYPE_GROUP'
56: AND ca.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
57: AND ca.status = 'A'
58: AND ca.owner_table_id = rt.relationship_type_id

Line 56: AND ca.owner_table_name = 'HZ_RELATIONSHIP_TYPES'

52: SELECT distinct ca.class_code class
53: FROM hz_code_assignments ca
54: ,hz_relationship_types rt
55: WHERE ca.class_category = 'RELATIONSHIP_TYPE_GROUP'
56: AND ca.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
57: AND ca.status = 'A'
58: AND ca.owner_table_id = rt.relationship_type_id
59: AND rt.object_type = 'ORGANIZATION'
60: AND rt.subject_type = 'ORGANIZATION'

Line 169: ' ,hz_relationship_types rt ' || CRLF ||

165: 'AND hn.child_object_type = ''ORGANIZATION''' || CRLF ||
166: 'AND EXISTS ' || CRLF ||
167: ' (SELECT /*+ NO_UNNEST PUSH_SUBQ */ 1' || CRLF ||
168: ' FROM hz_code_assignments ca' || CRLF ||
169: ' ,hz_relationship_types rt ' || CRLF ||
170: ' WHERE ca.class_category = ''RELATIONSHIP_TYPE_GROUP''' || CRLF ||
171: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||
172: ' AND ca.class_code = ''PARTY_REL_GRP_AR_PAY_ANY'''|| CRLF ||
173: ' AND ca.status = ''A'''|| CRLF ||

Line 171: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||

167: ' (SELECT /*+ NO_UNNEST PUSH_SUBQ */ 1' || CRLF ||
168: ' FROM hz_code_assignments ca' || CRLF ||
169: ' ,hz_relationship_types rt ' || CRLF ||
170: ' WHERE ca.class_category = ''RELATIONSHIP_TYPE_GROUP''' || CRLF ||
171: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||
172: ' AND ca.class_code = ''PARTY_REL_GRP_AR_PAY_ANY'''|| CRLF ||
173: ' AND ca.status = ''A'''|| CRLF ||
174: ' AND ca.owner_table_id = rt.relationship_type_id' || CRLF ||
175: ' AND hn.hierarchy_type = rt.relationship_type' || CRLF ||

Line 207: ' ,hz_relationship_types rt ' || CRLF ||

203: 'AND hn.child_object_type = ''ORGANIZATION''' || CRLF ||
204: 'AND EXISTS ' || CRLF ||
205: ' (SELECT /*+ NO_UNNEST PUSH_SUBQ */ 1' || CRLF ||
206: ' FROM hz_code_assignments ca' || CRLF ||
207: ' ,hz_relationship_types rt ' || CRLF ||
208: ' WHERE ca.class_category = ''RELATIONSHIP_TYPE_GROUP''' || CRLF ||
209: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||
210: ' AND ca.class_code = ''PARTY_REL_GRP_AR_PAY_TOP_DOWN'''|| CRLF ||
211: ' AND ca.status = ''A'''|| CRLF ||

Line 209: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||

205: ' (SELECT /*+ NO_UNNEST PUSH_SUBQ */ 1' || CRLF ||
206: ' FROM hz_code_assignments ca' || CRLF ||
207: ' ,hz_relationship_types rt ' || CRLF ||
208: ' WHERE ca.class_category = ''RELATIONSHIP_TYPE_GROUP''' || CRLF ||
209: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||
210: ' AND ca.class_code = ''PARTY_REL_GRP_AR_PAY_TOP_DOWN'''|| CRLF ||
211: ' AND ca.status = ''A'''|| CRLF ||
212: ' AND ca.owner_table_id = rt.relationship_type_id' || CRLF ||
213: ' AND hn.hierarchy_type = rt.relationship_type' || CRLF ||

Line 293: ,hz_relationship_types rt

289: a UNION clause for that type in the dynamic sql. */
290: cursor c_rel_grp IS
291: SELECT distinct ca.class_code class
292: FROM hz_code_assignments ca
293: ,hz_relationship_types rt
294: WHERE ca.class_category = 'RELATIONSHIP_TYPE_GROUP'
295: AND ca.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
296: AND ca.status = 'A'
297: AND ca.owner_table_id = rt.relationship_type_id

Line 295: AND ca.owner_table_name = 'HZ_RELATIONSHIP_TYPES'

291: SELECT distinct ca.class_code class
292: FROM hz_code_assignments ca
293: ,hz_relationship_types rt
294: WHERE ca.class_category = 'RELATIONSHIP_TYPE_GROUP'
295: AND ca.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
296: AND ca.status = 'A'
297: AND ca.owner_table_id = rt.relationship_type_id
298: AND rt.object_type = 'ORGANIZATION'
299: AND rt.subject_type = 'ORGANIZATION'

Line 413: ' ,hz_relationship_types rt ' || CRLF ||

409: 'AND hn.child_object_type = ''ORGANIZATION''' || CRLF ||
410: 'AND EXISTS ' || CRLF ||
411: ' (SELECT /*+ NO_UNNEST PUSH_SUBQ */ 1' || CRLF ||
412: ' FROM hz_code_assignments ca' || CRLF ||
413: ' ,hz_relationship_types rt ' || CRLF ||
414: ' WHERE ca.class_category = ''RELATIONSHIP_TYPE_GROUP''' || CRLF ||
415: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||
416: ' AND ca.class_code = ''PARTY_REL_GRP_AR_PAY_ANY'''|| CRLF ||
417: ' AND ca.status = ''A'''|| CRLF ||

Line 415: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||

411: ' (SELECT /*+ NO_UNNEST PUSH_SUBQ */ 1' || CRLF ||
412: ' FROM hz_code_assignments ca' || CRLF ||
413: ' ,hz_relationship_types rt ' || CRLF ||
414: ' WHERE ca.class_category = ''RELATIONSHIP_TYPE_GROUP''' || CRLF ||
415: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||
416: ' AND ca.class_code = ''PARTY_REL_GRP_AR_PAY_ANY'''|| CRLF ||
417: ' AND ca.status = ''A'''|| CRLF ||
418: ' AND ca.owner_table_id = rt.relationship_type_id' || CRLF ||
419: ' AND hn.hierarchy_type = rt.relationship_type' || CRLF ||

Line 450: ' ,hz_relationship_types rt ' || CRLF ||

446: 'AND hn.child_object_type = ''ORGANIZATION''' || CRLF ||
447: 'AND EXISTS ' || CRLF ||
448: ' (SELECT /*+ NO_UNNEST PUSH_SUBQ */ 1' || CRLF ||
449: ' FROM hz_code_assignments ca' || CRLF ||
450: ' ,hz_relationship_types rt ' || CRLF ||
451: ' WHERE ca.class_category = ''RELATIONSHIP_TYPE_GROUP''' || CRLF ||
452: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||
453: ' AND ca.class_code = ''PARTY_REL_GRP_AR_PAY_TOP_DOWN'''|| CRLF ||
454: ' AND ca.status = ''A'''|| CRLF ||

Line 452: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||

448: ' (SELECT /*+ NO_UNNEST PUSH_SUBQ */ 1' || CRLF ||
449: ' FROM hz_code_assignments ca' || CRLF ||
450: ' ,hz_relationship_types rt ' || CRLF ||
451: ' WHERE ca.class_category = ''RELATIONSHIP_TYPE_GROUP''' || CRLF ||
452: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||
453: ' AND ca.class_code = ''PARTY_REL_GRP_AR_PAY_TOP_DOWN'''|| CRLF ||
454: ' AND ca.status = ''A'''|| CRLF ||
455: ' AND ca.owner_table_id = rt.relationship_type_id' || CRLF ||
456: ' AND hn.hierarchy_type = rt.relationship_type' || CRLF ||

Line 537: ,hz_relationship_types rt

533:
534: cursor c_rel_grp IS
535: SELECT distinct ca.class_code class
536: FROM hz_code_assignments ca
537: ,hz_relationship_types rt
538: WHERE ca.class_category = 'RELATIONSHIP_TYPE_GROUP'
539: AND ca.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
540: AND ca.status = 'A'
541: AND ca.owner_table_id = rt.relationship_type_id

Line 539: AND ca.owner_table_name = 'HZ_RELATIONSHIP_TYPES'

535: SELECT distinct ca.class_code class
536: FROM hz_code_assignments ca
537: ,hz_relationship_types rt
538: WHERE ca.class_category = 'RELATIONSHIP_TYPE_GROUP'
539: AND ca.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
540: AND ca.status = 'A'
541: AND ca.owner_table_id = rt.relationship_type_id
542: AND rt.object_type = 'ORGANIZATION'
543: AND rt.subject_type = 'ORGANIZATION'

Line 659: ' ,hz_relationship_types rt ' || CRLF ||

655: 'AND hn.child_object_type = ''ORGANIZATION''' || CRLF ||
656: 'AND EXISTS ' || CRLF ||
657: ' (SELECT /*+ NO_UNNEST PUSH_SUBQ */ 1' || CRLF ||
658: ' FROM hz_code_assignments ca' || CRLF ||
659: ' ,hz_relationship_types rt ' || CRLF ||
660: ' WHERE ca.class_category = ''RELATIONSHIP_TYPE_GROUP''' || CRLF ||
661: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||
662: ' AND ca.class_code = ''PARTY_REL_GRP_AR_PAY_ANY'''|| CRLF ||
663: ' AND ca.status = ''A'''|| CRLF ||

Line 661: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||

657: ' (SELECT /*+ NO_UNNEST PUSH_SUBQ */ 1' || CRLF ||
658: ' FROM hz_code_assignments ca' || CRLF ||
659: ' ,hz_relationship_types rt ' || CRLF ||
660: ' WHERE ca.class_category = ''RELATIONSHIP_TYPE_GROUP''' || CRLF ||
661: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||
662: ' AND ca.class_code = ''PARTY_REL_GRP_AR_PAY_ANY'''|| CRLF ||
663: ' AND ca.status = ''A'''|| CRLF ||
664: ' AND ca.owner_table_id = rt.relationship_type_id' || CRLF ||
665: ' AND hn.hierarchy_type = rt.relationship_type' || CRLF ||

Line 693: ' ,hz_relationship_types rt ' || CRLF ||

689: 'AND hn.child_object_type = ''ORGANIZATION''' || CRLF ||
690: 'AND EXISTS ' || CRLF ||
691: ' (SELECT /*+ NO_UNNEST PUSH_SUBQ */ 1' || CRLF ||
692: ' FROM hz_code_assignments ca' || CRLF ||
693: ' ,hz_relationship_types rt ' || CRLF ||
694: ' WHERE ca.class_category = ''RELATIONSHIP_TYPE_GROUP''' || CRLF ||
695: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||
696: ' AND ca.class_code = ''PARTY_REL_GRP_AR_PAY_TOP_DOWN'''|| CRLF ||
697: ' AND ca.status = ''A'''|| CRLF ||

Line 695: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||

691: ' (SELECT /*+ NO_UNNEST PUSH_SUBQ */ 1' || CRLF ||
692: ' FROM hz_code_assignments ca' || CRLF ||
693: ' ,hz_relationship_types rt ' || CRLF ||
694: ' WHERE ca.class_category = ''RELATIONSHIP_TYPE_GROUP''' || CRLF ||
695: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||
696: ' AND ca.class_code = ''PARTY_REL_GRP_AR_PAY_TOP_DOWN'''|| CRLF ||
697: ' AND ca.status = ''A'''|| CRLF ||
698: ' AND ca.owner_table_id = rt.relationship_type_id' || CRLF ||
699: ' AND hn.hierarchy_type = rt.relationship_type' || CRLF ||