View: EDWBV_ITEM_ITEMORGPF_LCV

Product:	ENG - Engineering
Description:	This view contains Product Family items at the item/organization level.
Implementation/DBA Data:	APPS.EDWBV_ITEM_ITEMORGPF_LCV

View Text

SELECT '_KF:INV:MSTK:MTI'
, MTI.INVENTORY_ITEM_ID||'-'||MTP.ORGANIZATION_ID||'-'||INST.INSTANCE_CODE
, NULL
, MTI.INVENTORY_ITEM_ID||'-'||EDW_ITEMS_PKG.GET_MASTER_PARENT(MTP.ORGANIZATION_ID)||'-'||INST.INSTANCE_CODE
, MIC.CATEGORY_ID ||'-'||INST.INSTANCE_CODE
, 'NA_EDW'
, SUBSTR(MTI.CONCATENATED_SEGMENTS||'('||MTP.ORGANIZATION_CODE||')'
, 1
, 240)
, SUBSTR(MTI.CONCATENATED_SEGMENTS||'('||MTP.ORGANIZATION_CODE||')'
, 1
, 80)
, DECODE(MTI.BUYER_ID
, NULL
, 'NA_EDW'
, TO_CHAR(MTI.BUYER_ID)||'?')
, DECODE(MTI.PLANNER_CODE
, NULL
, 'NA_EDW'
, MTI.PLANNER_CODE||'?')
, SUBSTR(MTI.CONCATENATED_SEGMENTS||'('||MTP.ORGANIZATION_CODE||')'
, 1
, 240)
, MTI.DESCRIPTION
, MTI.INVENTORY_ITEM_ID
, MTI.ORGANIZATION_ID
, MTI.PLANNING_MAKE_BUY_CODE
, MTI.LIST_PRICE_PER_UNIT
, MTI.MARKET_PRICE
, MTI.TAXABLE_FLAG
, MTI.STOCK_ENABLED_FLAG
, MTI.INTERNAL_ORDER_ENABLED_FLAG
, MTI.INVENTORY_PLANNING_CODE
, MTI.LOT_CONTROL_CODE
, MTI.OUTSIDE_OPERATION_FLAG
, MTI.PRICE_TOLERANCE_PERCENT
, MTI.PURCHASING_ENABLED_FLAG
, MTI.SHELF_LIFE_CODE
, MTI.SHELF_LIFE_DAYS
, MTI.TAX_CODE
, MTI.REVISION_QTY_CONTROL_CODE
, MTI.INSPECTION_REQUIRED_FLAG
, MTI.RECEIPT_REQUIRED_FLAG
, MTI.LOCATION_CONTROL_CODE
, MTI.EFFECTIVITY_CONTROL
, MTI.SERIAL_NUMBER_CONTROL_CODE
, MTI.MRP_PLANNING_CODE
, MTI.MUST_USE_APPROVED_VENDOR_FLAG
, MTI.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, MTI.ALLOW_UNORDERED_RECEIPTS_FLAG
, MTI.ALLOW_EXPRESS_DELIVERY_FLAG
, MTI.HAZARD_CLASS_ID
, MTI.UN_NUMBER_ID
, MTI.RFQ_REQUIRED_FLAG
, MTI.CREATION_DATE
, MTI.LAST_UPDATE_DATE
, NULL
, MTI.SEGMENT1
, '_DF:INV:MTL_SYSTEM_ITEMS:MTI'
FROM MTL_SYSTEM_ITEMS_KFV MTI
, MTL_ITEM_CATEGORIES MIC
, MTL_CATEGORY_SETS SETS
, MTL_PARAMETERS MTP
, MTL_PARAMETERS MTM
, EDW_LOCAL_INSTANCE INST
WHERE MTI.PRODUCT_FAMILY_ITEM_ID IS NOT NULL
AND MTI.ORGANIZATION_ID = MTP.ORGANIZATION_ID
AND MIC.INVENTORY_ITEM_ID = MTI.PRODUCT_FAMILY_ITEM_ID
AND MIC.ORGANIZATION_ID = MTI.ORGANIZATION_ID
AND MIC.CATEGORY_SET_ID = SETS.CATEGORY_SET_ID
AND SETS.CATEGORY_SET_NAME = 'PRODUCT FAMILY'
AND MTP.MASTER_ORGANIZATION_ID = MTM.ORGANIZATION_ID WITH READ ONLY

Columns