eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: MSC.MSC_APCC_ITEM_D_BAK#

Source

View Text - Preformatted


select PLAN_ID PLAN_ID, SR_INSTANCE_ID SR_INSTANCE_ID, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_NAME ITEM_NAME, ABC_CLASS ABC_CLASS, PRODUCT_FAMILY_ID PRODUCT_FAMILY_ID, SR_CATEGORY_ID1 SR_CATEGORY_ID1, SR_CATEGORY_ID2 SR_CATEGORY_ID2, SR_CATEGORY_ID3 SR_CATEGORY_ID3, LATEST_ITEM_ID LATEST_ITEM_ID, AVERAGE_DAILY_DEMAND AVERAGE_DAILY_DEMAND, AVERAGE_DISCOUNT AVERAGE_DISCOUNT, BUYER_NAME BUYER_NAME, FIXED_LEAD_TIME FIXED_LEAD_TIME, LIST_PRICE LIST_PRICE, MAX_MINMAX_QUANTITY MAX_MINMAX_QUANTITY, MIN_MINMAX_QUANTITY MIN_MINMAX_QUANTITY, MINIMUM_ORDER_QUANTITY MINIMUM_ORDER_QUANTITY, MRP_PLANNING_CODE MRP_PLANNING_CODE, PLANNER_CODE PLANNER_CODE, PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE, POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME, PREPROCESSING_LEAD_TIME PREPROCESSING_LEAD_TIME, STANDARD_COST STANDARD_COST, UNIT_VOLUME UNIT_VOLUME, UNIT_WEIGHT UNIT_WEIGHT, UOM_CODE UOM_CODE, VARIABLE_LEAD_TIME VARIABLE_LEAD_TIME, VOLUME_UOM VOLUME_UOM, WEIGHT_UOM WEIGHT_UOM, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID from "MSC"."MSC_APCC_ITEM_D_BAK"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_NAME ITEM_NAME
, ABC_CLASS ABC_CLASS
, PRODUCT_FAMILY_ID PRODUCT_FAMILY_ID
, SR_CATEGORY_ID1 SR_CATEGORY_ID1
, SR_CATEGORY_ID2 SR_CATEGORY_ID2
, SR_CATEGORY_ID3 SR_CATEGORY_ID3
, LATEST_ITEM_ID LATEST_ITEM_ID
, AVERAGE_DAILY_DEMAND AVERAGE_DAILY_DEMAND
, AVERAGE_DISCOUNT AVERAGE_DISCOUNT
, BUYER_NAME BUYER_NAME
, FIXED_LEAD_TIME FIXED_LEAD_TIME
, LIST_PRICE LIST_PRICE
, MAX_MINMAX_QUANTITY MAX_MINMAX_QUANTITY
, MIN_MINMAX_QUANTITY MIN_MINMAX_QUANTITY
, MINIMUM_ORDER_QUANTITY MINIMUM_ORDER_QUANTITY
, MRP_PLANNING_CODE MRP_PLANNING_CODE
, PLANNER_CODE PLANNER_CODE
, PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE
, POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME
, PREPROCESSING_LEAD_TIME PREPROCESSING_LEAD_TIME
, STANDARD_COST STANDARD_COST
, UNIT_VOLUME UNIT_VOLUME
, UNIT_WEIGHT UNIT_WEIGHT
, UOM_CODE UOM_CODE
, VARIABLE_LEAD_TIME VARIABLE_LEAD_TIME
, VOLUME_UOM VOLUME_UOM
, WEIGHT_UOM WEIGHT_UOM
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
FROM "MSC"."MSC_APCC_ITEM_D_BAK"