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.OKL_UTIL dependencies on HZ_PARTY_SITES

Line 71: HZ_PARTY_SITES PARTY_SITES,

67: OKC_K_LINES_B IB_CLE,
68: OKC_LINE_STYLES_B IB_LS,
69: CSI_ITEM_INSTANCES INSTALL_BASE,
70: OKC_K_ITEMS INSTANCE_ITEM,
71: HZ_PARTY_SITES PARTY_SITES,
72: OKX_PARTY_SITE_USES_V PARTY_SITES_USES
73: WHERE
74: PARTY_SITES_USES.site_use_type = 'INSTALL_AT'
75: AND PARTY_SITES_USES.PARTY_SITE_ID = PARTY_SITES.PARTY_SITE_ID

Line 77: AND INSTALL_BASE.INSTALL_LOCATION_TYPE_CODE = 'HZ_PARTY_SITES' -- Fix for Canon bug 3551010

73: WHERE
74: PARTY_SITES_USES.site_use_type = 'INSTALL_AT'
75: AND PARTY_SITES_USES.PARTY_SITE_ID = PARTY_SITES.PARTY_SITE_ID
76: AND PARTY_SITES.PARTY_SITE_ID = INSTALL_BASE.INSTALL_LOCATION_ID
77: AND INSTALL_BASE.INSTALL_LOCATION_TYPE_CODE = 'HZ_PARTY_SITES' -- Fix for Canon bug 3551010
78: AND INSTALL_BASE.instance_id = INSTANCE_ITEM.object1_id1 AND --Fix for 3837619
79: '#' = INSTANCE_ITEM.object1_id2 AND
80: INSTANCE_ITEM.CLE_ID = IB_CLE.ID
81: and IB_LS.LTY_CODE = 'INST_ITEM'