VIEW: APPS.EDWBV_ITEM_ITEM_LCV

Source

View Text - Preformatted

SELECT '_KF:INV:MSTK:mti', mti.inventory_item_id||'-'||mti.organization_id, null, 'NA_EDW' , 'NA_EDW' , 'NA_EDW' , 'NA_EDW' , substrb(mti.CONCATENATED_SEGMENTS||'('||mtp.organization_code||')',1,240) , substrb(mti.CONCATENATED_SEGMENTS||'('||mtp.organization_code||')',1,320) , substrb(mti.CONCATENATED_SEGMENTS||'('||mtp.organization_code||')',1,240) , substrb(mti.description,1,240) , mti.ORGANIZATION_ID , mti.inventory_item_id , mti.last_update_date , mti.creation_date , NULL, '_DF:INV:MTL_SYSTEM_ITEMS:mti' , mti.item_type from mtl_system_items_kfv mti, mtl_parameters mtp WHERE mtp.organization_id = mtp.master_organization_id and mti.organization_id = mtp.organization_id WITH READ ONLY

View Text - HTML Formatted

SELECT '_KF:INV:MSTK:MTI'
, MTI.INVENTORY_ITEM_ID||'-'||MTI.ORGANIZATION_ID
, NULL
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, SUBSTRB(MTI.CONCATENATED_SEGMENTS||'('||MTP.ORGANIZATION_CODE||')'
, 1
, 240)
, SUBSTRB(MTI.CONCATENATED_SEGMENTS||'('||MTP.ORGANIZATION_CODE||')'
, 1
, 320)
, SUBSTRB(MTI.CONCATENATED_SEGMENTS||'('||MTP.ORGANIZATION_CODE||')'
, 1
, 240)
, SUBSTRB(MTI.DESCRIPTION
, 1
, 240)
, MTI.ORGANIZATION_ID
, MTI.INVENTORY_ITEM_ID
, MTI.LAST_UPDATE_DATE
, MTI.CREATION_DATE
, NULL
, '_DF:INV:MTL_SYSTEM_ITEMS:MTI'
, MTI.ITEM_TYPE
FROM MTL_SYSTEM_ITEMS_KFV MTI
, MTL_PARAMETERS MTP
WHERE MTP.ORGANIZATION_ID = MTP.MASTER_ORGANIZATION_ID
AND MTI.ORGANIZATION_ID = MTP.ORGANIZATION_ID WITH READ ONLY