SQL statement to extract all items and classes from Cloud PDH - change as need

select

B.item_number as ItemNumber,

replace(replace(e.DESCRIPTION,chr(10),''),chr(13),'') as ItemDescription,

eic.item_class_code as ItemClass,

decode(b.Approval_Status,'A','Approved','Pending') as ApprovalStatusValue,

b.INVENTORY_ITEM_STATUS_CODE as ItemStatusValue,

b.CURRENT_PHASE_CODE as LifecyclePhaseValue,

b.ITEM_TYPE as UserItemTypeValue,

b.TRADE_ITEM_DESCRIPTOR as PackTypeValue,

0 as RevisionCode,

e.HTML_LONG_DESCRIPTION as FormattedDescription,

e.LONG_DESCRIPTION as LongDescription,

b.PRIMARY_UOM_CODE as PrimaryUOMValue,

b.SECONDARY_UOM_CODE as SecondaryUnitofMeasureValue,

b.TRACKING_QUANTITY_IND as TrackingUnitOfMeasure,

b.DEFAULT_SO_SOURCE_TYPE as DefaultingControlValue,

b.ONT_PRICING_QTY_SOURCE as UOMPricingValue,