|
SELECT DISTINCT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.ITM_STATUS_EFFDT , A.ITM_STATUS_CURRENT , A.ITM_STAT_DT_FUTURE , A.ITM_STATUS_FUTURE , A.REPLENISH_CLASS , A.REPL_CALC_PERIOD , A.STOCKOUT_RATE , A.REORDER_QTY , A.QTY_IUT_PAR , A.COST_ELEMENT , A.COST_GROUP_CD , A.NO_REPLENISH_FLG , A.SOURCE_CODE , A.PHANTOM_ITEM_FLAG , A.BOM_USAGE , A.CURRENT_COST , A.DFLT_ACTUAL_COST , A.REVISION_CONTROL , A.EN_AUTO_REV , A.ISSUE_METHOD , A.STAGED_DATE_FLAG , A.PLANNER_CD , A.YIELD_CALC_FLG , A.PRDN_AREA_CODE , A.UOM_CONV_FLAG , A.MASTER_RTG_OPT , A.REF_ROUTING_ITEM , A.STD_PACK_UOM , A.FORECAST_ITEM_FLAG , A.COUNTRY_IST_ORIGIN , A.IST_REGION_ORIGIN , A.NON_OWN_FLAG , A.INV_STOCK_TYPE , A.SHIP_TYPE_ID , A.ISOLATE_ITEM_FLG , A.INVENTORY_ITEM , A.MG_PRDN_OPTION , A.MG_VALID_PRDN_OPT , A.SHELF_LIFE , A.AVAIL_LEAD_TIME , A.RETEST_LEAD_TIME , A.MATERIAL_RECON_FLG , A.USG_TRCKNG_METHOD , A.CHARGE_MARKUP_PCNT , A.CHARGE_MARKUP_AMT , A.CHARGE_CODE , A.MFG_COSTED_FLAG , A.CONSIGNED_FLAG , A.VENDOR_ID , A.VNDR_LOC , A.BOM_CODE , A.RTG_CODE , A.MFG_LEADTIME_F , A.MFG_LEADTIME_V , A.MFG_LTRATEF , A.MFG_LTRATEV , A.OVERSIZED , A.ADD_HANDLING , A.EXPORTER_ECCN , A.EXPORT_LIC_NBR , A.INCL_WIP_QTY_FLG , A.SF_WIP_MAX_QTY , A.SF_RPL_MODE , A.SF_RPL_SOURCE , A.SF_RPL_METHOD , A.SF_RPL_TYPE , A.SF_DISPATCH_MODE , A.SF_RPL_STOR_AREA , A.SF_RPL_STOR_LEV1 , A.SF_RPL_STOR_LEV2 , A.SF_RPL_STOR_LEV3 , A.SF_RPL_STOR_LEV4 , A.SF_RPL_VENDOR_ID , A.SF_RPL_VNDR_LOC , A.SF_RPL_PRDN_AREA , A.REPLENISH_POINT , A.ISSUE_MULTIPLE , A.WIP_MIN_QTY , A.ITEM_FIELD_C30_A , A.ITEM_FIELD_C30_B , A.ITEM_FIELD_C30_C , A.ITEM_FIELD_C30_D , A.ITEM_FIELD_C30_E , A.ITEM_FIELD_C30_F , A.ITEM_FIELD_C30_G , A.ITEM_FIELD_C30_H , A.ITEM_FIELD_C30_I , A.ITEM_FIELD_C1_A , A.ITEM_FIELD_C1_B , A.ITEM_FIELD_C1_C , A.ITEM_FIELD_C1_D , A.ITEM_FIELD_C1_E , A.ITEM_FIELD_C1_F , A.ITEM_FIELD_C1_G , A.ITEM_FIELD_C1_H , A.ITEM_FIELD_C10_A , A.ITEM_FIELD_C10_B , A.ITEM_FIELD_C10_C , A.ITEM_FIELD_C10_D , A.ITEM_FIELD_C10_E , A.ITEM_FIELD_C10_F , A.ITEM_FIELD_C10_G , A.ITEM_FIELD_C10_H , A.ITEM_FIELD_C10_I , A.ITEM_FIELD_C2 , A.ITEM_FIELD_C2_B , A.ITEM_FIELD_C4 , A.ITEM_FIELD_C4_B , A.ITEM_FIELD_C4_C , A.ITEM_FIELD_C6 , A.ITEM_FIELD_C6_B , A.ITEM_FIELD_C8 , A.ITEM_FIELD_C8_B , A.ITEM_FIELD_C8_C , A.ITEM_FIELD_N12_A , A.ITEM_FIELD_N12_B , A.ITEM_FIELD_N12_C , A.ITEM_FIELD_N12_D , A.ITEM_FIELD_N12_E , A.ITEM_FIELD_N12_F , A.ITEM_FIELD_N12_G , A.ITEM_FIELD_N15_A , A.ITEM_FIELD_N15_B , A.ITEM_FIELD_N15_C , A.ITEM_FIELD_N15_D , A.ITEM_FIELD_N15_E , A.ITEM_FIELD_N15_F , A.ITEM_FIELD_N15_G , ' ' FROM PS_BU_ITEMS_INV A
|
BUSINESS_UNIT