VIEW: APPS.EDWBV_ITEM_ITEMORG_LCV

Source

View Text - Preformatted

SELECT '_KF:INV:MSTK:mti', mti.inventory_item_id ||'-'||mti.organization_id, null, mti.inventory_item_id ||'-'||edw_items_pkg.get_master_parent(mti.organization_id), 'NA_EDW' , '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 , substrb(mti.planning_make_buy_code ,1,40), mti.list_price_per_unit , mti.market_price , mti.taxable_flag , mti.stock_enabled_flag , mti.internal_order_enabled_flag , substrb(mti.inventory_planning_code,1,40) , 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' , mti.item_type from mtl_system_items_b_kfv mti, mtl_parameters mtp, mtl_parameters mtm WHERE mti.organization_id=mtp.organization_id and mtp.master_organization_id=mtm.organization_id WITH READ ONLY

View Text - HTML Formatted

SELECT '_KF:INV:MSTK:MTI'
, MTI.INVENTORY_ITEM_ID ||'-'||MTI.ORGANIZATION_ID
, NULL
, MTI.INVENTORY_ITEM_ID ||'-'||EDW_ITEMS_PKG.GET_MASTER_PARENT(MTI.ORGANIZATION_ID)
, 'NA_EDW'
, '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
, SUBSTRB(MTI.PLANNING_MAKE_BUY_CODE
, 1
, 40)
, MTI.LIST_PRICE_PER_UNIT
, MTI.MARKET_PRICE
, MTI.TAXABLE_FLAG
, MTI.STOCK_ENABLED_FLAG
, MTI.INTERNAL_ORDER_ENABLED_FLAG
, SUBSTRB(MTI.INVENTORY_PLANNING_CODE
, 1
, 40)
, 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'
, MTI.ITEM_TYPE
FROM MTL_SYSTEM_ITEMS_B_KFV MTI
, MTL_PARAMETERS MTP
, MTL_PARAMETERS MTM
WHERE MTI.ORGANIZATION_ID=MTP.ORGANIZATION_ID
AND MTP.MASTER_ORGANIZATION_ID=MTM.ORGANIZATION_ID WITH READ ONLY