View: CE_FORECAST_ROWS_V

Product:	CE - Cash Management
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CE_FORECAST_ROWS_V

View Text

SELECT R.FORECAST_ROW_ID
, R.FORECAST_HEADER_ID
, R.ROW_NUMBER
, R.TRX_TYPE
, L.MEANING TRX_TYPE_DSP
, R.LEAD_TIME
, R.FORECAST_METHOD
, R.ROLL_FORWARD_TYPE
, R.ROLL_FORWARD_PERIOD
, R.DISCOUNT_OPTION
, R.ORDER_STATUS
, R.ORDER_DATE_TYPE
, OD.MEANING ORDER_DATE_TYPE_NAME
, R.CODE_COMBINATION_ID
, R.SET_OF_BOOKS_ID
, GLS.NAME SET_OF_BOOKS_NAME
, R.ORG_ID
, R.CHART_OF_ACCOUNTS_ID
, R.BUDGET_NAME
, R.BUDGET_VERSION_ID
, R.ENCUMBRANCE_TYPE_ID
, GLE.ENCUMBRANCE_TYPE
, R.CUSTOMER_PROFILE_CLASS_ID
, ARC.NAME CUSTOMER_PROFILE_CLASS_NAME
, R.INCLUDE_DISPUTE_FLAG
, R.SALES_STAGE_ID
, ASS.NAME SALES_STAGE_NAME
, R.CHANNEL_CODE
, R.WIN_PROBABILITY
, R.SALES_FORECAST_STATUS
, R.RECEIPT_METHOD_ID
, ARR.NAME RECEIPT_METHOD_NAME
, R.BANK_ACCOUNT_ID
, DECODE(R.TRX_TYPE
, 'PAY'
, BA2.BANK_ACCOUNT_NAME
, BA.BANK_ACCOUNT_NAME) BANK_ACCOUNT_NAME
, DECODE(R.TRX_TYPE
, 'PAY'
, PAY_METH.ORG_PAYMENT_METHOD_NAME
, R.PAYMENT_METHOD) PAYMENT_METHOD
, R.PAY_GROUP
, R.PAYMENT_PRIORITY
, R.VENDOR_TYPE
, R.AUTHORIZATION_STATUS
, R.ORG_PAYMENT_METHOD_ID
, PAY_ORG.LEGISLATION_CODE
, R.TYPE
, DECODE(R.TRX_TYPE
, 'XTR'
, XTRL.MEANING
, 'XTI'
, XTRL.MEANING
, 'XTO'
, XTRL.MEANING
, 'PAT'
, PAL.MEANING) TYPE_NAME
, R.BUDGET_TYPE
, PAB.NAME BUDGET_TYPE_NAME
, R.BUDGET_VERSION
, R.INCLUDE_HOLD_FLAG
, R.INCLUDE_NET_CASH_FLAG
, R.COMPANY_CODE
, R.XTR_BANK_ACCOUNT
, R.EXCLUDE_INDIC_EXP
, R.CREATED_BY
, R.CREATION_DATE
, R.LAST_UPDATED_BY
, R.LAST_UPDATE_DATE
, R.LAST_UPDATE_LOGIN
, R.ATTRIBUTE_CATEGORY
, R.ATTRIBUTE1
, R.ATTRIBUTE2
, R.ATTRIBUTE3
, R.ATTRIBUTE4
, R.ATTRIBUTE5
, R.ATTRIBUTE6
, R.ATTRIBUTE7
, R.ATTRIBUTE8
, R.ATTRIBUTE9
, R.ATTRIBUTE10
, R.ATTRIBUTE11
, R.ATTRIBUTE12
, R.ATTRIBUTE13
, R.ATTRIBUTE14
, R.ATTRIBUTE15
, R.DESCRIPTION
, DECODE(R.TRX_TYPE
, 'PAY'
, PAY_ORG.NAME
, 'XTR'
, HZ.KNOWN_AS
, 'XTI'
, HZ.KNOWN_AS
, 'XTO'
, HZ.KNOWN_AS
, HRO.NAME) ORG_NAME
, R.ROWID ROW_ID
, R.PAYROLL_ID
, PAY.PAYROLL_NAME
, R.EXTERNAL_SOURCE_TYPE
, R.CRITERIA_CATEGORY
, R.CRITERIA1
, R.CRITERIA2
, R.CRITERIA3
, R.CRITERIA4
, R.CRITERIA5
, R.CRITERIA6
, R.CRITERIA7
, R.CRITERIA8
, R.CRITERIA9
, R.CRITERIA10
, R.CRITERIA11
, R.CRITERIA12
, R.CRITERIA13
, R.CRITERIA14
, R.CRITERIA15
, R.USE_AVERAGE_PAYMENT_DAYS
, R.PERIOD
, R.USE_PAYMENT_TERMS
, R.ORDER_TYPE_ID
, OT.NAME ORDER_TYPE_NAME
, R.LEGAL_ENTITY_ID
, R.INCLUDE_TEMP_LABOR_FLAG
FROM GL_SETS_OF_BOOKS GLS
, GL_ENCUMBRANCE_TYPES GLE
, CE_FORECAST_ROWS R
, CE_LOOKUPS L
, AS_SALES_STAGES_ALL ASS
, HZ_CUST_PROFILE_CLASSES ARC
, AR_RECEIPT_METHODS ARR
, CE_BANK_ACCOUNTS BA
, CE_BANK_ACCOUNTS BA2
, CE_BANK_ACCT_USES_ALL BAU2
, HR_OPERATING_UNITS HRO
, PAY_ALL_PAYROLLS_F PAY
, PER_BUSINESS_GROUPS PAY_ORG
, PAY_ORG_PAYMENT_METHODS_F PAY_METH
, PA_BUDGET_TYPES_V PAB
, XLE_ENTITY_PROFILES XLE
, HZ_PARTIES HZ
, CE_LOOKUPS PAL
, CE_LOOKUPS XTRL
, CE_LOOKUPS OD
, OE_ORDER_TYPES_V OT
WHERE GLS.SET_OF_BOOKS_ID (+) = R.SET_OF_BOOKS_ID
AND GLE.ENCUMBRANCE_TYPE_ID (+) = R.ENCUMBRANCE_TYPE_ID
AND ASS.SALES_STAGE_ID (+) = R.SALES_STAGE_ID
AND ARC.PROFILE_CLASS_ID (+) = R.CUSTOMER_PROFILE_CLASS_ID
AND ARR.RECEIPT_METHOD_ID (+) = R.RECEIPT_METHOD_ID
AND BA.BANK_ACCOUNT_ID (+) = R.BANK_ACCOUNT_ID
AND BA2.BANK_ACCOUNT_ID(+) = BAU2.BANK_ACCOUNT_ID
AND BAU2.PAYROLL_BANK_ACCOUNT_ID (+) = PAY_METH.EXTERNAL_ACCOUNT_ID
AND L.LOOKUP_TYPE(+) = 'FORECAST_TRX_TYPE'
AND L.LOOKUP_CODE(+) = R.TRX_TYPE
AND HRO.ORGANIZATION_ID (+) = R.ORG_ID
AND PAY.PAYROLL_ID(+) = R.PAYROLL_ID
AND PAY_ORG.BUSINESS_GROUP_ID (+) = R.ORG_ID
AND PAY_METH.ORG_PAYMENT_METHOD_ID (+) = R.ORG_PAYMENT_METHOD_ID
AND PAB.CODE (+) = R.BUDGET_TYPE AND XLE.LEGAL_ENTITY_ID(+) = R.ORG_ID
AND HZ.PARTY_ID(+) = XLE.PARTY_ID
AND PAL.LOOKUP_TYPE(+) = 'FORECAST_PA_TXN'
AND PAL.LOOKUP_CODE(+) = R.TYPE
AND XTRL.LOOKUP_TYPE(+) = 'XTR_TRX_TYPE'
AND XTRL.LOOKUP_CODE(+) = R.TYPE
AND OD.LOOKUP_TYPE(+) = 'FORECAST_ORDER_DATE_TYPE'
AND OD.LOOKUP_CODE(+) = R.ORDER_DATE_TYPE
AND OT.ORDER_TYPE_ID(+) = R.ORDER_TYPE_ID

Columns