VIEW: APPS.GMP_SR_MFG_FCST_V

Source

View Text - Preformatted

SELECT NULL FORECAST_DESIGNATOR, to_number(NULL) SR_INV_ORG_PK, NULL INV_ORG, to_number(NULL) SR_ITEM_PK, NULL ITEM, to_number(NULL) SR_CUSTOMER_PK, NULL CUSTOMER, to_number(NULL) SR_SALES_CHANNEL_PK, NULL SALES_CHANNEL, to_number(NULL) SR_SHIP_TO_LOC_PK, NULL SHIP_TO_LOC, to_number(NULL) BUCKET_TYPE, to_date(NULL) FORECAST_DATE, to_date(NULL) RATE_END_DATE, to_number(NULL) ORIGINAL_QUANTITY, to_number(NULL) CURRENT_QUANTITY, NULL SR_USER_DEFINED1_PK, NULL USER_DEFINED1, NULL SR_USER_DEFINED2_PK, NULL USER_DEFINED2, to_number(NULL) PRD_LEVEL_ID FROM SYS.DUAL WHERE 1 <> 1

View Text - HTML Formatted

SELECT NULL FORECAST_DESIGNATOR
, TO_NUMBER(NULL) SR_INV_ORG_PK
, NULL INV_ORG
, TO_NUMBER(NULL) SR_ITEM_PK
, NULL ITEM
, TO_NUMBER(NULL) SR_CUSTOMER_PK
, NULL CUSTOMER
, TO_NUMBER(NULL) SR_SALES_CHANNEL_PK
, NULL SALES_CHANNEL
, TO_NUMBER(NULL) SR_SHIP_TO_LOC_PK
, NULL SHIP_TO_LOC
, TO_NUMBER(NULL) BUCKET_TYPE
, TO_DATE(NULL) FORECAST_DATE
, TO_DATE(NULL) RATE_END_DATE
, TO_NUMBER(NULL) ORIGINAL_QUANTITY
, TO_NUMBER(NULL) CURRENT_QUANTITY
, NULL SR_USER_DEFINED1_PK
, NULL USER_DEFINED1
, NULL SR_USER_DEFINED2_PK
, NULL USER_DEFINED2
, TO_NUMBER(NULL) PRD_LEVEL_ID
FROM SYS.DUAL
WHERE 1 <> 1