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 1578: FROM hz_relationships r,

1574:
1575: CURSOR l_cust_ctc_csr
1576: IS
1577: SELECT 'x'
1578: FROM hz_relationships r,
1579: hz_parties p3,
1580: hz_parties p2,
1581: hz_org_contacts oc
1582: WHERE p2.party_id = r.subject_id

Line 5756: FROM hz_relationships

5752: l_relation VARCHAR2
5753: )
5754: IS
5755: SELECT DISTINCT relationship_type
5756: FROM hz_relationships
5757: WHERE ( ( object_id = l_new_customer
5758: AND subject_id = l_old_customer
5759: )
5760: OR ( object_id = l_old_customer

Line 6541: FROM hz_relationships a,

6537:
6538: CURSOR check_relation_csr
6539: IS
6540: SELECT DISTINCT a.relationship_type
6541: FROM hz_relationships a,
6542: hz_cust_accounts b1,
6543: hz_cust_accounts b2,
6544: oks_instance_temp c
6545: WHERE ( ( a.object_id = b1.party_id