VIEW: APPS.EDWBV_ITEM_ITEMREV_LCV

Source

View Text - Preformatted

SELECT mtr.revision||'-'|| mtr.inventory_item_id ||'-'|| mtr.organization_id ||'-'|| inst.instance_code , inst.instance_code , mtr.inventory_item_id||'-'||mtr.organization_id||'-'||inst.instance_code , substrb(mtr.revision || '(' || mti.concatenated_segments || ',' ||mp.organization_code || ')',1,240) , substrb(mtr.revision || '(' || mti.concatenated_segments || ',' || mp.organization_code || ')',1,320) , substrb(mtr.revision || '(' || mti.concatenated_segments || ',' || mp.organization_code || ')',1,240) , mtr.effectivity_date , mtr.creation_date , mtr.last_update_date, NULL, '_DF:INV:MTL_ITEM_REVISIONS:mtr' from mtl_system_items_kfv mti, mtl_item_revisions mtr, mtl_parameters mp, edw_local_instance inst WHERE mti.inventory_item_id = mtr.inventory_item_id and mti.organization_id = mtr.organization_id and mtr.organization_id = mp.organization_id WITH READ ONLY

View Text - HTML Formatted

SELECT MTR.REVISION||'-'|| MTR.INVENTORY_ITEM_ID ||'-'|| MTR.ORGANIZATION_ID ||'-'|| INST.INSTANCE_CODE
, INST.INSTANCE_CODE
, MTR.INVENTORY_ITEM_ID||'-'||MTR.ORGANIZATION_ID||'-'||INST.INSTANCE_CODE
, SUBSTRB(MTR.REVISION || '(' || MTI.CONCATENATED_SEGMENTS || '
, ' ||MP.ORGANIZATION_CODE || ')'
, 1
, 240)
, SUBSTRB(MTR.REVISION || '(' || MTI.CONCATENATED_SEGMENTS || '
, ' || MP.ORGANIZATION_CODE || ')'
, 1
, 320)
, SUBSTRB(MTR.REVISION || '(' || MTI.CONCATENATED_SEGMENTS || '
, ' || MP.ORGANIZATION_CODE || ')'
, 1
, 240)
, MTR.EFFECTIVITY_DATE
, MTR.CREATION_DATE
, MTR.LAST_UPDATE_DATE
, NULL
, '_DF:INV:MTL_ITEM_REVISIONS:MTR'
FROM MTL_SYSTEM_ITEMS_KFV MTI
, MTL_ITEM_REVISIONS MTR
, MTL_PARAMETERS MP
, EDW_LOCAL_INSTANCE INST
WHERE MTI.INVENTORY_ITEM_ID = MTR.INVENTORY_ITEM_ID
AND MTI.ORGANIZATION_ID = MTR.ORGANIZATION_ID
AND MTR.ORGANIZATION_ID = MP.ORGANIZATION_ID WITH READ ONLY