VIEW: APPS.CZ_EXV_ITEM_MASTER

Source

View Text - Preformatted

SELECT M.INVENTORY_ITEM_ID,B.ORGANIZATION_ID,M.SEGMENT1, M.FIXED_LEAD_TIME,M.START_DATE_ACTIVE,M.END_DATE_ACTIVE, M.CUSTOMER_ORDER_ENABLED_FLAG,  T.DESCRIPTION AS ITEM_DESC,  M.INVENTORY_ITEM_STATUS_CODE,M.ITEM_CATALOG_GROUP_ID, INDIVISIBLE_FLAG,M.CONCATENATED_SEGMENTS, 		BBM.ASSEMBLY_ITEM_ID AS TOP_ITEM_ID,B.EXPLOSION_TYPE,                 B.COMPONENT_SEQUENCE_ID,B.COMMON_COMPONENT_SEQUENCE_ID,B.COMPONENT_ITEM_ID, 		B.PLAN_LEVEL,B.SORT_ORDER,B.CREATION_DATE,B.CREATED_BY,B.LAST_UPDATE_DATE, 		B.LAST_UPDATED_BY,B.OPTIONAL,B.MUTUALLY_EXCLUSIVE_OPTIONS,B.LOW_QUANTITY, 		B.HIGH_QUANTITY,B.COMPONENT_QUANTITY,B.PRIMARY_UOM_CODE,B.BOM_ITEM_TYPE, 		B.PICK_COMPONENTS_FLAG,B.DESCRIPTION,B.ASSEMBLY_ITEM_ID,B.COMPONENT_CODE, 		B.EFFECTIVITY_DATE,B.DISABLE_DATE, T.LANGUAGE, 		DECODE (M.BOM_ITEM_TYPE || M.PICK_COMPONENTS_FLAG, '1Y','P','1N','A','')      AS MODEL_TYPE,  COMMS_NL_TRACKABLE_FLAG,  CONFIG_MODEL_TYPE, 702 AS BOM_APPLICATION_ID, 401 AS INV_APPLICATION_ID,     DECODE (M.IB_ITEM_INSTANCE_CLASS,'LINK','1','0') AS IB_LINK_ITEM_FLAG,     B.shippable_item_flag,      M.mtl_transactions_enabled_flag,      B.replenish_to_order_flag,      M.serial_number_control_code  	FROM BOM_EXPLOSIONS B,       MTL_SYSTEM_ITEMS_KFV M,      BOM_BILL_OF_MATERIALS BBM , MTL_SYSTEM_ITEMS_TL T  WHERE M.INVENTORY_ITEM_ID(+) = B.COMPONENT_ITEM_ID     AND M.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 M.ORGANIZATION_ID = T.ORGANIZATION_ID AND M.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID 

View Text - HTML Formatted

SELECT M.INVENTORY_ITEM_ID
, B.ORGANIZATION_ID
, M.SEGMENT1
, M.FIXED_LEAD_TIME
, M.START_DATE_ACTIVE
, M.END_DATE_ACTIVE
, M.CUSTOMER_ORDER_ENABLED_FLAG
, T.DESCRIPTION AS ITEM_DESC
, M.INVENTORY_ITEM_STATUS_CODE
, M.ITEM_CATALOG_GROUP_ID
, INDIVISIBLE_FLAG
, M.CONCATENATED_SEGMENTS
, BBM.ASSEMBLY_ITEM_ID AS TOP_ITEM_ID
, B.EXPLOSION_TYPE
, B.COMPONENT_SEQUENCE_ID
, B.COMMON_COMPONENT_SEQUENCE_ID
, B.COMPONENT_ITEM_ID
, B.PLAN_LEVEL
, B.SORT_ORDER
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.OPTIONAL
, B.MUTUALLY_EXCLUSIVE_OPTIONS
, B.LOW_QUANTITY
, B.HIGH_QUANTITY
, B.COMPONENT_QUANTITY
, B.PRIMARY_UOM_CODE
, B.BOM_ITEM_TYPE
, B.PICK_COMPONENTS_FLAG
, B.DESCRIPTION
, B.ASSEMBLY_ITEM_ID
, B.COMPONENT_CODE
, B.EFFECTIVITY_DATE
, B.DISABLE_DATE
, T.LANGUAGE
, DECODE (M.BOM_ITEM_TYPE || M.PICK_COMPONENTS_FLAG
, '1Y'
, 'P'
, '1N'
, 'A'
, '') AS MODEL_TYPE
, COMMS_NL_TRACKABLE_FLAG
, CONFIG_MODEL_TYPE
, 702 AS BOM_APPLICATION_ID
, 401 AS INV_APPLICATION_ID
, DECODE (M.IB_ITEM_INSTANCE_CLASS
, 'LINK'
, '1'
, '0') AS IB_LINK_ITEM_FLAG
, B.SHIPPABLE_ITEM_FLAG
, M.MTL_TRANSACTIONS_ENABLED_FLAG
, B.REPLENISH_TO_ORDER_FLAG
, M.SERIAL_NUMBER_CONTROL_CODE FROM BOM_EXPLOSIONS B
, MTL_SYSTEM_ITEMS_KFV M
, BOM_BILL_OF_MATERIALS BBM
, MTL_SYSTEM_ITEMS_TL T
WHERE M.INVENTORY_ITEM_ID(+) = B.COMPONENT_ITEM_ID
AND M.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 M.ORGANIZATION_ID = T.ORGANIZATION_ID
AND M.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID