APPS.AMS_ACTPRODUCT_PVT dependencies on AK_REGION_ITEMS

Line 2255: from AK_REGION_ITEMS_VL

2251: --inanaiah - Bug 5207293 fix - removed "like" as it is an exact match - Ids 17263290/17263381
2252: /*
2253: CURSOR get_prompt IS
2254: SELECT ATTRIBUTE_LABEL_LONG
2255: from AK_REGION_ITEMS_VL
2256: where region_code like 'AMS_COMPETITOR_PRODUCTS'
2257: and attribute_code like 'AMS_INVALID';
2258: */
2259: CURSOR get_prompt IS

Line 2263: AK_REGION_ITEMS_TL ARAT,

2259: CURSOR get_prompt IS
2260: SELECT
2261: ARAT.ATTRIBUTE_LABEL_LONG
2262: FROM
2263: AK_REGION_ITEMS_TL ARAT,
2264: AK_REGION_ITEMS ARA
2265: WHERE
2266: ARAT.REGION_APPLICATION_ID = ARA.REGION_APPLICATION_ID AND
2267: ARAT.REGION_CODE = ARA.REGION_CODE AND

Line 2264: AK_REGION_ITEMS ARA

2260: SELECT
2261: ARAT.ATTRIBUTE_LABEL_LONG
2262: FROM
2263: AK_REGION_ITEMS_TL ARAT,
2264: AK_REGION_ITEMS ARA
2265: WHERE
2266: ARAT.REGION_APPLICATION_ID = ARA.REGION_APPLICATION_ID AND
2267: ARAT.REGION_CODE = ARA.REGION_CODE AND
2268: ARAT.ATTRIBUTE_APPLICATION_ID = ARA.ATTRIBUTE_APPLICATION_ID AND

Line 2349: from AK_REGION_ITEMS_VL

2345: --inanaiah - Bug 5207293 fix - removed "like" as it is an exact match - Ids 17263290/17263381
2346: /*
2347: CURSOR get_prompt IS
2348: SELECT ATTRIBUTE_LABEL_LONG
2349: from AK_REGION_ITEMS_VL
2350: where region_code like 'AMS_COMPETITOR_PRODUCTS'
2351: and attribute_code like 'AMS_INVALID';
2352: */
2353: CURSOR get_prompt IS

Line 2357: AK_REGION_ITEMS_TL ARAT,

2353: CURSOR get_prompt IS
2354: SELECT
2355: ARAT.ATTRIBUTE_LABEL_LONG
2356: FROM
2357: AK_REGION_ITEMS_TL ARAT,
2358: AK_REGION_ITEMS ARA
2359: WHERE
2360: ARAT.REGION_APPLICATION_ID = ARA.REGION_APPLICATION_ID AND
2361: ARAT.REGION_CODE = ARA.REGION_CODE AND

Line 2358: AK_REGION_ITEMS ARA

2354: SELECT
2355: ARAT.ATTRIBUTE_LABEL_LONG
2356: FROM
2357: AK_REGION_ITEMS_TL ARAT,
2358: AK_REGION_ITEMS ARA
2359: WHERE
2360: ARAT.REGION_APPLICATION_ID = ARA.REGION_APPLICATION_ID AND
2361: ARAT.REGION_CODE = ARA.REGION_CODE AND
2362: ARAT.ATTRIBUTE_APPLICATION_ID = ARA.ATTRIBUTE_APPLICATION_ID AND