VIEW: APPS.MSD_FORECAST_BASIS_LIAB_CS_V

Source

View Text - Preformatted

SELECT PLAN_ID, cs_name, ORG_LEVEL_VALUE_PK, ORG_LEVEL_ID, PRD_LEVEL_VALUE_PK, PRD_LEVEL_ID, geo_level_value_pk, geo_level_id, time_level_id, QUANTITY, AMOUNT, SCHEDULE_DATE, creation_date, created_by, last_update_date, last_updated_by, last_update_login, LAST_REFRESH_NUM, CREATED_BY_REFRESH_NUM, ACTION_CODE, PRD_PARENT_LEVEL_ID, PRD_PARENT_LEVEL_VALUE_PK FROM MSD_SUPPLY_COMMIT_CS_V WHERE ASL_LIABILITY_AGREEMENT_BASIS=2 UNION ALL SELECT PLAN_ID, cs_name, ORG_LEVEL_VALUE_PK, ORG_LEVEL_ID, PRD_LEVEL_VALUE_PK, PRD_LEVEL_ID, geo_level_value_pk, geo_level_id, time_level_id, QUANTITY, AMOUNT, SCHEDULE_DATE, creation_date, created_by, last_update_date, last_updated_by, last_update_login, LAST_REFRESH_NUM, CREATED_BY_REFRESH_NUM, ACTION_CODE, PRD_PARENT_LEVEL_ID, PRD_PARENT_LEVEL_VALUE_PK FROM MSD_ORDER_FORECAST_CS_V WHERE ASL_LIABILITY_AGREEMENT_BASIS=1

View Text - HTML Formatted

SELECT PLAN_ID
, CS_NAME
, ORG_LEVEL_VALUE_PK
, ORG_LEVEL_ID
, PRD_LEVEL_VALUE_PK
, PRD_LEVEL_ID
, GEO_LEVEL_VALUE_PK
, GEO_LEVEL_ID
, TIME_LEVEL_ID
, QUANTITY
, AMOUNT
, SCHEDULE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_REFRESH_NUM
, CREATED_BY_REFRESH_NUM
, ACTION_CODE
, PRD_PARENT_LEVEL_ID
, PRD_PARENT_LEVEL_VALUE_PK
FROM MSD_SUPPLY_COMMIT_CS_V
WHERE ASL_LIABILITY_AGREEMENT_BASIS=2 UNION ALL SELECT PLAN_ID
, CS_NAME
, ORG_LEVEL_VALUE_PK
, ORG_LEVEL_ID
, PRD_LEVEL_VALUE_PK
, PRD_LEVEL_ID
, GEO_LEVEL_VALUE_PK
, GEO_LEVEL_ID
, TIME_LEVEL_ID
, QUANTITY
, AMOUNT
, SCHEDULE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_REFRESH_NUM
, CREATED_BY_REFRESH_NUM
, ACTION_CODE
, PRD_PARENT_LEVEL_ID
, PRD_PARENT_LEVEL_VALUE_PK
FROM MSD_ORDER_FORECAST_CS_V
WHERE ASL_LIABILITY_AGREEMENT_BASIS=1