select BANK_ACCOUNT_NAME, BUDGET_NAME, BUDGET_TYPE_NAME,rtrim(
DECODE(CF.CODE_COMBINATION_ID,NULL,NULL,&P_FLEXDATA ),'--') C_FLEXDATA, rtrim(
DECODE(CF.CRITERIA_CATEGORY, NULL, NULL, &P_CRITERIA),'--') C_CRITERIA,
bvl.meaning BUDGET_VER, CHANNEL_CODE,
CF.CHART_OF_ACCOUNTS_ID, CF.CODE_COMBINATION_ID,
CUSTOMER_PROFILE_CLASS_NAME,
CF.DESCRIPTION,
dol.meaning DISCOUNT_OPT,
ENCUMBRANCE_TYPE, EXTERNAL_SOURCE_TYPE, FORECAST_HEADER_ID FORECAST_HEADER_ID3, fml.meaning FC_METHOD,
DECODE(INCLUDE_DISPUTE_FLAG, 'Y','Y',NULL) INC_DISPUTE,
DECODE(INCLUDE_HOLD_FLAG, 'Y','Y',NULL) INC_HOLD,
DECODE(INCLUDE_NET_CASH_FLAG, 'Y','Y',NULL) INC_NET_CASH,
DECODE(EXCLUDE_INDIC_EXP,'Y','Y',NULL) EX_INDIC_EXP,
LEAD_TIME, odtl.meaning ORD_DATE_TYPE, DECODE(TRX_TYPE, 'OEO', oel.meaning, 'ASF', asl.meaning, 'POP',pol.meaning,'POR',pol.meaning, null) STATUS, DECODE(TRX_TYPE, 'XTR', COMPANY_CODE,ORG_NAME) ORG_NAME, PAYMENT_METHOD, PAYMENT_PRIORITY, PAYROLL_NAME, PAY_GROUP, RECEIPT_METHOD_NAME, ROLL_FORWARD_PERIOD, rftl.meaning ROLL_F_TYPE, ROW_NUMBER, SALES_STAGE_NAME, SET_OF_BOOKS_NAME, TRX_TYPE_DSP, TYPE_NAME TYP, VENDOR_TYPE, WIN_PROBABILITY
from CE_FORECAST_ROWS_V CF,
GL_CODE_COMBINATIONS GLCC, ce_lookups asl, ce_lookups oel, ce_lookups pol, ce_lookups dol, ce_lookups rftl, ce_lookups odtl, ce_lookups fml, ce_lookups bvl
where GLCC.CHART_OF_ACCOUNTS_ID(+)= CF.CHART_OF_ACCOUNTS_ID
and GLCC.code_combination_id(+) = CF.code_combination_id
and asl.lookup_code(+) = CF.sales_forecast_status
and asl.lookup_type(+) = 'SALES_FORECAST_STATUS'
and oel.lookup_code(+) = CF.order_status
and oel.lookup_type(+) = 'ORDER_STATUS'
and pol.lookup_code(+) = CF.authorization_status
and pol.lookup_type(+) = 'AUTHORIZATION STATUS'
and dol.lookup_code(+) = DISCOUNT_OPTION
and dol.lookup_type(+) = 'FORECAST_DISC_OPTION'
and rftl.lookup_code(+) = ROLL_FORWARD_TYPE
and rftl.lookup_type(+) = 'FORECAST_ROLL_FORWARD_TYPE'
and odtl.lookup_code(+) = ORDER_DATE_TYPE
and odtl.lookup_type(+) = 'FORECAST_ORDER_DATE_TYPE'
and bvl.lookup_code(+) = BUDGET_VERSION
and bvl.lookup_type(+) = 'FORECAST_PA_BUDGET_VSN'
and fml.lookup_code(+) = FORECAST_METHOD
and fml.lookup_type(+) = 'FORECAST_METHOD'
and FORECAST_HEADER_ID=:fhid2
order by ROW_NUMBER |