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, P.TOP_ITEM_ID, P.EXPLOSION_TYPE, P.ORGANIZATION_ID,  B.COMPONENT_ITEM_ID, B.BILL_SEQUENCE_ID, B.COMPONENT_CODE FROM CZ_XFR_PROJECT_BILLS P, BOM_EXPLOSIONS B, BOM_BILL_OF_MATERIALS BBM,  MTL_SYSTEM_ITEMS_TL T WHERE P.ORGANIZATION_ID=BBM.ORGANIZATION_ID AND P.TOP_ITEM_ID=BBM.ASSEMBLY_ITEM_ID AND P.EXPLOSION_TYPE=B.EXPLOSION_TYPE AND T.INVENTORY_ITEM_ID = B.COMPONENT_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND BBM.ORGANIZATION_ID = B.ORGANIZATION_ID AND BBM.BILL_SEQUENCE_ID = B.TOP_BILL_SEQUENCE_ID AND BBM.ALTERNATE_BOM_DESIGNATOR IS NULL AND P.DELETED_FLAG='0' 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
, P.TOP_ITEM_ID
, P.EXPLOSION_TYPE
, P.ORGANIZATION_ID
, B.COMPONENT_ITEM_ID
, B.BILL_SEQUENCE_ID
, B.COMPONENT_CODE
FROM CZ_XFR_PROJECT_BILLS P
, BOM_EXPLOSIONS B
, BOM_BILL_OF_MATERIALS BBM
, MTL_SYSTEM_ITEMS_TL T
WHERE P.ORGANIZATION_ID=BBM.ORGANIZATION_ID
AND P.TOP_ITEM_ID=BBM.ASSEMBLY_ITEM_ID
AND P.EXPLOSION_TYPE=B.EXPLOSION_TYPE
AND T.INVENTORY_ITEM_ID = B.COMPONENT_ITEM_ID
AND T.ORGANIZATION_ID = B.ORGANIZATION_ID
AND BBM.ORGANIZATION_ID = B.ORGANIZATION_ID
AND BBM.BILL_SEQUENCE_ID = B.TOP_BILL_SEQUENCE_ID
AND BBM.ALTERNATE_BOM_DESIGNATOR IS NULL
AND P.DELETED_FLAG='0'
AND T.LANGUAGE IN (SELECT LANGUAGE_CODE
FROM FND_LANGUAGES
WHERE INSTALLED_FLAG IN ('B'
, 'I'))