VIEW: MSC.MSC_BIS_INV_DETAIL#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, DETAIL_DATE DETAIL_DATE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, MDS_QUANTITY MDS_QUANTITY, INVENTORY_QUANTITY INVENTORY_QUANTITY, INVENTORY_COST INVENTORY_COST, MDS_COST MDS_COST, MDS_PRICE MDS_PRICE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PRODUCTION_COST PRODUCTION_COST, PURCHASING_COST PURCHASING_COST, CARRYING_COST CARRYING_COST, SERVICE_LEVEL SERVICE_LEVEL, DEMAND_PENALTY_COST DEMAND_PENALTY_COST, INVENTORY_VALUE INVENTORY_VALUE, SUPPLIER_OVERCAP_COST SUPPLIER_OVERCAP_COST, INVENTORY_VALUE_NO_POST INVENTORY_VALUE_NO_POST, INVENTORY_VALUE_POST INVENTORY_VALUE_POST, INVENTORY_COST_POST INVENTORY_COST_POST, INVENTORY_COST_NO_POST INVENTORY_COST_NO_POST, DETAIL_LEVEL DETAIL_LEVEL, PERIOD_TYPE PERIOD_TYPE, TRANSPORTATION_COST TRANSPORTATION_COST, PAB_VALUE PAB_VALUE, INT_REPAIR_COST INT_REPAIR_COST, EXT_REPAIR_COST EXT_REPAIR_COST, SUPPLIER_CAPACITY SUPPLIER_CAPACITY, SUPPLIER_USAGE SUPPLIER_USAGE, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, SHIP_METHOD SHIP_METHOD, SERVICE_LEVEL_1 SERVICE_LEVEL_1, SERVICE_LEVEL_2 SERVICE_LEVEL_2, TOTAL_COST TOTAL_COST, PAB PAB, OTHER_COST OTHER_COST, ZONE_ID ZONE_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, ITEM_TRAVEL_DISTANCE ITEM_TRAVEL_DISTANCE, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID from "MSC"."MSC_BIS_INV_DETAIL"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, DETAIL_DATE DETAIL_DATE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, MDS_QUANTITY MDS_QUANTITY
, INVENTORY_QUANTITY INVENTORY_QUANTITY
, INVENTORY_COST INVENTORY_COST
, MDS_COST MDS_COST
, MDS_PRICE MDS_PRICE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PRODUCTION_COST PRODUCTION_COST
, PURCHASING_COST PURCHASING_COST
, CARRYING_COST CARRYING_COST
, SERVICE_LEVEL SERVICE_LEVEL
, DEMAND_PENALTY_COST DEMAND_PENALTY_COST
, INVENTORY_VALUE INVENTORY_VALUE
, SUPPLIER_OVERCAP_COST SUPPLIER_OVERCAP_COST
, INVENTORY_VALUE_NO_POST INVENTORY_VALUE_NO_POST
, INVENTORY_VALUE_POST INVENTORY_VALUE_POST
, INVENTORY_COST_POST INVENTORY_COST_POST
, INVENTORY_COST_NO_POST INVENTORY_COST_NO_POST
, DETAIL_LEVEL DETAIL_LEVEL
, PERIOD_TYPE PERIOD_TYPE
, TRANSPORTATION_COST TRANSPORTATION_COST
, PAB_VALUE PAB_VALUE
, INT_REPAIR_COST INT_REPAIR_COST
, EXT_REPAIR_COST EXT_REPAIR_COST
, SUPPLIER_CAPACITY SUPPLIER_CAPACITY
, SUPPLIER_USAGE SUPPLIER_USAGE
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, SHIP_METHOD SHIP_METHOD
, SERVICE_LEVEL_1 SERVICE_LEVEL_1
, SERVICE_LEVEL_2 SERVICE_LEVEL_2
, TOTAL_COST TOTAL_COST
, PAB PAB
, OTHER_COST OTHER_COST
, ZONE_ID ZONE_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, ITEM_TRAVEL_DISTANCE ITEM_TRAVEL_DISTANCE
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID
FROM "MSC"."MSC_BIS_INV_DETAIL"