VIEW: APPS.BIL_TX_PRODUCT_V

Source

View Text - Preformatted

SELECT ehpv.category_desc , ehpv.concat_cat_parentage , null , -1 , -1 , ehpv.category_id , ehpv.category_desc, to_number(to_char(ehpv.category_id) ||'.'|| '001') FROM eni_prod_den_hrchy_parents_v ehpv WHERE ehpv.language = USERENV('LANG') AND TRUNC(NVL(ehpv.disable_date,SYSDATE)) >= TRUNC(SYSDATE) AND ehpv.purchase_interest = 'Y' UNION ALL SELECT msit.description, ehpv.concat_cat_parentage ||'/'||msit.description, msit.description as item_name, msit.inventory_item_id as inventory_item_id, msit.organization_id as organization_id, ehpv.category_id , msit.description as VALUE, to_number(TO_CHAR(ehpv.category_id) ||'.'||TO_CHAR(msit.inventory_item_id)) ID FROM eni_prod_den_hrchy_parents_v ehpv, mtl_item_categories mic, mtl_system_items_tl msit WHERE msit.Language = USERENV('LANG') AND msit.organization_id = fnd_profile.value('ORG_ID') AND msit.inventory_item_id = mic.inventory_item_id AND msit.organization_id = mic.organization_id AND mic.category_id = ehpv.category_id AND ehpv.category_set_id = mic.category_set_id AND TRUNC(NVL(ehpv.disable_date,SYSDATE)) >= TRUNC(SYSDATE) AND ehpv.purchase_interest = 'Y' AND ehpv.Language = msit.Language ORDER BY 7

View Text - HTML Formatted

SELECT EHPV.CATEGORY_DESC
, EHPV.CONCAT_CAT_PARENTAGE
, NULL
, -1
, -1
, EHPV.CATEGORY_ID
, EHPV.CATEGORY_DESC
, TO_NUMBER(TO_CHAR(EHPV.CATEGORY_ID) ||'.'|| '001')
FROM ENI_PROD_DEN_HRCHY_PARENTS_V EHPV
WHERE EHPV.LANGUAGE = USERENV('LANG')
AND TRUNC(NVL(EHPV.DISABLE_DATE
, SYSDATE)) >= TRUNC(SYSDATE)
AND EHPV.PURCHASE_INTEREST = 'Y' UNION ALL SELECT MSIT.DESCRIPTION
, EHPV.CONCAT_CAT_PARENTAGE ||'/'||MSIT.DESCRIPTION
, MSIT.DESCRIPTION AS ITEM_NAME
, MSIT.INVENTORY_ITEM_ID AS INVENTORY_ITEM_ID
, MSIT.ORGANIZATION_ID AS ORGANIZATION_ID
, EHPV.CATEGORY_ID
, MSIT.DESCRIPTION AS VALUE
, TO_NUMBER(TO_CHAR(EHPV.CATEGORY_ID) ||'.'||TO_CHAR(MSIT.INVENTORY_ITEM_ID)) ID
FROM ENI_PROD_DEN_HRCHY_PARENTS_V EHPV
, MTL_ITEM_CATEGORIES MIC
, MTL_SYSTEM_ITEMS_TL MSIT
WHERE MSIT.LANGUAGE = USERENV('LANG')
AND MSIT.ORGANIZATION_ID = FND_PROFILE.VALUE('ORG_ID')
AND MSIT.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND MSIT.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND MIC.CATEGORY_ID = EHPV.CATEGORY_ID
AND EHPV.CATEGORY_SET_ID = MIC.CATEGORY_SET_ID
AND TRUNC(NVL(EHPV.DISABLE_DATE
, SYSDATE)) >= TRUNC(SYSDATE)
AND EHPV.PURCHASE_INTEREST = 'Y'
AND EHPV.LANGUAGE = MSIT.LANGUAGE ORDER BY 7