VIEW: APPS.CE_FORECAST_ROWS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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