VIEW: APPS.CZ_EXV_INTL_TEXT

Source

View Text - Preformatted

SELECT distinct T.DESCRIPTION, T.LANGUAGE, T.SOURCE_LANG,  B.COMPONENT_SEQUENCE_ID,B.COMMON_COMPONENT_SEQUENCE_ID, B.TOP_ITEM_ID, B.EXPLOSION_TYPE, BBM.ORGANIZATION_ID,  B.COMPONENT_ITEM_ID, B.BILL_SEQUENCE_ID, B.COMPONENT_CODE FROM BOM_EXPLOSIONS B, BOM_BILL_OF_MATERIALS BBM,  MTL_SYSTEM_ITEMS_TL T WHERE T.INVENTORY_ITEM_ID = B.COMPONENT_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND BBM.ORGANIZATION_ID = B.ORGANIZATION_ID AND BBM.ASSEMBLY_ITEM_ID = B.TOP_ITEM_ID AND BBM.BILL_SEQUENCE_ID = B.TOP_BILL_SEQUENCE_ID AND BBM.ALTERNATE_BOM_DESIGNATOR IS NULL AND B.EXPLOSION_TYPE = 'OPTIONAL' AND T.LANGUAGE IN (SELECT language_code    FROM fnd_languages WHERE installed_flag IN ('B', 'I'))

View Text - HTML Formatted

SELECT DISTINCT T.DESCRIPTION
, T.LANGUAGE
, T.SOURCE_LANG
, B.COMPONENT_SEQUENCE_ID
, B.COMMON_COMPONENT_SEQUENCE_ID
, B.TOP_ITEM_ID
, B.EXPLOSION_TYPE
, BBM.ORGANIZATION_ID
, B.COMPONENT_ITEM_ID
, B.BILL_SEQUENCE_ID
, B.COMPONENT_CODE
FROM BOM_EXPLOSIONS B
, BOM_BILL_OF_MATERIALS BBM
, MTL_SYSTEM_ITEMS_TL T
WHERE T.INVENTORY_ITEM_ID = B.COMPONENT_ITEM_ID
AND T.ORGANIZATION_ID = B.ORGANIZATION_ID
AND BBM.ORGANIZATION_ID = B.ORGANIZATION_ID
AND BBM.ASSEMBLY_ITEM_ID = B.TOP_ITEM_ID
AND BBM.BILL_SEQUENCE_ID = B.TOP_BILL_SEQUENCE_ID
AND BBM.ALTERNATE_BOM_DESIGNATOR IS NULL
AND B.EXPLOSION_TYPE = 'OPTIONAL'
AND T.LANGUAGE IN (SELECT LANGUAGE_CODE
FROM FND_LANGUAGES
WHERE INSTALLED_FLAG IN ('B'
, 'I'))