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_REQ_ACCT_DIST dependencies on AK_REGIONS

Line 1727: ak_regions c,

1723: cursor get_ak_attributes is
1724: select ltrim(rtrim(a.ATTRIBUTE_CODE)) ATTRIBUTE_NAME
1725: from ak_region_items a,
1726: ak_attributes b,
1727: ak_regions c,
1728: ak_object_attributes d
1729: where a.NODE_DISPLAY_FLAG = 'Y'
1730: and a.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE
1731: and a.ATTRIBUTE_APPLICATION_ID = b.ATTRIBUTE_APPLICATION_ID

Line 1746: ak_regions c,

1742: cursor check_concatenated_segment is
1743: select 1
1744: from ak_region_items a,
1745: ak_attributes b,
1746: ak_regions c,
1747: ak_object_attributes d
1748: where a.NODE_DISPLAY_FLAG = 'Y'
1749: and a.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE
1750: and a.ATTRIBUTE_APPLICATION_ID = b.ATTRIBUTE_APPLICATION_ID

Line 1964: ak_regions c

1960: SELECT ltrim(rtrim(a.ATTRIBUTE_CODE)) ATTRIBUTE_NAME,
1961: a.UPDATE_FLAG UPDATE_FLAG
1962: FROM ak_region_items a,
1963: ak_attributes b,
1964: ak_regions c
1965: WHERE a.NODE_DISPLAY_FLAG = 'Y'
1966: AND a.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE
1967: AND a.ATTRIBUTE_APPLICATION_ID = b.ATTRIBUTE_APPLICATION_ID
1968: AND b.DATA_TYPE = 'VARCHAR2'

Line 1999: ak_regions c,

1995: CURSOR check_concatenated_segment IS
1996: SELECT 1
1997: FROM ak_region_items a,
1998: ak_attributes b,
1999: ak_regions c,
2000: ak_object_attributes d
2001: WHERE a.NODE_DISPLAY_FLAG = 'Y'
2002: AND a.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE
2003: AND a.ATTRIBUTE_APPLICATION_ID = b.ATTRIBUTE_APPLICATION_ID