[Home] [Help]
SELECT item_revision_pk, instance, item_org_fk, item_revision_dp, substrb(name,1,320), item_revision, effective_date, creation_date, last_update_date, operation_code, NULL , NULL , NULL , NULL , NULL from edwbv_item_itemrev_lcv
SELECT ITEM_REVISION_PK
, INSTANCE
, ITEM_ORG_FK
, ITEM_REVISION_DP
, SUBSTRB(NAME
, 1
, 320)
, ITEM_REVISION
, EFFECTIVE_DATE
, CREATION_DATE
, LAST_UPDATE_DATE
, OPERATION_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDWBV_ITEM_ITEMREV_LCV
|
|
|
|