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

Line 792: ak_region_items_tl arit,

788: ak_excluded_items aei,
789: ak_resp_security_attributes arsa,
790: ak_attributes aa,
791: ak_regions ar,
792: ak_region_items_tl arit,
793: ak_region_items ari
794: WHERE ari.object_attribute_flag = 'Y'
795: AND aoa.attribute_application_id = ari.attribute_application_id
796: AND aoa.attribute_code = ari.attribute_code

Line 793: ak_region_items ari

789: ak_resp_security_attributes arsa,
790: ak_attributes aa,
791: ak_regions ar,
792: ak_region_items_tl arit,
793: ak_region_items ari
794: WHERE ari.object_attribute_flag = 'Y'
795: AND aoa.attribute_application_id = ari.attribute_application_id
796: AND aoa.attribute_code = ari.attribute_code
797: AND aoa.database_object_name = ar.database_object_name

Line 859: ak_region_items_tl arit,

855: aa.data_type data_type
856: FROM ak_excluded_items aei,
857: ak_resp_security_attributes arsa,
858: ak_attributes aa,
859: ak_region_items_tl arit,
860: ak_region_items ari
861: WHERE ari.object_attribute_flag <> 'Y'
862: AND ari.region_code = p_child_region_code
863: AND ari.region_application_id = p_child_region_appl_id

Line 860: ak_region_items ari

856: FROM ak_excluded_items aei,
857: ak_resp_security_attributes arsa,
858: ak_attributes aa,
859: ak_region_items_tl arit,
860: ak_region_items ari
861: WHERE ari.object_attribute_flag <> 'Y'
862: AND ari.region_code = p_child_region_code
863: AND ari.region_application_id = p_child_region_appl_id
864: AND arit.region_code = ari.region_code

Line 2532: ak_region_items_tl arit,

2528: ak_excluded_items aei,
2529: ak_resp_security_attributes arsa,
2530: ak_attributes aa,
2531: ak_regions ar,
2532: ak_region_items_tl arit,
2533: ak_region_items ari
2534: WHERE ari.object_attribute_flag = 'Y'
2535: AND aoa.attribute_application_id = ari.attribute_application_id
2536: AND aoa.attribute_code = ari.attribute_code

Line 2533: ak_region_items ari

2529: ak_resp_security_attributes arsa,
2530: ak_attributes aa,
2531: ak_regions ar,
2532: ak_region_items_tl arit,
2533: ak_region_items ari
2534: WHERE ari.object_attribute_flag = 'Y'
2535: AND aoa.attribute_application_id = ari.attribute_application_id
2536: AND aoa.attribute_code = ari.attribute_code
2537: AND aoa.database_object_name = ar.database_object_name

Line 2601: ak_region_items_tl arit,

2597: aa.data_type data_type
2598: FROM ak_excluded_items aei,
2599: ak_resp_security_attributes arsa,
2600: ak_attributes aa,
2601: ak_region_items_tl arit,
2602: ak_region_items ari
2603: WHERE ari.object_attribute_flag <> 'Y'
2604: AND ari.region_code = p_child_region_code
2605: AND ari.region_application_id = p_child_region_appl_id

Line 2602: ak_region_items ari

2598: FROM ak_excluded_items aei,
2599: ak_resp_security_attributes arsa,
2600: ak_attributes aa,
2601: ak_region_items_tl arit,
2602: ak_region_items ari
2603: WHERE ari.object_attribute_flag <> 'Y'
2604: AND ari.region_code = p_child_region_code
2605: AND ari.region_application_id = p_child_region_appl_id
2606: AND ari.node_display_flag =