Id RecordName MTQ_ICM_PPH_OBJ_Id_c ParentRecordName ParentRecordNumber RecordNumber CurrencyCode BBConversionFactorHCToLHC_c BBHomeCurrency_c BBInHomeCurrency_c BBInLatestHomeCurrency_c BBInMultiCurrency_c BBLatestHomeCurrency_c MultiCurrencyScenario_c PTDEarningsConversionFactorHCToLHC_c PTDEarningsHomeCurrency_c PTDEarningsInHomeCurrency_c PTDEarningsInLatestHomeCurrency_c PTDEarningsLatestHomeCurrency_c PTDInMulticurrency_c PayrunId_c PaymentBatchPeriod_c PeriodId_c
dev7 from eror
select rules.* , -- BBAction_c DECODE(Rule_Number, 1, 'MAV_DIR_BB_ACTION_1000', 2, 'MAV_DIR_BB_ACTION_1003', 3, 'MAV_DIR_BB_ACTION_1001', 4, 'MAV_DIR_BB_ACTION_1003', 5, 'MAV_DIR_BB_ACTION_1003', 6, 'MAV_DIR_BB_ACTION_1003', 7, 'MAV_DIR_BB_ACTION_1003', 8, 'MAV_DIR_BB_ACTION_1003', 9, 'MAV_DIR_BB_ACTION_1003', 10, 'MAV_DIR_BB_ACTION_1003', 99, 'MAV_DIR_BB_ACTION_1002', 11 , 'MAV_DIR_BB_ACTION_1002', -- Pre-approved zero BB for active sale rep NULL ) AS "BBAction_c", -- BBReasonCode_c DECODE(Rule_Number, 1, 'MVA_DIR_BB_REASON_1018', 2, 'MVA_DIR_BB_REASON_1001', 3, 'MVA_DIR_BB_REASON_1018', 4, 'MVA_DIR_BB_REASON_1001', 5, 'MVA_DIR_BB_REASON_1001', 6, 'MVA_DI...
Comments
Post a Comment