APPS.OKL_UTIL dependencies on HZ_LOCATIONS

Line 88: select HZ_LOCATIONS.country

84: AND instance_LS.LTY_CODE = 'FREE_FORM2'
85: AND instance_LS.ID = instance_CLE.LSE_ID
86: AND instance_CLE.cle_id = p_k_financial_line
87: union
88: select HZ_LOCATIONS.country
89: from
90: OKC_K_LINES_B instance_CLE,
91: OKC_LINE_STYLES_B instance_LS,
92: OKC_K_LINES_B IB_CLE,

Line 96: HZ_LOCATIONS HZ_LOCATIONS

92: OKC_K_LINES_B IB_CLE,
93: OKC_LINE_STYLES_B IB_LS,
94: CSI_ITEM_INSTANCES INSTALL_BASE,
95: OKC_K_ITEMS INSTANCE_ITEM,
96: HZ_LOCATIONS HZ_LOCATIONS
97: WHERE
98: HZ_LOCATIONS.LOCATION_ID = INSTALL_BASE.INSTALL_LOCATION_ID
99: AND INSTALL_BASE.INSTALL_LOCATION_TYPE_CODE = 'HZ_LOCATIONS' -- Fix for Canon bug 3551010
100: AND INSTALL_BASE.instance_id = INSTANCE_ITEM.object1_id1 AND --Fix for Bug 3837619

Line 98: HZ_LOCATIONS.LOCATION_ID = INSTALL_BASE.INSTALL_LOCATION_ID

94: CSI_ITEM_INSTANCES INSTALL_BASE,
95: OKC_K_ITEMS INSTANCE_ITEM,
96: HZ_LOCATIONS HZ_LOCATIONS
97: WHERE
98: HZ_LOCATIONS.LOCATION_ID = INSTALL_BASE.INSTALL_LOCATION_ID
99: AND INSTALL_BASE.INSTALL_LOCATION_TYPE_CODE = 'HZ_LOCATIONS' -- Fix for Canon bug 3551010
100: AND INSTALL_BASE.instance_id = INSTANCE_ITEM.object1_id1 AND --Fix for Bug 3837619
101: '#' = INSTANCE_ITEM.object1_id2 AND
102: INSTANCE_ITEM.CLE_ID = IB_CLE.ID

Line 99: AND INSTALL_BASE.INSTALL_LOCATION_TYPE_CODE = 'HZ_LOCATIONS' -- Fix for Canon bug 3551010

95: OKC_K_ITEMS INSTANCE_ITEM,
96: HZ_LOCATIONS HZ_LOCATIONS
97: WHERE
98: HZ_LOCATIONS.LOCATION_ID = INSTALL_BASE.INSTALL_LOCATION_ID
99: AND INSTALL_BASE.INSTALL_LOCATION_TYPE_CODE = 'HZ_LOCATIONS' -- Fix for Canon bug 3551010
100: AND INSTALL_BASE.instance_id = INSTANCE_ITEM.object1_id1 AND --Fix for Bug 3837619
101: '#' = INSTANCE_ITEM.object1_id2 AND
102: INSTANCE_ITEM.CLE_ID = IB_CLE.ID
103: and IB_LS.LTY_CODE = 'INST_ITEM'