DBA Data[Home] [Help]

VIEW: APPS.MSD_CS_PLANNING_BOOKING_V

Source

View Text - Preformatted

SELECT PRD_LEVEL_ID, PRD_LEVEL_VALUE_PK, GEO_LEVEL_ID, GEO_LEVEL_VALUE_PK, ORG_LEVEL_ID, ORG_LEVEL_VALUE_PK, REP_LEVEL_ID, REP_LEVEL_VALUE_PK, CHN_LEVEL_ID, CHN_LEVEL_VALUE_PK, UD1_LEVEL_ID, UD1_LEVEL_VALUE_PK, UD2_LEVEL_ID, UD2_LEVEL_VALUE_PK, TIME_LEVEL_ID, BOOKED_DATE, AMOUNT, QUANTITY from msd_booking_data_cs_v
View Text - HTML Formatted

SELECT PRD_LEVEL_ID
, PRD_LEVEL_VALUE_PK
, GEO_LEVEL_ID
, GEO_LEVEL_VALUE_PK
, ORG_LEVEL_ID
, ORG_LEVEL_VALUE_PK
, REP_LEVEL_ID
, REP_LEVEL_VALUE_PK
, CHN_LEVEL_ID
, CHN_LEVEL_VALUE_PK
, UD1_LEVEL_ID
, UD1_LEVEL_VALUE_PK
, UD2_LEVEL_ID
, UD2_LEVEL_VALUE_PK
, TIME_LEVEL_ID
, BOOKED_DATE
, AMOUNT
, QUANTITY
FROM MSD_BOOKING_DATA_CS_V