View: CEBV_CASH_FORECAST_CELLS

Product:	CE - Cash Management
Description:	Business View
Implementation/DBA Data:	APPS.CEBV_CASH_FORECAST_CELLS

View Text

SELECT CL.FORECAST_CELL_ID
, L1.MEANING
, PS.START_DATE
, PE.END_DATE
, CL.AMOUNT
, FR.DESCRIPTION
, FR.LEAD_TIME
, SB.NAME
, L6.MEANING
, FR.BANK_ACCOUNT_ID
, BA.BANK_ACCOUNT_NAME
, BA.BANK_ACCOUNT_NUM
, '_KF:PAY:BANK:PB'
, RM.NAME
, CP.NAME
, DECODE(FR.TRX_TYPE
, 'PAY'
, PM.ORG_PAYMENT_METHOD_NAME
, FR.PAYMENT_METHOD)
, RL.MEANING
, FR.PAY_GROUP
, FR.VENDOR_TYPE
, FR.PAYMENT_PRIORITY
, L5.MEANING
, OL.DESCRIPTION
, L2.MEANING
, FR.ROLL_FORWARD_PERIOD
, L3.MEANING
, L4.MEANING
, PA.PAYROLL_NAME
, OI.ORG_INFORMATION9
, FR.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GC'
, EN.ENCUMBRANCE_TYPE
, FR.BUDGET_NAME
, FR.EXTERNAL_SOURCE_TYPE
, FR.CRITERIA1
, FR.CRITERIA2
, FR.CRITERIA3
, FR.CRITERIA4
, FR.CRITERIA5
, FR.CRITERIA6
, FR.CRITERIA7
, FR.CRITERIA8
, FR.CRITERIA9
, FR.CRITERIA10
, FR.CRITERIA11
, FR.CRITERIA12
, FR.CRITERIA13
, FR.CRITERIA14
, CL.FORECAST_ID
, CL.CREATION_DATE
, CL.CREATED_BY
, CL.LAST_UPDATE_DATE
, CL.LAST_UPDATED_BY
FROM CE_FORECAST_CELLS CL
, CE_FORECAST_HEADERS FH
, CE_FORECASTS FC
, CE_FORECAST_ROWS FR
, CE_FORECAST_COLUMNS CO
, CE_BANK_ACCOUNTS BA
, CE_LOOKUPS L1
, CE_LOOKUPS L2
, CE_LOOKUPS L3
, CE_LOOKUPS L4
, CE_LOOKUPS L5
, CE_LOOKUPS L6
, GL_SETS_OF_BOOKS SB
, AR_RECEIPT_METHODS RM
, HZ_CUST_PROFILE_CLASSES CP
, PAY_ORG_PAYMENT_METHODS_F PM
, AR_LOOKUPS RL
, PO_LOOKUP_CODES OL
, PAY_ALL_PAYROLLS_F PA
, HR_ALL_ORGANIZATION_UNITS OG
, HR_ORGANIZATION_INFORMATION OI
, GL_CODE_COMBINATIONS GC
, GL_ENCUMBRANCE_TYPES EN
, PAY_EXTERNAL_ACCOUNTS PB
, GL_PERIODS PS
, GL_PERIODS PE
, GL_PERIODS LP
, GL_PERIOD_TYPES PT
WHERE FH.FORECAST_HEADER_ID = CL.FORECAST_HEADER_ID
AND FC.FORECAST_ID = CL.FORECAST_ID
AND FR.FORECAST_ROW_ID = CL.FORECAST_ROW_ID
AND CO.FORECAST_COLUMN_ID = CL.FORECAST_COLUMN_ID
AND L1.LOOKUP_TYPE = 'FORECAST_TRX_TYPE'
AND L1.LOOKUP_CODE = FR.TRX_TYPE
AND SB.SET_OF_BOOKS_ID (+) = FR.SET_OF_BOOKS_ID
AND BA.BANK_ACCOUNT_ID (+) = FR.BANK_ACCOUNT_ID
AND RM.RECEIPT_METHOD_ID (+) = FR.RECEIPT_METHOD_ID
AND CP.PROFILE_CLASS_ID (+) = FR.CUSTOMER_PROFILE_CLASS_ID
AND PM.ORG_PAYMENT_METHOD_ID (+) = FR.ORG_PAYMENT_METHOD_ID
AND RL.LOOKUP_TYPE (+) = 'YES/NO'
AND RL.LOOKUP_CODE (+) = FR.INCLUDE_DISPUTE_FLAG
AND OL.LOOKUP_TYPE (+) = 'ASL_STATUS'
AND OL.LOOKUP_CODE (+) = FR.AUTHORIZATION_STATUS
AND L2.LOOKUP_TYPE (+) = 'FORECAST_ROLL_FORWARD_TYPE'
AND L2.LOOKUP_CODE (+) = FR.ROLL_FORWARD_TYPE
AND L3.LOOKUP_TYPE (+) = 'FORECAST_ORDER_STATUS'
AND L3.LOOKUP_CODE (+) = FR.ORDER_STATUS
AND L4.LOOKUP_TYPE (+) = 'FORECAST_ORDER_DATE_TYPE'
AND L4.LOOKUP_CODE (+) = FR.ORDER_DATE_TYPE
AND L5.LOOKUP_TYPE (+) = 'FORECAST_DISCOUNT_OPTION'
AND L5.LOOKUP_CODE (+) = FR.DISCOUNT_OPTION
AND L6.LOOKUP_TYPE (+) = 'FORECAST_METHOD'
AND L6.LOOKUP_CODE (+) = FR.FORECAST_METHOD
AND PA.PAYROLL_ID (+) = FR.PAYROLL_ID
AND OG.ORGANIZATION_ID (+) = PA.BUSINESS_GROUP_ID
AND OI.ORGANIZATION_ID (+) = OG.ORGANIZATION_ID
AND OI.ORG_INFORMATION_CONTEXT (+) = 'BUSINESS GROUP INFORMATION'
AND GC.CODE_COMBINATION_ID (+) = FR.CODE_COMBINATION_ID
AND EN.ENCUMBRANCE_TYPE_ID (+) = FR.ENCUMBRANCE_TYPE_ID
AND PB.EXTERNAL_ACCOUNT_ID (+) = FR.BANK_ACCOUNT_ID
AND PS.PERIOD_NUM = DECODE (GREATEST(LP.PERIOD_NUM+CO.DAYS_FROM - 1
, PT.NUMBER_PER_FISCAL_YEAR)
, PT.NUMBER_PER_FISCAL_YEAR
, LP.PERIOD_NUM + CO.DAYS_FROM -1
, MOD(LP.PERIOD_NUM + CO.DAYS_FROM - 1
, PT.NUMBER_PER_FISCAL_YEAR))
AND PE.PERIOD_NUM = DECODE (GREATEST(LP.PERIOD_NUM + CO.DAYS_TO - 1
, PT.NUMBER_PER_FISCAL_YEAR)
, PT.NUMBER_PER_FISCAL_YEAR
, LP.PERIOD_NUM + CO.DAYS_TO -1
, MOD(LP.PERIOD_NUM + CO.DAYS_TO- 1
, PT.NUMBER_PER_FISCAL_YEAR))
AND PS.PERIOD_YEAR = DECODE(MOD(LP.PERIOD_NUM + CO.DAYS_FROM - 1
, PT.NUMBER_PER_FISCAL_YEAR)
, 0
, LP.PERIOD_YEAR + FLOOR((LP.PERIOD_NUM+CO.DAYS_FROM- 1)/PT.NUMBER_PER_FISCAL_YEAR) - 1
, LP.PERIOD_YEAR+ FLOOR((LP.PERIOD_NUM + CO.DAYS_FROM-1) /PT.NUMBER_PER_FISCAL_YEAR))
AND PE.PERIOD_YEAR = DECODE(MOD(LP.PERIOD_NUM + CO.DAYS_TO - 1
, PT.NUMBER_PER_FISCAL_YEAR)
, 0
, LP.PERIOD_YEAR + FLOOR((LP.PERIOD_NUM + CO.DAYS_TO-1)/PT.NUMBER_PER_FISCAL_YEAR) - 1
, LP.PERIOD_YEAR + FLOOR((LP.PERIOD_NUM + CO.DAYS_TO -1) /PT.NUMBER_PER_FISCAL_YEAR))
AND PT.PERIOD_TYPE = LP.PERIOD_TYPE
AND PS.PERIOD_TYPE = PE.PERIOD_TYPE
AND PS.PERIOD_SET_NAME = LP.PERIOD_SET_NAME
AND PE.PERIOD_SET_NAME = LP.PERIOD_SET_NAME
AND LP.PERIOD_TYPE = PS.PERIOD_TYPE
AND LP.PERIOD_SET_NAME = FC.PERIOD_SET_NAME
AND LP.PERIOD_NAME = FC.START_PERIOD
AND CO.FORECAST_HEADER_ID = FH.FORECAST_HEADER_ID
AND FH.FORECAST_HEADER_ID = FC.FORECAST_HEADER_ID
AND NVL(FH.AGING_TYPE
, 'D') = 'A' UNION ALL SELECT CL.FORECAST_CELL_ID
, L1.MEANING
, FC.START_DATE + CO.DAYS_FROM - 1
, FC.START_DATE + CO.DAYS_TO - 1
, CL.AMOUNT
, FR.DESCRIPTION
, FR.LEAD_TIME
, SB.NAME
, L6.MEANING
, FR.BANK_ACCOUNT_ID
, BA.BANK_ACCOUNT_NAME
, BA.BANK_ACCOUNT_NUM
, '_KF:PAY:BANK:PB'
, RM.NAME
, CP.NAME
, DECODE(FR.TRX_TYPE
, 'PAY'
, PM.ORG_PAYMENT_METHOD_NAME
, FR.PAYMENT_METHOD)
, RL.MEANING
, FR.PAY_GROUP
, FR.VENDOR_TYPE
, FR.PAYMENT_PRIORITY
, L5.MEANING
, OL.DESCRIPTION
, L2.MEANING
, FR.ROLL_FORWARD_PERIOD
, L3.MEANING
, L4.MEANING
, PA.PAYROLL_NAME
, OI.ORG_INFORMATION9
, FR.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GC'
, EN.ENCUMBRANCE_TYPE
, FR.BUDGET_NAME
, FR.EXTERNAL_SOURCE_TYPE
, FR.CRITERIA1
, FR.CRITERIA2
, FR.CRITERIA3
, FR.CRITERIA4
, FR.CRITERIA5
, FR.CRITERIA6
, FR.CRITERIA7
, FR.CRITERIA8
, FR.CRITERIA9
, FR.CRITERIA10
, FR.CRITERIA11
, FR.CRITERIA12
, FR.CRITERIA13
, FR.CRITERIA14
, CL.FORECAST_ID
, CL.CREATION_DATE
, CL.CREATED_BY
, CL.LAST_UPDATE_DATE
, CL.LAST_UPDATED_BY
FROM CE_FORECAST_CELLS CL
, CE_FORECAST_HEADERS FH
, CE_FORECASTS FC
, CE_FORECAST_ROWS FR
, CE_FORECAST_COLUMNS CO
, CE_BANK_ACCOUNTS BA
, CE_LOOKUPS L1
, CE_LOOKUPS L2
, CE_LOOKUPS L3
, CE_LOOKUPS L4
, CE_LOOKUPS L5
, CE_LOOKUPS L6
, GL_SETS_OF_BOOKS SB
, AR_RECEIPT_METHODS RM
, HZ_CUST_PROFILE_CLASSES CP
, PAY_ORG_PAYMENT_METHODS_F PM
, AR_LOOKUPS RL
, PO_LOOKUP_CODES OL
, PAY_ALL_PAYROLLS_F PA
, HR_ALL_ORGANIZATION_UNITS OG
, HR_ORGANIZATION_INFORMATION OI
, GL_CODE_COMBINATIONS GC
, GL_ENCUMBRANCE_TYPES EN
, PAY_EXTERNAL_ACCOUNTS PB
WHERE FH.FORECAST_HEADER_ID = CL.FORECAST_HEADER_ID
AND FC.FORECAST_ID = CL.FORECAST_ID
AND FR.FORECAST_ROW_ID = CL.FORECAST_ROW_ID
AND CO.FORECAST_COLUMN_ID = CL.FORECAST_COLUMN_ID
AND L1.LOOKUP_TYPE = 'FORECAST_TRX_TYPE'
AND L1.LOOKUP_CODE = FR.TRX_TYPE
AND SB.SET_OF_BOOKS_ID (+) = FR.SET_OF_BOOKS_ID
AND BA.BANK_ACCOUNT_ID (+) = FR.BANK_ACCOUNT_ID
AND RM.RECEIPT_METHOD_ID (+) = FR.RECEIPT_METHOD_ID
AND CP.PROFILE_CLASS_ID (+) = FR.CUSTOMER_PROFILE_CLASS_ID
AND PM.ORG_PAYMENT_METHOD_ID (+) = FR.ORG_PAYMENT_METHOD_ID
AND RL.LOOKUP_TYPE (+) = 'YES/NO'
AND RL.LOOKUP_CODE (+) = FR.INCLUDE_DISPUTE_FLAG
AND OL.LOOKUP_TYPE (+) = 'ASL_STATUS'
AND OL.LOOKUP_CODE (+) = FR.AUTHORIZATION_STATUS
AND L2.LOOKUP_TYPE (+) = 'FORECAST_ROLL_FORWARD_TYPE'
AND L2.LOOKUP_CODE (+) = FR.ROLL_FORWARD_TYPE
AND L3.LOOKUP_TYPE (+) = 'FORECAST_ORDER_STATUS'
AND L3.LOOKUP_CODE (+) = FR.ORDER_STATUS
AND L4.LOOKUP_TYPE (+) = 'FORECAST_ORDER_DATE_TYPE'
AND L4.LOOKUP_CODE (+) = FR.ORDER_DATE_TYPE
AND L5.LOOKUP_TYPE (+) = 'FORECAST_DISCOUNT_OPTION'
AND L5.LOOKUP_CODE (+) = FR.DISCOUNT_OPTION
AND L6.LOOKUP_TYPE (+) = 'FORECAST_METHOD'
AND L6.LOOKUP_CODE (+) = FR.FORECAST_METHOD
AND PA.PAYROLL_ID (+) = FR.PAYROLL_ID
AND OG.ORGANIZATION_ID (+) = PA.BUSINESS_GROUP_ID
AND OI.ORGANIZATION_ID (+) = OG.ORGANIZATION_ID
AND OI.ORG_INFORMATION_CONTEXT (+) = 'BUSINESS GROUP INFORMATION'
AND GC.CODE_COMBINATION_ID (+) = FR.CODE_COMBINATION_ID
AND EN.ENCUMBRANCE_TYPE_ID (+) = FR.ENCUMBRANCE_TYPE_ID
AND PB.EXTERNAL_ACCOUNT_ID (+) = FR.BANK_ACCOUNT_ID
AND CO.FORECAST_HEADER_ID = FH.FORECAST_HEADER_ID
AND FH.FORECAST_HEADER_ID = FC.FORECAST_HEADER_ID
AND NVL(FH.AGING_TYPE
, 'D') = 'D' UNION ALL SELECT TO_NUMBER(NULL)
, L1.MEANING
, PS.START_DATE
, PE.END_DATE
, CL.AMOUNT
, FR.DESCRIPTION
, FR.LEAD_TIME
, SB.NAME
, L6.MEANING
, FR.BANK_ACCOUNT_ID
, BA.BANK_ACCOUNT_NAME
, BA.BANK_ACCOUNT_NUM
, '_KF:PAY:BANK:PB'
, RM.NAME
, CP.NAME
, DECODE(FR.TRX_TYPE
, 'PAY'
, PM.ORG_PAYMENT_METHOD_NAME
, FR.PAYMENT_METHOD)
, RL.MEANING
, FR.PAY_GROUP
, FR.VENDOR_TYPE
, FR.PAYMENT_PRIORITY
, L5.MEANING
, OL.DESCRIPTION
, L2.MEANING
, FR.ROLL_FORWARD_PERIOD
, L3.MEANING
, L4.MEANING
, PA.PAYROLL_NAME
, OI.ORG_INFORMATION9
, FR.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GC'
, EN.ENCUMBRANCE_TYPE
, FR.BUDGET_NAME
, FR.EXTERNAL_SOURCE_TYPE
, FR.CRITERIA1
, FR.CRITERIA2
, FR.CRITERIA3
, FR.CRITERIA4
, FR.CRITERIA5
, FR.CRITERIA6
, FR.CRITERIA7
, FR.CRITERIA8
, FR.CRITERIA9
, FR.CRITERIA10
, FR.CRITERIA11
, FR.CRITERIA12
, FR.CRITERIA13
, FR.CRITERIA14
, CL.FORECAST_ID
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
FROM (SELECT FCELL.FORECAST_ID
, FCELL.FORECAST_HEADER_ID
, FCELL.FORECAST_ROW_ID
, FCELL.FORECAST_COLUMN_ID
, SUM(FCELL.AMOUNT) AMOUNT FROM CE_FORECAST_TRX_CELLS FCELL GROUP BY FCELL.FORECAST_ID
, FCELL.FORECAST_HEADER_ID
, FCELL.FORECAST_ROW_ID
, FCELL.FORECAST_COLUMN_ID) CL
, CE_FORECAST_HEADERS FH
, CE_FORECASTS FC
, CE_FORECAST_ROWS FR
, CE_FORECAST_COLUMNS CO
, CE_BANK_ACCOUNTS BA
, CE_LOOKUPS L1
, CE_LOOKUPS L2
, CE_LOOKUPS L3
, CE_LOOKUPS L4
, CE_LOOKUPS L5
, CE_LOOKUPS L6
, GL_SETS_OF_BOOKS SB
, AR_RECEIPT_METHODS RM
, HZ_CUST_PROFILE_CLASSES CP
, PAY_ORG_PAYMENT_METHODS_F PM
, AR_LOOKUPS RL
, PO_LOOKUP_CODES OL
, PAY_ALL_PAYROLLS_F PA
, HR_ALL_ORGANIZATION_UNITS OG
, HR_ORGANIZATION_INFORMATION OI
, GL_CODE_COMBINATIONS GC
, GL_ENCUMBRANCE_TYPES EN
, PAY_EXTERNAL_ACCOUNTS PB
, GL_PERIODS PS
, GL_PERIODS PE
, GL_PERIODS LP
, GL_PERIOD_TYPES PT
WHERE FH.FORECAST_HEADER_ID = CL.FORECAST_HEADER_ID
AND FC.FORECAST_ID = CL.FORECAST_ID
AND FR.FORECAST_ROW_ID = CL.FORECAST_ROW_ID
AND CO.FORECAST_COLUMN_ID = CL.FORECAST_COLUMN_ID
AND L1.LOOKUP_TYPE = 'FORECAST_TRX_TYPE'
AND L1.LOOKUP_CODE = FR.TRX_TYPE
AND SB.SET_OF_BOOKS_ID (+) = FR.SET_OF_BOOKS_ID
AND BA.BANK_ACCOUNT_ID (+) = FR.BANK_ACCOUNT_ID
AND RM.RECEIPT_METHOD_ID (+) = FR.RECEIPT_METHOD_ID
AND CP.PROFILE_CLASS_ID (+) = FR.CUSTOMER_PROFILE_CLASS_ID
AND PM.ORG_PAYMENT_METHOD_ID (+) = FR.ORG_PAYMENT_METHOD_ID
AND RL.LOOKUP_TYPE (+) = 'YES/NO'
AND RL.LOOKUP_CODE (+) = FR.INCLUDE_DISPUTE_FLAG
AND OL.LOOKUP_TYPE (+) = 'ASL_STATUS'
AND OL.LOOKUP_CODE (+) = FR.AUTHORIZATION_STATUS
AND L2.LOOKUP_TYPE (+) = 'FORECAST_ROLL_FORWARD_TYPE'
AND L2.LOOKUP_CODE (+) = FR.ROLL_FORWARD_TYPE
AND L3.LOOKUP_TYPE (+) = 'FORECAST_ORDER_STATUS'
AND L3.LOOKUP_CODE (+) = FR.ORDER_STATUS
AND L4.LOOKUP_TYPE (+) = 'FORECAST_ORDER_DATE_TYPE'
AND L4.LOOKUP_CODE (+) = FR.ORDER_DATE_TYPE
AND L5.LOOKUP_TYPE (+) = 'FORECAST_DISCOUNT_OPTION'
AND L5.LOOKUP_CODE (+) = FR.DISCOUNT_OPTION
AND L6.LOOKUP_TYPE (+) = 'FORECAST_METHOD'
AND L6.LOOKUP_CODE (+) = FR.FORECAST_METHOD
AND PA.PAYROLL_ID (+) = FR.PAYROLL_ID
AND OG.ORGANIZATION_ID (+) = PA.BUSINESS_GROUP_ID
AND OI.ORGANIZATION_ID (+) = OG.ORGANIZATION_ID
AND OI.ORG_INFORMATION_CONTEXT (+) = 'BUSINESS GROUP INFORMATION'
AND GC.CODE_COMBINATION_ID (+) = FR.CODE_COMBINATION_ID
AND EN.ENCUMBRANCE_TYPE_ID (+) = FR.ENCUMBRANCE_TYPE_ID
AND PB.EXTERNAL_ACCOUNT_ID (+) = FR.BANK_ACCOUNT_ID
AND PS.PERIOD_NUM = DECODE (GREATEST(LP.PERIOD_NUM+CO.DAYS_FROM - 1
, PT.NUMBER_PER_FISCAL_YEAR)
, PT.NUMBER_PER_FISCAL_YEAR
, LP.PERIOD_NUM + CO.DAYS_FROM -1
, MOD(LP.PERIOD_NUM + CO.DAYS_FROM - 1
, PT.NUMBER_PER_FISCAL_YEAR))
AND PE.PERIOD_NUM = DECODE (GREATEST(LP.PERIOD_NUM + CO.DAYS_TO - 1
, PT.NUMBER_PER_FISCAL_YEAR)
, PT.NUMBER_PER_FISCAL_YEAR
, LP.PERIOD_NUM + CO.DAYS_TO -1
, MOD(LP.PERIOD_NUM + CO.DAYS_TO- 1
, PT.NUMBER_PER_FISCAL_YEAR))
AND PS.PERIOD_YEAR = DECODE(MOD(LP.PERIOD_NUM + CO.DAYS_FROM - 1
, PT.NUMBER_PER_FISCAL_YEAR)
, 0
, LP.PERIOD_YEAR + FLOOR((LP.PERIOD_NUM+CO.DAYS_FROM- 1)/PT.NUMBER_PER_FISCAL_YEAR) - 1
, LP.PERIOD_YEAR+ FLOOR((LP.PERIOD_NUM + CO.DAYS_FROM-1) /PT.NUMBER_PER_FISCAL_YEAR))
AND PE.PERIOD_YEAR = DECODE(MOD(LP.PERIOD_NUM + CO.DAYS_TO - 1
, PT.NUMBER_PER_FISCAL_YEAR)
, 0
, LP.PERIOD_YEAR + FLOOR((LP.PERIOD_NUM + CO.DAYS_TO-1)/PT.NUMBER_PER_FISCAL_YEAR) - 1
, LP.PERIOD_YEAR + FLOOR((LP.PERIOD_NUM + CO.DAYS_TO -1) /PT.NUMBER_PER_FISCAL_YEAR))
AND PT.PERIOD_TYPE = LP.PERIOD_TYPE
AND PS.PERIOD_TYPE = PE.PERIOD_TYPE
AND PS.PERIOD_SET_NAME = LP.PERIOD_SET_NAME
AND PE.PERIOD_SET_NAME = LP.PERIOD_SET_NAME
AND LP.PERIOD_TYPE = PS.PERIOD_TYPE
AND LP.PERIOD_SET_NAME = FC.PERIOD_SET_NAME
AND LP.PERIOD_NAME = FC.START_PERIOD
AND CO.FORECAST_HEADER_ID = FH.FORECAST_HEADER_ID
AND FH.FORECAST_HEADER_ID = FC.FORECAST_HEADER_ID
AND NVL(FH.AGING_TYPE
, 'D') = 'A' UNION ALL SELECT TO_NUMBER(NULL)
, L1.MEANING
, FC.START_DATE + CO.DAYS_FROM - 1
, FC.START_DATE + CO.DAYS_TO - 1
, CL.AMOUNT
, FR.DESCRIPTION
, FR.LEAD_TIME
, SB.NAME
, L6.MEANING
, FR.BANK_ACCOUNT_ID
, BA.BANK_ACCOUNT_NAME
, BA.BANK_ACCOUNT_NUM
, '_KF:PAY:BANK:PB'
, RM.NAME
, CP.NAME
, DECODE(FR.TRX_TYPE
, 'PAY'
, PM.ORG_PAYMENT_METHOD_NAME
, FR.PAYMENT_METHOD)
, RL.MEANING
, FR.PAY_GROUP
, FR.VENDOR_TYPE
, FR.PAYMENT_PRIORITY
, L5.MEANING
, OL.DESCRIPTION
, L2.MEANING
, FR.ROLL_FORWARD_PERIOD
, L3.MEANING
, L4.MEANING
, PA.PAYROLL_NAME
, OI.ORG_INFORMATION9
, FR.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GC'
, EN.ENCUMBRANCE_TYPE
, FR.BUDGET_NAME
, FR.EXTERNAL_SOURCE_TYPE
, FR.CRITERIA1
, FR.CRITERIA2
, FR.CRITERIA3
, FR.CRITERIA4
, FR.CRITERIA5
, FR.CRITERIA6
, FR.CRITERIA7
, FR.CRITERIA8
, FR.CRITERIA9
, FR.CRITERIA10
, FR.CRITERIA11
, FR.CRITERIA12
, FR.CRITERIA13
, FR.CRITERIA14
, CL.FORECAST_ID
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
FROM (SELECT FCELL.FORECAST_ID
, FCELL.FORECAST_HEADER_ID
, FCELL.FORECAST_ROW_ID
, FCELL.FORECAST_COLUMN_ID
, SUM(FCELL.AMOUNT) AMOUNT FROM CE_FORECAST_TRX_CELLS FCELL GROUP BY FCELL.FORECAST_ID
, FCELL.FORECAST_HEADER_ID
, FCELL.FORECAST_ROW_ID
, FCELL.FORECAST_COLUMN_ID) CL
, CE_FORECAST_HEADERS FH
, CE_FORECASTS FC
, CE_FORECAST_ROWS FR
, CE_FORECAST_COLUMNS CO
, CE_BANK_ACCOUNTS BA
, CE_LOOKUPS L1
, CE_LOOKUPS L2
, CE_LOOKUPS L3
, CE_LOOKUPS L4
, CE_LOOKUPS L5
, CE_LOOKUPS L6
, GL_SETS_OF_BOOKS SB
, AR_RECEIPT_METHODS RM
, HZ_CUST_PROFILE_CLASSES CP
, PAY_ORG_PAYMENT_METHODS_F PM
, AR_LOOKUPS RL
, PO_LOOKUP_CODES OL
, PAY_ALL_PAYROLLS_F PA
, HR_ALL_ORGANIZATION_UNITS OG
, HR_ORGANIZATION_INFORMATION OI
, GL_CODE_COMBINATIONS GC
, GL_ENCUMBRANCE_TYPES EN
, PAY_EXTERNAL_ACCOUNTS PB
WHERE FH.FORECAST_HEADER_ID = CL.FORECAST_HEADER_ID
AND FC.FORECAST_ID = CL.FORECAST_ID
AND FR.FORECAST_ROW_ID = CL.FORECAST_ROW_ID
AND CO.FORECAST_COLUMN_ID = CL.FORECAST_COLUMN_ID
AND L1.LOOKUP_TYPE = 'FORECAST_TRX_TYPE'
AND L1.LOOKUP_CODE = FR.TRX_TYPE
AND SB.SET_OF_BOOKS_ID (+) = FR.SET_OF_BOOKS_ID
AND BA.BANK_ACCOUNT_ID (+) = FR.BANK_ACCOUNT_ID
AND RM.RECEIPT_METHOD_ID (+) = FR.RECEIPT_METHOD_ID
AND CP.PROFILE_CLASS_ID (+) = FR.CUSTOMER_PROFILE_CLASS_ID
AND PM.ORG_PAYMENT_METHOD_ID (+) = FR.ORG_PAYMENT_METHOD_ID
AND RL.LOOKUP_TYPE (+) = 'YES/NO'
AND RL.LOOKUP_CODE (+) = FR.INCLUDE_DISPUTE_FLAG
AND OL.LOOKUP_TYPE (+) = 'ASL_STATUS'
AND OL.LOOKUP_CODE (+) = FR.AUTHORIZATION_STATUS
AND L2.LOOKUP_TYPE (+) = 'FORECAST_ROLL_FORWARD_TYPE'
AND L2.LOOKUP_CODE (+) = FR.ROLL_FORWARD_TYPE
AND L3.LOOKUP_TYPE (+) = 'FORECAST_ORDER_STATUS'
AND L3.LOOKUP_CODE (+) = FR.ORDER_STATUS
AND L4.LOOKUP_TYPE (+) = 'FORECAST_ORDER_DATE_TYPE'
AND L4.LOOKUP_CODE (+) = FR.ORDER_DATE_TYPE
AND L5.LOOKUP_TYPE (+) = 'FORECAST_DISCOUNT_OPTION'
AND L5.LOOKUP_CODE (+) = FR.DISCOUNT_OPTION
AND L6.LOOKUP_TYPE (+) = 'FORECAST_METHOD'
AND L6.LOOKUP_CODE (+) = FR.FORECAST_METHOD
AND PA.PAYROLL_ID (+) = FR.PAYROLL_ID
AND OG.ORGANIZATION_ID (+) = PA.BUSINESS_GROUP_ID
AND OI.ORGANIZATION_ID (+) = OG.ORGANIZATION_ID
AND OI.ORG_INFORMATION_CONTEXT (+) = 'BUSINESS GROUP INFORMATION'
AND GC.CODE_COMBINATION_ID (+) = FR.CODE_COMBINATION_ID
AND EN.ENCUMBRANCE_TYPE_ID (+) = FR.ENCUMBRANCE_TYPE_ID
AND PB.EXTERNAL_ACCOUNT_ID (+) = FR.BANK_ACCOUNT_ID
AND CO.FORECAST_HEADER_ID = FH.FORECAST_HEADER_ID
AND FH.FORECAST_HEADER_ID = FC.FORECAST_HEADER_ID
AND NVL(FH.AGING_TYPE
, 'D') = 'D' WITH READ ONLY

Columns