VIEW: MSC.MSC_PDR_PARAMETERS#

Source

View Text - Preformatted

select USER_ID USER_ID, PLAN_ID PLAN_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, CATEGORY_SET_ID CATEGORY_SET_ID, PRODUCT_CATEGORY_ID PRODUCT_CATEGORY_ID, ABC_CLASS_ID ABC_CLASS_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, PLANNER_CODE_ID PLANNER_CODE_ID, BUYER_NAME_ID BUYER_NAME_ID, SUPPLIER_ID SUPPLIER_ID, PLANNING_GROUP_ID PLANNING_GROUP_ID, PROJECT_ID PROJECT_ID, RESOURCE_GROUP_ID RESOURCE_GROUP_ID, DEPT_LINE_ID DEPT_LINE_ID, RESOURCE_ID RESOURCE_ID, REPORT_PERIOD_FROM REPORT_PERIOD_FROM, REPORT_PERIOD_TO REPORT_PERIOD_TO, REPORT_DATE_REC REPORT_DATE_REC, PLAN_NAME PLAN_NAME, 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 from "MSC"."MSC_PDR_PARAMETERS"

View Text - HTML Formatted

SELECT USER_ID USER_ID
, PLAN_ID PLAN_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, CATEGORY_SET_ID CATEGORY_SET_ID
, PRODUCT_CATEGORY_ID PRODUCT_CATEGORY_ID
, ABC_CLASS_ID ABC_CLASS_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PLANNER_CODE_ID PLANNER_CODE_ID
, BUYER_NAME_ID BUYER_NAME_ID
, SUPPLIER_ID SUPPLIER_ID
, PLANNING_GROUP_ID PLANNING_GROUP_ID
, PROJECT_ID PROJECT_ID
, RESOURCE_GROUP_ID RESOURCE_GROUP_ID
, DEPT_LINE_ID DEPT_LINE_ID
, RESOURCE_ID RESOURCE_ID
, REPORT_PERIOD_FROM REPORT_PERIOD_FROM
, REPORT_PERIOD_TO REPORT_PERIOD_TO
, REPORT_DATE_REC REPORT_DATE_REC
, PLAN_NAME PLAN_NAME
, 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
FROM "MSC"."MSC_PDR_PARAMETERS"