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_REGIONS

Line 281: ak_regions ar

277: -- Get object's database_object_name and primary key
278: select ao.database_object_name, ao.primary_key_name
279: into root.database_object_name, root.primary_key_name
280: from ak_objects ao,
281: ak_regions ar
282: where ar.region_code = root.region_code
283: and ar.region_application_id = root.region_application_id
284: and ar.database_object_name = ao.database_object_name;
285:

Line 631: ak_regions ar1,

627: decode(afpr2.display_sequence, null, 'N','Y') to_region_disp_flag,
628: decode(afpr2.display_sequence, null, 0 ,afpr2.display_sequence) disp_seq
629: FROM
630: ak_flow_region_relations afrr,
631: ak_regions ar1,
632: ak_regions ar2,
633: ak_flow_page_regions afpr1,
634: ak_flow_page_regions afpr2,
635: ak_objects ao1,

Line 632: ak_regions ar2,

628: decode(afpr2.display_sequence, null, 0 ,afpr2.display_sequence) disp_seq
629: FROM
630: ak_flow_region_relations afrr,
631: ak_regions ar1,
632: ak_regions ar2,
633: ak_flow_page_regions afpr1,
634: ak_flow_page_regions afpr2,
635: ak_objects ao1,
636: ak_objects ao2,

Line 791: ak_regions ar,

787: FROM ak_object_attributes aoa,
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

Line 1923: ak_regions ar,

1919: l_region_defaulting_api_pkg ,
1920: l_region_defaulting_api_proc,
1921: l_display_sequence
1922: FROM ak_flow_page_regions fpr,
1923: ak_regions ar,
1924: ak_regions_tl art,
1925: ak_objects ao
1926: WHERE fpr.flow_application_id = p_region_rec.flow_application_id
1927: AND fpr.flow_code = p_region_rec.flow_code

Line 1924: ak_regions_tl art,

1920: l_region_defaulting_api_proc,
1921: l_display_sequence
1922: FROM ak_flow_page_regions fpr,
1923: ak_regions ar,
1924: ak_regions_tl art,
1925: ak_objects ao
1926: WHERE fpr.flow_application_id = p_region_rec.flow_application_id
1927: AND fpr.flow_code = p_region_rec.flow_code
1928: AND fpr.page_application_id = p_region_rec.page_application_id

Line 1943: -- from AK_REGIONS directly

1939: EXCEPTION
1940: WHEN NO_DATA_FOUND THEN
1941: -- If AK_FLOW_PAGE_REGIONS does not have a record (i.e. this
1942: -- call is for an LOV (i.e. no flow) then get the default information
1943: -- from AK_REGIONS directly
1944: SELECT ar.region_style region_style,
1945: ar.num_columns number_of_format_columns,
1946: art.name region_name,
1947: ao.validation_api_pkg object_validation_api_pkg,

Line 1968: FROM ak_regions ar,

1964: l_region_validation_api_proc,
1965: l_region_defaulting_api_pkg ,
1966: l_region_defaulting_api_proc,
1967: l_display_sequence
1968: FROM ak_regions ar,
1969: ak_regions_tl art,
1970: ak_objects ao
1971: WHERE ar.region_application_id = p_region_rec.region_application_id
1972: AND ar.region_code = p_region_rec.region_code

Line 1969: ak_regions_tl art,

1965: l_region_defaulting_api_pkg ,
1966: l_region_defaulting_api_proc,
1967: l_display_sequence
1968: FROM ak_regions ar,
1969: ak_regions_tl art,
1970: ak_objects ao
1971: WHERE ar.region_application_id = p_region_rec.region_application_id
1972: AND ar.region_code = p_region_rec.region_code
1973: AND art.region_application_id = ar.region_application_id

Line 2531: ak_regions ar,

2527: FROM ak_object_attributes aoa,
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