VIEW: APPS.EDWBV_ITEM_ITEMORGPF_LCV

Source

View Text - Preformatted

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' , substrb(mti.concatenated_segments||'('||mtp.organization_code||')',1,240) , substrb(mti.concatenated_segments||'('||mtp.organization_code||')',1,320) , decode(mti.buyer_id,NULL,'NA_EDW',to_char(mti.buyer_id)) , decode(mti.planner_code,NULL,'NA_EDW',mti.planner_code) , substrb(mti.concatenated_segments||'('||mtp.organization_code||')',1,240) , substrb(mti.description,1,240) , 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

View Text - HTML Formatted

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'
, SUBSTRB(MTI.CONCATENATED_SEGMENTS||'('||MTP.ORGANIZATION_CODE||')'
, 1
, 240)
, SUBSTRB(MTI.CONCATENATED_SEGMENTS||'('||MTP.ORGANIZATION_CODE||')'
, 1
, 320)
, DECODE(MTI.BUYER_ID
, NULL
, 'NA_EDW'
, TO_CHAR(MTI.BUYER_ID))
, DECODE(MTI.PLANNER_CODE
, NULL
, 'NA_EDW'
, MTI.PLANNER_CODE)
, SUBSTRB(MTI.CONCATENATED_SEGMENTS||'('||MTP.ORGANIZATION_CODE||')'
, 1
, 240)
, SUBSTRB(MTI.DESCRIPTION
, 1
, 240)
, 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