VIEW: CE.CE_FORECAST_ROWS#

Source

View Text - Preformatted

select FORECAST_ROW_ID FORECAST_ROW_ID, FORECAST_HEADER_ID FORECAST_HEADER_ID, ROW_NUMBER ROW_NUMBER, TRX_TYPE TRX_TYPE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DESCRIPTION DESCRIPTION, LEAD_TIME LEAD_TIME, FORECAST_METHOD FORECAST_METHOD, RECEIPT_METHOD_ID RECEIPT_METHOD_ID, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, PAYMENT_METHOD PAYMENT_METHOD, PAY_GROUP PAY_GROUP, VENDOR_TYPE VENDOR_TYPE, PAYMENT_PRIORITY PAYMENT_PRIORITY, ROLL_FORWARD_TYPE ROLL_FORWARD_TYPE, ROLL_FORWARD_PERIOD ROLL_FORWARD_PERIOD, DISCOUNT_OPTION DISCOUNT_OPTION, INCLUDE_FLOAT_FLAG INCLUDE_FLOAT_FLAG, INCLUDE_DISPUTE_FLAG INCLUDE_DISPUTE_FLAG, CUSTOMER_PROFILE_CLASS_ID CUSTOMER_PROFILE_CLASS_ID, ORDER_STATUS ORDER_STATUS, ORDER_DATE_TYPE ORDER_DATE_TYPE, SALES_STAGE_ID SALES_STAGE_ID, CHANNEL_CODE CHANNEL_CODE, WIN_PROBABILITY WIN_PROBABILITY, SALES_FORECAST_STATUS SALES_FORECAST_STATUS, CODE_COMBINATION_ID CODE_COMBINATION_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ORG_ID ORG_ID, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID, BUDGET_NAME BUDGET_NAME, BUDGET_VERSION_ID BUDGET_VERSION_ID, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, AUTHORIZATION_STATUS AUTHORIZATION_STATUS, ORG_PAYMENT_METHOD_ID ORG_PAYMENT_METHOD_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, PAYROLL_ID PAYROLL_ID, EXTERNAL_SOURCE_TYPE EXTERNAL_SOURCE_TYPE, CRITERIA_CATEGORY CRITERIA_CATEGORY, CRITERIA1 CRITERIA1, CRITERIA2 CRITERIA2, CRITERIA3 CRITERIA3, CRITERIA4 CRITERIA4, CRITERIA5 CRITERIA5, CRITERIA6 CRITERIA6, CRITERIA7 CRITERIA7, CRITERIA8 CRITERIA8, CRITERIA9 CRITERIA9, CRITERIA10 CRITERIA10, CRITERIA11 CRITERIA11, CRITERIA12 CRITERIA12, CRITERIA13 CRITERIA13, CRITERIA14 CRITERIA14, CRITERIA15 CRITERIA15, TYPE TYPE, BUDGET_TYPE BUDGET_TYPE, BUDGET_VERSION BUDGET_VERSION, INCLUDE_HOLD_FLAG INCLUDE_HOLD_FLAG, INCLUDE_NET_CASH_FLAG INCLUDE_NET_CASH_FLAG, COMPANY_CODE COMPANY_CODE, EXCLUDE_INDIC_EXP EXCLUDE_INDIC_EXP, XTR_BANK_ACCOUNT XTR_BANK_ACCOUNT, USE_AVERAGE_PAYMENT_DAYS USE_AVERAGE_PAYMENT_DAYS, PERIOD PERIOD, USE_PAYMENT_TERMS USE_PAYMENT_TERMS, ORDER_TYPE_ID ORDER_TYPE_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, INCLUDE_TEMP_LABOR_FLAG INCLUDE_TEMP_LABOR_FLAG from "CE"."CE_FORECAST_ROWS"

View Text - HTML Formatted

SELECT FORECAST_ROW_ID FORECAST_ROW_ID
, FORECAST_HEADER_ID FORECAST_HEADER_ID
, ROW_NUMBER ROW_NUMBER
, TRX_TYPE TRX_TYPE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DESCRIPTION DESCRIPTION
, LEAD_TIME LEAD_TIME
, FORECAST_METHOD FORECAST_METHOD
, RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, PAYMENT_METHOD PAYMENT_METHOD
, PAY_GROUP PAY_GROUP
, VENDOR_TYPE VENDOR_TYPE
, PAYMENT_PRIORITY PAYMENT_PRIORITY
, ROLL_FORWARD_TYPE ROLL_FORWARD_TYPE
, ROLL_FORWARD_PERIOD ROLL_FORWARD_PERIOD
, DISCOUNT_OPTION DISCOUNT_OPTION
, INCLUDE_FLOAT_FLAG INCLUDE_FLOAT_FLAG
, INCLUDE_DISPUTE_FLAG INCLUDE_DISPUTE_FLAG
, CUSTOMER_PROFILE_CLASS_ID CUSTOMER_PROFILE_CLASS_ID
, ORDER_STATUS ORDER_STATUS
, ORDER_DATE_TYPE ORDER_DATE_TYPE
, SALES_STAGE_ID SALES_STAGE_ID
, CHANNEL_CODE CHANNEL_CODE
, WIN_PROBABILITY WIN_PROBABILITY
, SALES_FORECAST_STATUS SALES_FORECAST_STATUS
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ORG_ID ORG_ID
, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, BUDGET_NAME BUDGET_NAME
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, AUTHORIZATION_STATUS AUTHORIZATION_STATUS
, ORG_PAYMENT_METHOD_ID ORG_PAYMENT_METHOD_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, PAYROLL_ID PAYROLL_ID
, EXTERNAL_SOURCE_TYPE EXTERNAL_SOURCE_TYPE
, CRITERIA_CATEGORY CRITERIA_CATEGORY
, CRITERIA1 CRITERIA1
, CRITERIA2 CRITERIA2
, CRITERIA3 CRITERIA3
, CRITERIA4 CRITERIA4
, CRITERIA5 CRITERIA5
, CRITERIA6 CRITERIA6
, CRITERIA7 CRITERIA7
, CRITERIA8 CRITERIA8
, CRITERIA9 CRITERIA9
, CRITERIA10 CRITERIA10
, CRITERIA11 CRITERIA11
, CRITERIA12 CRITERIA12
, CRITERIA13 CRITERIA13
, CRITERIA14 CRITERIA14
, CRITERIA15 CRITERIA15
, TYPE TYPE
, BUDGET_TYPE BUDGET_TYPE
, BUDGET_VERSION BUDGET_VERSION
, INCLUDE_HOLD_FLAG INCLUDE_HOLD_FLAG
, INCLUDE_NET_CASH_FLAG INCLUDE_NET_CASH_FLAG
, COMPANY_CODE COMPANY_CODE
, EXCLUDE_INDIC_EXP EXCLUDE_INDIC_EXP
, XTR_BANK_ACCOUNT XTR_BANK_ACCOUNT
, USE_AVERAGE_PAYMENT_DAYS USE_AVERAGE_PAYMENT_DAYS
, PERIOD PERIOD
, USE_PAYMENT_TERMS USE_PAYMENT_TERMS
, ORDER_TYPE_ID ORDER_TYPE_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, INCLUDE_TEMP_LABOR_FLAG INCLUDE_TEMP_LABOR_FLAG
FROM "CE"."CE_FORECAST_ROWS"