FND Design Data [Home] [Help]

View: GMP_SR_MFG_FCST_V

Product: GMP - Process Manufacturing Process Planning
Description:
Implementation/DBA Data: ViewAPPS.GMP_SR_MFG_FCST_V
View Text

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

Columns

Name
FORECAST_DESIGNATOR
SR_INV_ORG_PK
INV_ORG
SR_ITEM_PK
ITEM
SR_CUSTOMER_PK
CUSTOMER
SR_SALES_CHANNEL_PK
SALES_CHANNEL
SR_SHIP_TO_LOC_PK
SHIP_TO_LOC
BUCKET_TYPE
FORECAST_DATE
RATE_END_DATE
ORIGINAL_QUANTITY
CURRENT_QUANTITY
SR_USER_DEFINED1_PK
USER_DEFINED1
SR_USER_DEFINED2_PK
USER_DEFINED2
PRD_LEVEL_ID