VIEW: APPS.IBW_PAGE_V

Source

View Text - Preformatted

SELECT pageins.page_instance_id ID, page.page_name || ' : ' || item.item_description VALUE, page.page_name, item.item_description context_name, pageins.page_id page_id, page.site_area_id site_area_id, page.page_code page_code, pageins.business_context business_context, (select meaning from fnd_lookup_values lookup where lookup.lookup_type = 'IBW_BUSINESS_CONTEXT' AND lookup.lookup_code = 'PRODUCT' and lookup.LANGUAGE = USERENV('LANG')) business_context_name, item.inventory_item_id context_instance_value, item.VALUE context_instance_code FROM eni_item_v item, ibw_pages_vl page, ibw_page_instances pageins WHERE SUBSTR (pageins.business_context_value, 1, INSTR (pageins.business_context_value, '-', 1, 2) - 1 ) = item.ID AND page.page_status = 'Y' AND pageins.business_context = 'PRODUCT' AND page.page_id = pageins.page_id UNION ALL SELECT pageins.page_instance_id ID , page.page_name || NULLIF (' : ' || ctx.context_instance_name, (select ' : ' ||meaning from fnd_lookup_values lookup2 where lookup2.lookup_type = 'IBW_BUSINESS_CONTEXT' AND lookup2.lookup_code = 'NONE' and lookup2.LANGUAGE = USERENV('LANG')) ) VALUE, page.page_name, ctx.context_instance_name context_name, pageins.page_id page_id, page.site_area_id site_area_id, page.page_code page_code, ctx.business_context business_context, decode(ctx.business_context,'NONE',NULL, (select meaning from fnd_lookup_values lookup1 where lookup1.lookup_type = 'IBW_BUSINESS_CONTEXT' AND lookup1.lookup_code = 'SECTION' and lookup1.LANGUAGE = USERENV('LANG')) ) business_context_name , ctx.context_instance_value context_instance_value, ctx.context_instance_code context_instance_code FROM ibw_context_interface_vl ctx, ibw_pages_vl page, ibw_page_instances pageins WHERE ctx.business_context = pageins.business_context AND pageins.business_context <> 'PRODUCT' AND TO_CHAR (ctx.context_instance_value) = pageins.business_context_value AND page.page_status = 'Y' AND page.page_id = pageins.page_id

View Text - HTML Formatted

SELECT PAGEINS.PAGE_INSTANCE_ID ID
, PAGE.PAGE_NAME || ' : ' || ITEM.ITEM_DESCRIPTION VALUE
, PAGE.PAGE_NAME
, ITEM.ITEM_DESCRIPTION CONTEXT_NAME
, PAGEINS.PAGE_ID PAGE_ID
, PAGE.SITE_AREA_ID SITE_AREA_ID
, PAGE.PAGE_CODE PAGE_CODE
, PAGEINS.BUSINESS_CONTEXT BUSINESS_CONTEXT
, (SELECT MEANING
FROM FND_LOOKUP_VALUES LOOKUP
WHERE LOOKUP.LOOKUP_TYPE = 'IBW_BUSINESS_CONTEXT'
AND LOOKUP.LOOKUP_CODE = 'PRODUCT'
AND LOOKUP.LANGUAGE = USERENV('LANG')) BUSINESS_CONTEXT_NAME
, ITEM.INVENTORY_ITEM_ID CONTEXT_INSTANCE_VALUE
, ITEM.VALUE CONTEXT_INSTANCE_CODE
FROM ENI_ITEM_V ITEM
, IBW_PAGES_VL PAGE
, IBW_PAGE_INSTANCES PAGEINS
WHERE SUBSTR (PAGEINS.BUSINESS_CONTEXT_VALUE
, 1
, INSTR (PAGEINS.BUSINESS_CONTEXT_VALUE
, '-'
, 1
, 2) - 1 ) = ITEM.ID
AND PAGE.PAGE_STATUS = 'Y'
AND PAGEINS.BUSINESS_CONTEXT = 'PRODUCT'
AND PAGE.PAGE_ID = PAGEINS.PAGE_ID UNION ALL SELECT PAGEINS.PAGE_INSTANCE_ID ID
, PAGE.PAGE_NAME || NULLIF (' : ' || CTX.CONTEXT_INSTANCE_NAME
, (SELECT ' : ' ||MEANING
FROM FND_LOOKUP_VALUES LOOKUP2
WHERE LOOKUP2.LOOKUP_TYPE = 'IBW_BUSINESS_CONTEXT'
AND LOOKUP2.LOOKUP_CODE = 'NONE'
AND LOOKUP2.LANGUAGE = USERENV('LANG')) ) VALUE
, PAGE.PAGE_NAME
, CTX.CONTEXT_INSTANCE_NAME CONTEXT_NAME
, PAGEINS.PAGE_ID PAGE_ID
, PAGE.SITE_AREA_ID SITE_AREA_ID
, PAGE.PAGE_CODE PAGE_CODE
, CTX.BUSINESS_CONTEXT BUSINESS_CONTEXT
, DECODE(CTX.BUSINESS_CONTEXT
, 'NONE'
, NULL
, (SELECT MEANING
FROM FND_LOOKUP_VALUES LOOKUP1
WHERE LOOKUP1.LOOKUP_TYPE = 'IBW_BUSINESS_CONTEXT'
AND LOOKUP1.LOOKUP_CODE = 'SECTION'
AND LOOKUP1.LANGUAGE = USERENV('LANG')) ) BUSINESS_CONTEXT_NAME
, CTX.CONTEXT_INSTANCE_VALUE CONTEXT_INSTANCE_VALUE
, CTX.CONTEXT_INSTANCE_CODE CONTEXT_INSTANCE_CODE
FROM IBW_CONTEXT_INTERFACE_VL CTX
, IBW_PAGES_VL PAGE
, IBW_PAGE_INSTANCES PAGEINS
WHERE CTX.BUSINESS_CONTEXT = PAGEINS.BUSINESS_CONTEXT
AND PAGEINS.BUSINESS_CONTEXT <> 'PRODUCT'
AND TO_CHAR (CTX.CONTEXT_INSTANCE_VALUE) = PAGEINS.BUSINESS_CONTEXT_VALUE
AND PAGE.PAGE_STATUS = 'Y'
AND PAGE.PAGE_ID = PAGEINS.PAGE_ID