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.OKS_MASS_UPDATE_PVT dependencies on HZ_RELATIONSHIPS

Line 43: --| HZ_RELATIONSHIPS | X | | | | | |

39: --| DUAL | X | | | | | |
40: --+---------------------------------+---+---+---+---+---+----------------------+
41: --| OKC_K_GROUPS_B | X | | | | | |
42: --+---------------------------------+---+---+---+---+---+----------------------+
43: --| HZ_RELATIONSHIPS | X | | | | | |
44: --+---------------------------------+---+---+---+---+---+----------------------+
45: --| HZ_ORG_CONTACTS | X | | | | | |
46: --+---------------------------------+---+---+---+---+---+----------------------+
47: --| HZ_CUST_SITE_USES_ALL | X | | | | | |

Line 1574: FROM hz_relationships r,

1570:
1571: CURSOR l_cust_ctc_csr
1572: IS
1573: SELECT 'x'
1574: FROM hz_relationships r,
1575: hz_parties p3,
1576: hz_parties p2,
1577: hz_org_contacts oc
1578: WHERE p2.party_id = r.subject_id

Line 5739: FROM hz_relationships

5735: l_relation VARCHAR2
5736: )
5737: IS
5738: SELECT DISTINCT relationship_type
5739: FROM hz_relationships
5740: WHERE ( ( object_id = l_new_customer
5741: AND subject_id = l_old_customer
5742: )
5743: OR ( object_id = l_old_customer

Line 6524: FROM hz_relationships a,

6520:
6521: CURSOR check_relation_csr
6522: IS
6523: SELECT DISTINCT a.relationship_type
6524: FROM hz_relationships a,
6525: hz_cust_accounts b1,
6526: hz_cust_accounts b2,
6527: oks_instance_temp c
6528: WHERE ( ( a.object_id = b1.party_id