DBA Data[Home] [Help]

APPS.ICX_UTIL dependencies on AK_OBJECT_ATTRIBUTES

Line 437: AK_OBJECT_ATTRIBUTES d

433: select d.COLUMN_NAME
434: from AK_ATTRIBUTES a,
435: AK_REGION_ITEMS_VL b,
436: AK_REGIONS c,
437: AK_OBJECT_ATTRIBUTES d
438: where b.REGION_APPLICATION_ID = p_LOV_region_id
439: and b.REGION_CODE = p_LOV_region
440: and b.NODE_QUERY_FLAG = 'Y'
441: and b.ATTRIBUTE_APPLICATION_ID = d.ATTRIBUTE_APPLICATION_ID

Line 771: AK_OBJECT_ATTRIBUTES d

767: substr(a.DATA_TYPE,1,1)
768: from AK_ATTRIBUTES a,
769: AK_REGION_ITEMS_VL b,
770: AK_REGIONS c,
771: AK_OBJECT_ATTRIBUTES d
772: where b.REGION_APPLICATION_ID = p_LOV_region_id
773: and b.REGION_CODE = p_LOV_region
774: and b.NODE_QUERY_FLAG = 'Y'
775: and b.ATTRIBUTE_APPLICATION_ID = d.ATTRIBUTE_APPLICATION_ID

Line 986: AK_OBJECT_ATTRIBUTES d

982: into l_query_attr_cnt
983: from AK_ATTRIBUTES a,
984: AK_REGION_ITEMS_VL b,
985: AK_REGIONS c,
986: AK_OBJECT_ATTRIBUTES d
987: where b.REGION_APPLICATION_ID = p_LOV_region_id
988: and b.REGION_CODE = p_LOV_region
989: and b.NODE_QUERY_FLAG = 'Y'
990: and b.ATTRIBUTE_APPLICATION_ID = d.ATTRIBUTE_APPLICATION_ID

Line 1286: AK_OBJECT_ATTRIBUTES d

1282: select d.COLUMN_NAME
1283: from AK_ATTRIBUTES a,
1284: AK_REGION_ITEMS_VL b,
1285: AK_REGIONS c,
1286: AK_OBJECT_ATTRIBUTES d
1287: where b.REGION_APPLICATION_ID = p_LOV_region_id
1288: and b.REGION_CODE = p_LOV_region
1289: and b.ATTRIBUTE_APPLICATION_ID = d.ATTRIBUTE_APPLICATION_ID
1290: and b.ATTRIBUTE_CODE = d.ATTRIBUTE_CODE

Line 1495: AK_OBJECT_ATTRIBUTES d

1491: into temp_a_1
1492: from AK_ATTRIBUTES a,
1493: AK_REGION_ITEMS_VL b,
1494: AK_REGIONS c,
1495: AK_OBJECT_ATTRIBUTES d
1496: where b.REGION_APPLICATION_ID = p_LOV_region_id
1497: and b.REGION_CODE = p_LOV_region
1498: and b.NODE_QUERY_FLAG = 'Y'
1499: and b.ATTRIBUTE_APPLICATION_ID = d.ATTRIBUTE_APPLICATION_ID