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.ICX_ON_CABO dependencies on AK_REGION_ITEMS

Line 184: TYPE T_ATTRIBUTE_LABEL_LONG IS TABLE OF AK_REGION_ITEMS_VL.ATTRIBUTE_LABEL_LONG%TYPE;

180: --begin additions for bulk fetch change from 1574527 mputman
181: --collections for bulk fetch
182: TYPE T_COLUMN_NAME IS TABLE OF AK_OBJECT_ATTRIBUTES.COLUMN_NAME%TYPE;
183: TYPE T_DATA_TYPE IS TABLE OF AK_ATTRIBUTES.DATA_TYPE%TYPE;
184: TYPE T_ATTRIBUTE_LABEL_LONG IS TABLE OF AK_REGION_ITEMS_VL.ATTRIBUTE_LABEL_LONG%TYPE;
185: TYPE T_ICX_CUSTOM_CALL IS TABLE OF AK_REGION_ITEMS.ICX_CUSTOM_CALL%TYPE;
186:
187: --record defining plsql table to replace cursor in loop
188: TYPE t_attr_rec IS RECORD

Line 185: TYPE T_ICX_CUSTOM_CALL IS TABLE OF AK_REGION_ITEMS.ICX_CUSTOM_CALL%TYPE;

181: --collections for bulk fetch
182: TYPE T_COLUMN_NAME IS TABLE OF AK_OBJECT_ATTRIBUTES.COLUMN_NAME%TYPE;
183: TYPE T_DATA_TYPE IS TABLE OF AK_ATTRIBUTES.DATA_TYPE%TYPE;
184: TYPE T_ATTRIBUTE_LABEL_LONG IS TABLE OF AK_REGION_ITEMS_VL.ATTRIBUTE_LABEL_LONG%TYPE;
185: TYPE T_ICX_CUSTOM_CALL IS TABLE OF AK_REGION_ITEMS.ICX_CUSTOM_CALL%TYPE;
186:
187: --record defining plsql table to replace cursor in loop
188: TYPE t_attr_rec IS RECORD
189: (

Line 192: ATTRIBUTE_LABEL_LONG AK_REGION_ITEMS_VL.ATTRIBUTE_LABEL_LONG%TYPE,

188: TYPE t_attr_rec IS RECORD
189: (
190: COLUMN_NAME AK_OBJECT_ATTRIBUTES.COLUMN_NAME%TYPE,
191: DATA_TYPE AK_ATTRIBUTES.DATA_TYPE%TYPE,
192: ATTRIBUTE_LABEL_LONG AK_REGION_ITEMS_VL.ATTRIBUTE_LABEL_LONG%TYPE,
193: ICX_CUSTOM_CALL AK_REGION_ITEMS.ICX_CUSTOM_CALL%TYPE
194: );
195: --definition of table replacing cursor in loop
196: TYPE t_attr_tab is table of t_attr_rec

Line 193: ICX_CUSTOM_CALL AK_REGION_ITEMS.ICX_CUSTOM_CALL%TYPE

189: (
190: COLUMN_NAME AK_OBJECT_ATTRIBUTES.COLUMN_NAME%TYPE,
191: DATA_TYPE AK_ATTRIBUTES.DATA_TYPE%TYPE,
192: ATTRIBUTE_LABEL_LONG AK_REGION_ITEMS_VL.ATTRIBUTE_LABEL_LONG%TYPE,
193: ICX_CUSTOM_CALL AK_REGION_ITEMS.ICX_CUSTOM_CALL%TYPE
194: );
195: --definition of table replacing cursor in loop
196: TYPE t_attr_tab is table of t_attr_rec
197: index by binary_integer;

Line 211: AK_REGION_ITEMS e,

207: select d.COLUMN_NAME,b.DATA_TYPE,a.ATTRIBUTE_LABEL_LONG,e.ICX_CUSTOM_CALL
208: from AK_ATTRIBUTES b,
209: AK_REGIONS c,
210: AK_OBJECT_ATTRIBUTES d,
211: AK_REGION_ITEMS e,
212: AK_REGION_ITEMS_VL a
213: where a.REGION_APPLICATION_ID = p_region_appl_id
214: and a.REGION_CODE = p_region_code
215: and a.NODE_QUERY_FLAG = 'Y'

Line 212: AK_REGION_ITEMS_VL a

208: from AK_ATTRIBUTES b,
209: AK_REGIONS c,
210: AK_OBJECT_ATTRIBUTES d,
211: AK_REGION_ITEMS e,
212: AK_REGION_ITEMS_VL a
213: where a.REGION_APPLICATION_ID = p_region_appl_id
214: and a.REGION_CODE = p_region_code
215: and a.NODE_QUERY_FLAG = 'Y'
216: and a.REGION_APPLICATION_ID = c.REGION_APPLICATION_ID