[Home] [Help]
3245: , '0-1' , fact.raw_cost
3246: , '1-1' , fact.raw_cost
3247: , 0 ) -- end decode
3248: , 0 ) -- end nvl
3249: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3250: * PJI_UTILS.GET_MAU (fact.currency_code) raw_cost
3251: , ROUND (
3252: NVL (
3253: DECODE (
3246: , '1-1' , fact.raw_cost
3247: , 0 ) -- end decode
3248: , 0 ) -- end nvl
3249: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3250: * PJI_UTILS.GET_MAU (fact.currency_code) raw_cost
3251: , ROUND (
3252: NVL (
3253: DECODE (
3254: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3262: , '0-1' , fact.brdn_cost
3263: , '1-1' , fact.brdn_cost
3264: , 0 ) -- end decode
3265: , 0 ) -- end nvl
3266: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3267: * PJI_UTILS.GET_MAU (fact.currency_code) brdn_cost
3268: , ROUND (
3269: NVL (
3270: DECODE (
3263: , '1-1' , fact.brdn_cost
3264: , 0 ) -- end decode
3265: , 0 ) -- end nvl
3266: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3267: * PJI_UTILS.GET_MAU (fact.currency_code) brdn_cost
3268: , ROUND (
3269: NVL (
3270: DECODE (
3271: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3279: , '0-1' , fact.revenue
3280: , '1-1' , fact.revenue
3281: , 0 ) -- end decode
3282: , 0 ) -- end nvl
3283: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3284: * PJI_UTILS.GET_MAU (fact.currency_code) revenue
3285: , ROUND (
3286: NVL (
3287: DECODE (
3280: , '1-1' , fact.revenue
3281: , 0 ) -- end decode
3282: , 0 ) -- end nvl
3283: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3284: * PJI_UTILS.GET_MAU (fact.currency_code) revenue
3285: , ROUND (
3286: NVL (
3287: DECODE (
3288: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3296: , '0-1' , fact.bill_raw_cost
3297: , '1-1' , fact.bill_raw_cost
3298: , 0 ) -- end decode
3299: , 0 ) -- end nvl
3300: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3301: * PJI_UTILS.GET_MAU (fact.currency_code) bill_raw_cost
3302: , ROUND (
3303: NVL (
3304: DECODE (
3297: , '1-1' , fact.bill_raw_cost
3298: , 0 ) -- end decode
3299: , 0 ) -- end nvl
3300: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3301: * PJI_UTILS.GET_MAU (fact.currency_code) bill_raw_cost
3302: , ROUND (
3303: NVL (
3304: DECODE (
3305: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3313: , '0-1' , fact.bill_brdn_cost
3314: , '1-1' , fact.bill_brdn_cost
3315: , 0 ) -- end decode
3316: , 0 ) -- end nvl
3317: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3318: * PJI_UTILS.GET_MAU (fact.currency_code) bill_brdn_cost
3319: , ROUND (
3320: NVL (
3321: DECODE (
3314: , '1-1' , fact.bill_brdn_cost
3315: , 0 ) -- end decode
3316: , 0 ) -- end nvl
3317: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3318: * PJI_UTILS.GET_MAU (fact.currency_code) bill_brdn_cost
3319: , ROUND (
3320: NVL (
3321: DECODE (
3322: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3330: , '0-1' , fact.bill_labor_raw_cost
3331: , '1-1' , fact.bill_labor_raw_cost
3332: , 0 ) -- end decode
3333: , 0 ) -- end nvl
3334: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3335: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_raw_cost
3336: , ROUND (
3337: NVL (
3338: DECODE (
3331: , '1-1' , fact.bill_labor_raw_cost
3332: , 0 ) -- end decode
3333: , 0 ) -- end nvl
3334: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3335: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_raw_cost
3336: , ROUND (
3337: NVL (
3338: DECODE (
3339: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3347: , '0-1' , fact.bill_labor_brdn_cost
3348: , '1-1' , fact.bill_labor_brdn_cost
3349: , 0 ) -- end decode
3350: , 0 ) -- end nvl
3351: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3352: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_brdn_cost
3353: , ROUND (
3354: NVL (
3355: DECODE (
3348: , '1-1' , fact.bill_labor_brdn_cost
3349: , 0 ) -- end decode
3350: , 0 ) -- end nvl
3351: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3352: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_brdn_cost
3353: , ROUND (
3354: NVL (
3355: DECODE (
3356: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3364: , '0-1' , fact.bill_labor_hrs
3365: , '1-1' , fact.bill_labor_hrs
3366: , 0 ) -- end decode
3367: , 0 ) -- end nvl
3368: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3369: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_hrs
3370: , ROUND (
3371: NVL (
3372: DECODE (
3365: , '1-1' , fact.bill_labor_hrs
3366: , 0 ) -- end decode
3367: , 0 ) -- end nvl
3368: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3369: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_hrs
3370: , ROUND (
3371: NVL (
3372: DECODE (
3373: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3381: , '0-1' , fact.equipment_raw_cost
3382: , '1-1' , fact.equipment_raw_cost
3383: , 0 ) -- end decode
3384: , 0 ) -- end nvl
3385: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3386: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_raw_cost
3387: , ROUND (
3388: NVL (
3389: DECODE (
3382: , '1-1' , fact.equipment_raw_cost
3383: , 0 ) -- end decode
3384: , 0 ) -- end nvl
3385: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3386: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_raw_cost
3387: , ROUND (
3388: NVL (
3389: DECODE (
3390: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3398: , '0-1' , fact.equipment_brdn_cost
3399: , '1-1' , fact.equipment_brdn_cost
3400: , 0 ) -- end decode
3401: , 0 ) -- end nvl
3402: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3403: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_brdn_cost
3404: , ROUND (
3405: NVL (
3406: DECODE (
3399: , '1-1' , fact.equipment_brdn_cost
3400: , 0 ) -- end decode
3401: , 0 ) -- end nvl
3402: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3403: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_brdn_cost
3404: , ROUND (
3405: NVL (
3406: DECODE (
3407: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3415: , '0-1' , fact.capitalizable_raw_cost
3416: , '1-1' , fact.capitalizable_raw_cost
3417: , 0 ) -- end decode
3418: , 0 ) -- end nvl
3419: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3420: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_raw_cost
3421: , ROUND (
3422: NVL (
3423: DECODE (
3416: , '1-1' , fact.capitalizable_raw_cost
3417: , 0 ) -- end decode
3418: , 0 ) -- end nvl
3419: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3420: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_raw_cost
3421: , ROUND (
3422: NVL (
3423: DECODE (
3424: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3432: , '0-1' , fact.capitalizable_brdn_cost
3433: , '1-1' , fact.capitalizable_brdn_cost
3434: , 0 ) -- end decode
3435: , 0 ) -- end nvl
3436: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3437: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_brdn_cost
3438: , ROUND (
3439: NVL (
3440: DECODE (
3433: , '1-1' , fact.capitalizable_brdn_cost
3434: , 0 ) -- end decode
3435: , 0 ) -- end nvl
3436: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3437: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_brdn_cost
3438: , ROUND (
3439: NVL (
3440: DECODE (
3441: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3449: , '0-1' , fact.labor_raw_cost
3450: , '1-1' , fact.labor_raw_cost
3451: , 0 ) -- end decode
3452: , 0 ) -- end nvl
3453: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3454: * PJI_UTILS.GET_MAU (fact.currency_code) labor_raw_cost
3455: , ROUND (
3456: NVL (
3457: DECODE (
3450: , '1-1' , fact.labor_raw_cost
3451: , 0 ) -- end decode
3452: , 0 ) -- end nvl
3453: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3454: * PJI_UTILS.GET_MAU (fact.currency_code) labor_raw_cost
3455: , ROUND (
3456: NVL (
3457: DECODE (
3458: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3466: , '0-1' , fact.labor_brdn_cost
3467: , '1-1' , fact.labor_brdn_cost
3468: , 0 ) -- end decode
3469: , 0 ) -- end nvl
3470: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3471: * PJI_UTILS.GET_MAU (fact.currency_code) labor_brdn_cost
3472: , ROUND (
3473: NVL (
3474: DECODE (
3467: , '1-1' , fact.labor_brdn_cost
3468: , 0 ) -- end decode
3469: , 0 ) -- end nvl
3470: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3471: * PJI_UTILS.GET_MAU (fact.currency_code) labor_brdn_cost
3472: , ROUND (
3473: NVL (
3474: DECODE (
3475: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3483: , '0-1' , fact.labor_hrs
3484: , '1-1' , fact.labor_hrs
3485: , 0 ) -- end decode
3486: , 0 ) -- end nvl
3487: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3488: * PJI_UTILS.GET_MAU (fact.currency_code) labor_hrs
3489: , ROUND (
3490: NVL (
3491: DECODE (
3484: , '1-1' , fact.labor_hrs
3485: , 0 ) -- end decode
3486: , 0 ) -- end nvl
3487: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3488: * PJI_UTILS.GET_MAU (fact.currency_code) labor_hrs
3489: , ROUND (
3490: NVL (
3491: DECODE (
3492: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3500: , '0-1' , fact.labor_revenue
3501: , '1-1' , fact.labor_revenue
3502: , 0 ) -- end decode
3503: , 0 ) -- end nvl
3504: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3505: * PJI_UTILS.GET_MAU (fact.currency_code) labor_revenue
3506: , ROUND (
3507: NVL (
3508: DECODE (
3501: , '1-1' , fact.labor_revenue
3502: , 0 ) -- end decode
3503: , 0 ) -- end nvl
3504: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3505: * PJI_UTILS.GET_MAU (fact.currency_code) labor_revenue
3506: , ROUND (
3507: NVL (
3508: DECODE (
3509: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3517: , '0-1' , fact.equipment_hours
3518: , '1-1' , fact.equipment_hours
3519: , 0 ) -- end decode
3520: , 0 ) -- end nvl
3521: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3522: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_hours
3523: , ROUND (
3524: NVL (
3525: DECODE (
3518: , '1-1' , fact.equipment_hours
3519: , 0 ) -- end decode
3520: , 0 ) -- end nvl
3521: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3522: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_hours
3523: , ROUND (
3524: NVL (
3525: DECODE (
3526: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3534: , '0-1' , fact.billable_equipment_hours
3535: , '1-1' , fact.billable_equipment_hours
3536: , 0 ) -- end decode
3537: , 0 ) -- end nvl
3538: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3539: * PJI_UTILS.GET_MAU (fact.currency_code) billable_equipment_hours
3540: , ROUND (
3541: NVL (
3542: DECODE (
3535: , '1-1' , fact.billable_equipment_hours
3536: , 0 ) -- end decode
3537: , 0 ) -- end nvl
3538: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3539: * PJI_UTILS.GET_MAU (fact.currency_code) billable_equipment_hours
3540: , ROUND (
3541: NVL (
3542: DECODE (
3543: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3551: , '0-1' , fact.sup_inv_committed_cost
3552: , '1-1' , fact.sup_inv_committed_cost
3553: , 0 ) -- end decode
3554: , 0 ) -- end nvl
3555: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3556: * PJI_UTILS.GET_MAU (fact.currency_code) sup_inv_committed_cost
3557: , ROUND (
3558: NVL (
3559: DECODE (
3552: , '1-1' , fact.sup_inv_committed_cost
3553: , 0 ) -- end decode
3554: , 0 ) -- end nvl
3555: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3556: * PJI_UTILS.GET_MAU (fact.currency_code) sup_inv_committed_cost
3557: , ROUND (
3558: NVL (
3559: DECODE (
3560: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3568: , '0-1' , fact.po_committed_cost
3569: , '1-1' , fact.po_committed_cost
3570: , 0 ) -- end decode
3571: , 0 ) -- end nvl
3572: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3573: * PJI_UTILS.GET_MAU (fact.currency_code) po_committed_cost
3574: , ROUND (
3575: NVL (
3576: DECODE (
3569: , '1-1' , fact.po_committed_cost
3570: , 0 ) -- end decode
3571: , 0 ) -- end nvl
3572: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3573: * PJI_UTILS.GET_MAU (fact.currency_code) po_committed_cost
3574: , ROUND (
3575: NVL (
3576: DECODE (
3577: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3585: , '0-1' , fact.pr_committed_cost
3586: , '1-1' , fact.pr_committed_cost
3587: , 0 ) -- end decode
3588: , 0 ) -- end nvl
3589: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3590: * PJI_UTILS.GET_MAU (fact.currency_code) pr_committed_cost
3591: , ROUND (
3592: NVL (
3593: DECODE (
3586: , '1-1' , fact.pr_committed_cost
3587: , 0 ) -- end decode
3588: , 0 ) -- end nvl
3589: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3590: * PJI_UTILS.GET_MAU (fact.currency_code) pr_committed_cost
3591: , ROUND (
3592: NVL (
3593: DECODE (
3594: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3602: , '0-1' , fact.oth_committed_cost
3603: , '1-1' , fact.oth_committed_cost
3604: , 0 ) -- end decode
3605: , 0 ) -- end nvl
3606: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3607: * PJI_UTILS.GET_MAU (fact.currency_code) oth_committed_cost
3608: , ROUND (
3609: NVL (
3610: DECODE (
3603: , '1-1' , fact.oth_committed_cost
3604: , 0 ) -- end decode
3605: , 0 ) -- end nvl
3606: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3607: * PJI_UTILS.GET_MAU (fact.currency_code) oth_committed_cost
3608: , ROUND (
3609: NVL (
3610: DECODE (
3611: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3619: , '0-1' , fact.ACT_LABOR_HRS
3620: , '1-1' , fact.ACT_LABOR_HRS
3621: , 0 ) -- end decode
3622: , 0 ) -- end nvl
3623: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3624: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_HRS
3625: , ROUND (
3626: NVL (
3627: DECODE (
3620: , '1-1' , fact.ACT_LABOR_HRS
3621: , 0 ) -- end decode
3622: , 0 ) -- end nvl
3623: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3624: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_HRS
3625: , ROUND (
3626: NVL (
3627: DECODE (
3628: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3636: , '0-1' , fact.ACT_EQUIP_HRS
3637: , '1-1' , fact.ACT_EQUIP_HRS
3638: , 0 ) -- end decode
3639: , 0 ) -- end nvl
3640: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3641: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_HRS
3642: , ROUND (
3643: NVL (
3644: DECODE (
3637: , '1-1' , fact.ACT_EQUIP_HRS
3638: , 0 ) -- end decode
3639: , 0 ) -- end nvl
3640: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3641: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_HRS
3642: , ROUND (
3643: NVL (
3644: DECODE (
3645: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3653: , '0-1' , fact.ACT_LABOR_BRDN_COST
3654: , '1-1' , fact.ACT_LABOR_BRDN_COST
3655: , 0 ) -- end decode
3656: , 0 ) -- end nvl
3657: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3658: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_BRDN_COST
3659: , ROUND (
3660: NVL (
3661: DECODE (
3654: , '1-1' , fact.ACT_LABOR_BRDN_COST
3655: , 0 ) -- end decode
3656: , 0 ) -- end nvl
3657: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3658: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_BRDN_COST
3659: , ROUND (
3660: NVL (
3661: DECODE (
3662: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3670: , '0-1' , fact.ACT_EQUIP_BRDN_COST
3671: , '1-1' , fact.ACT_EQUIP_BRDN_COST
3672: , 0 ) -- end decode
3673: , 0 ) -- end nvl
3674: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3675: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_BRDN_COST
3676: , ROUND (
3677: NVL (
3678: DECODE (
3671: , '1-1' , fact.ACT_EQUIP_BRDN_COST
3672: , 0 ) -- end decode
3673: , 0 ) -- end nvl
3674: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3675: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_BRDN_COST
3676: , ROUND (
3677: NVL (
3678: DECODE (
3679: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3687: , '0-1' , fact.ACT_BRDN_COST
3688: , '1-1' , fact.ACT_BRDN_COST
3689: , 0 ) -- end decode
3690: , 0 ) -- end nvl
3691: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3692: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_BRDN_COST
3693: , ROUND (
3694: NVL (
3695: DECODE (
3688: , '1-1' , fact.ACT_BRDN_COST
3689: , 0 ) -- end decode
3690: , 0 ) -- end nvl
3691: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3692: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_BRDN_COST
3693: , ROUND (
3694: NVL (
3695: DECODE (
3696: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3704: , '0-1' , fact.ACT_RAW_COST
3705: , '1-1' , fact.ACT_RAW_COST
3706: , 0 ) -- end decode
3707: , 0 ) -- end nvl
3708: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3709: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_RAW_COST
3710: , ROUND (
3711: NVL (
3712: DECODE (
3705: , '1-1' , fact.ACT_RAW_COST
3706: , 0 ) -- end decode
3707: , 0 ) -- end nvl
3708: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3709: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_RAW_COST
3710: , ROUND (
3711: NVL (
3712: DECODE (
3713: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3721: , '0-1' , fact.ACT_REVENUE
3722: , '1-1' , fact.ACT_REVENUE
3723: , 0 ) -- end decode
3724: , 0 ) -- end nvl
3725: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3726: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_REVENUE
3727: , ROUND (
3728: NVL (
3729: DECODE (
3722: , '1-1' , fact.ACT_REVENUE
3723: , 0 ) -- end decode
3724: , 0 ) -- end nvl
3725: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3726: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_REVENUE
3727: , ROUND (
3728: NVL (
3729: DECODE (
3730: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3738: , '0-1' , fact.ACT_LABOR_RAW_COST
3739: , '1-1' , fact.ACT_LABOR_RAW_COST
3740: , 0 ) -- end decode
3741: , 0 ) -- end nvl
3742: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3743: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_RAW_COST
3744: , ROUND (
3745: NVL (
3746: DECODE (
3739: , '1-1' , fact.ACT_LABOR_RAW_COST
3740: , 0 ) -- end decode
3741: , 0 ) -- end nvl
3742: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3743: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_RAW_COST
3744: , ROUND (
3745: NVL (
3746: DECODE (
3747: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3755: , '0-1' , fact.ACT_EQUIP_RAW_COST
3756: , '1-1' , fact.ACT_EQUIP_RAW_COST
3757: , 0 ) -- end decode
3758: , 0 ) -- end nvl
3759: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3760: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_RAW_COST
3761: , ROUND (
3762: NVL (
3763: DECODE (
3756: , '1-1' , fact.ACT_EQUIP_RAW_COST
3757: , 0 ) -- end decode
3758: , 0 ) -- end nvl
3759: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3760: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_RAW_COST
3761: , ROUND (
3762: NVL (
3763: DECODE (
3764: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3772: , '0-1' , fact.ETC_LABOR_HRS
3773: , '1-1' , fact.ETC_LABOR_HRS
3774: , 0 ) -- end decode
3775: , 0 ) -- end nvl
3776: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3777: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_HRS
3778: , ROUND (
3779: NVL (
3780: DECODE (
3773: , '1-1' , fact.ETC_LABOR_HRS
3774: , 0 ) -- end decode
3775: , 0 ) -- end nvl
3776: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3777: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_HRS
3778: , ROUND (
3779: NVL (
3780: DECODE (
3781: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3789: , '0-1' , fact.ETC_EQUIP_HRS
3790: , '1-1' , fact.ETC_EQUIP_HRS
3791: , 0 ) -- end decode
3792: , 0 ) -- end nvl
3793: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3794: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_HRS
3795: , ROUND (
3796: NVL (
3797: DECODE (
3790: , '1-1' , fact.ETC_EQUIP_HRS
3791: , 0 ) -- end decode
3792: , 0 ) -- end nvl
3793: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3794: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_HRS
3795: , ROUND (
3796: NVL (
3797: DECODE (
3798: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3806: , '0-1' , fact.ETC_LABOR_BRDN_COST
3807: , '1-1' , fact.ETC_LABOR_BRDN_COST
3808: , 0 ) -- end decode
3809: , 0 ) -- end nvl
3810: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3811: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_BRDN_COST
3812: , ROUND (
3813: NVL (
3814: DECODE (
3807: , '1-1' , fact.ETC_LABOR_BRDN_COST
3808: , 0 ) -- end decode
3809: , 0 ) -- end nvl
3810: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3811: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_BRDN_COST
3812: , ROUND (
3813: NVL (
3814: DECODE (
3815: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3823: , '0-1' , fact.ETC_EQUIP_BRDN_COST
3824: , '1-1' , fact.ETC_EQUIP_BRDN_COST
3825: , 0 ) -- end decode
3826: , 0 ) -- end nvl
3827: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3828: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_BRDN_COST
3829: , ROUND (
3830: NVL (
3831: DECODE (
3824: , '1-1' , fact.ETC_EQUIP_BRDN_COST
3825: , 0 ) -- end decode
3826: , 0 ) -- end nvl
3827: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3828: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_BRDN_COST
3829: , ROUND (
3830: NVL (
3831: DECODE (
3832: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3840: , '0-1' , fact.ETC_BRDN_COST
3841: , '1-1' , fact.ETC_BRDN_COST
3842: , 0 ) -- end decode
3843: , 0 ) -- end nvl
3844: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3845: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_BRDN_COST
3846: , ROUND (
3847: NVL (
3848: DECODE (
3841: , '1-1' , fact.ETC_BRDN_COST
3842: , 0 ) -- end decode
3843: , 0 ) -- end nvl
3844: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3845: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_BRDN_COST
3846: , ROUND (
3847: NVL (
3848: DECODE (
3849: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3857: , '0-1' , fact.ETC_RAW_COST
3858: , '1-1' , fact.ETC_RAW_COST
3859: , 0 ) -- end decode
3860: , 0 ) -- end nvl
3861: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3862: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_RAW_COST
3863: , ROUND (
3864: NVL (
3865: DECODE (
3858: , '1-1' , fact.ETC_RAW_COST
3859: , 0 ) -- end decode
3860: , 0 ) -- end nvl
3861: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3862: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_RAW_COST
3863: , ROUND (
3864: NVL (
3865: DECODE (
3866: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3874: , '0-1' , fact.ETC_LABOR_RAW_COST
3875: , '1-1' , fact.ETC_LABOR_RAW_COST
3876: , 0 ) -- end decode
3877: , 0 ) -- end nvl
3878: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3879: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_RAW_COST
3880: , ROUND (
3881: NVL (
3882: DECODE (
3875: , '1-1' , fact.ETC_LABOR_RAW_COST
3876: , 0 ) -- end decode
3877: , 0 ) -- end nvl
3878: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3879: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_RAW_COST
3880: , ROUND (
3881: NVL (
3882: DECODE (
3883: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3891: , '0-1' , fact.ETC_EQUIP_RAW_COST
3892: , '1-1' , fact.ETC_EQUIP_RAW_COST
3893: , 0 ) -- end decode
3894: , 0 ) -- end nvl
3895: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3896: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_RAW_COST
3897: , ROUND (
3898: NVL (
3899: DECODE (
3892: , '1-1' , fact.ETC_EQUIP_RAW_COST
3893: , 0 ) -- end decode
3894: , 0 ) -- end nvl
3895: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3896: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_RAW_COST
3897: , ROUND (
3898: NVL (
3899: DECODE (
3900: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3908: , '0-1' , fact.custom1
3909: , '1-1' , fact.custom1
3910: , 0 ) -- end decode
3911: , 0 ) -- end nvl
3912: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3913: * PJI_UTILS.GET_MAU (fact.currency_code) custom1
3914: , ROUND (
3915: NVL (
3916: DECODE (
3909: , '1-1' , fact.custom1
3910: , 0 ) -- end decode
3911: , 0 ) -- end nvl
3912: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3913: * PJI_UTILS.GET_MAU (fact.currency_code) custom1
3914: , ROUND (
3915: NVL (
3916: DECODE (
3917: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3925: , '0-1' , fact.custom2
3926: , '1-1' , fact.custom2
3927: , 0 ) -- end decode
3928: , 0 ) -- end nvl
3929: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3930: * PJI_UTILS.GET_MAU (fact.currency_code) custom2
3931: , ROUND (
3932: NVL (
3933: DECODE (
3926: , '1-1' , fact.custom2
3927: , 0 ) -- end decode
3928: , 0 ) -- end nvl
3929: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3930: * PJI_UTILS.GET_MAU (fact.currency_code) custom2
3931: , ROUND (
3932: NVL (
3933: DECODE (
3934: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3942: , '0-1' , fact.custom3
3943: , '1-1' , fact.custom3
3944: , 0 ) -- end decode
3945: , 0 ) -- end nvl
3946: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3947: * PJI_UTILS.GET_MAU (fact.currency_code) custom3
3948: , ROUND (
3949: NVL (
3950: DECODE (
3943: , '1-1' , fact.custom3
3944: , 0 ) -- end decode
3945: , 0 ) -- end nvl
3946: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3947: * PJI_UTILS.GET_MAU (fact.currency_code) custom3
3948: , ROUND (
3949: NVL (
3950: DECODE (
3951: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3959: , '0-1' , fact.custom4
3960: , '1-1' , fact.custom4
3961: , 0 ) -- end decode
3962: , 0 ) -- end nvl
3963: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3964: * PJI_UTILS.GET_MAU (fact.currency_code) custom4
3965: , ROUND (
3966: NVL (
3967: DECODE (
3960: , '1-1' , fact.custom4
3961: , 0 ) -- end decode
3962: , 0 ) -- end nvl
3963: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3964: * PJI_UTILS.GET_MAU (fact.currency_code) custom4
3965: , ROUND (
3966: NVL (
3967: DECODE (
3968: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3976: , '0-1' , fact.custom5
3977: , '1-1' , fact.custom5
3978: , 0 ) -- end decode
3979: , 0 ) -- end nvl
3980: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3981: * PJI_UTILS.GET_MAU (fact.currency_code) custom5
3982: , ROUND (
3983: NVL (
3984: DECODE (
3977: , '1-1' , fact.custom5
3978: , 0 ) -- end decode
3979: , 0 ) -- end nvl
3980: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3981: * PJI_UTILS.GET_MAU (fact.currency_code) custom5
3982: , ROUND (
3983: NVL (
3984: DECODE (
3985: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
3993: , '0-1' , fact.custom6
3994: , '1-1' , fact.custom6
3995: , 0 ) -- end decode
3996: , 0 ) -- end nvl
3997: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3998: * PJI_UTILS.GET_MAU (fact.currency_code) custom6
3999: , ROUND (
4000: NVL (
4001: DECODE (
3994: , '1-1' , fact.custom6
3995: , 0 ) -- end decode
3996: , 0 ) -- end nvl
3997: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3998: * PJI_UTILS.GET_MAU (fact.currency_code) custom6
3999: , ROUND (
4000: NVL (
4001: DECODE (
4002: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4010: , '0-1' , fact.custom7
4011: , '1-1' , fact.custom7
4012: , 0 ) -- end decode
4013: , 0 ) -- end nvl
4014: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4015: * PJI_UTILS.GET_MAU (fact.currency_code) custom7
4016: , ROUND (
4017: NVL (
4018: DECODE (
4011: , '1-1' , fact.custom7
4012: , 0 ) -- end decode
4013: , 0 ) -- end nvl
4014: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4015: * PJI_UTILS.GET_MAU (fact.currency_code) custom7
4016: , ROUND (
4017: NVL (
4018: DECODE (
4019: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4027: , '0-1' , fact.custom8
4028: , '1-1' , fact.custom8
4029: , 0 ) -- end decode
4030: , 0 ) -- end nvl
4031: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4032: * PJI_UTILS.GET_MAU (fact.currency_code) custom8
4033: , ROUND (
4034: NVL (
4035: DECODE (
4028: , '1-1' , fact.custom8
4029: , 0 ) -- end decode
4030: , 0 ) -- end nvl
4031: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4032: * PJI_UTILS.GET_MAU (fact.currency_code) custom8
4033: , ROUND (
4034: NVL (
4035: DECODE (
4036: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4044: , '0-1' , fact.custom9
4045: , '1-1' , fact.custom9
4046: , 0 ) -- end decode
4047: , 0 ) -- end nvl
4048: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4049: * PJI_UTILS.GET_MAU (fact.currency_code) custom9
4050: , ROUND (
4051: NVL (
4052: DECODE (
4045: , '1-1' , fact.custom9
4046: , 0 ) -- end decode
4047: , 0 ) -- end nvl
4048: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4049: * PJI_UTILS.GET_MAU (fact.currency_code) custom9
4050: , ROUND (
4051: NVL (
4052: DECODE (
4053: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4061: , '0-1' , fact.custom10
4062: , '1-1' , fact.custom10
4063: , 0 ) -- end decode
4064: , 0 ) -- end nvl
4065: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4066: * PJI_UTILS.GET_MAU (fact.currency_code) custom10
4067: , ROUND (
4068: NVL (
4069: DECODE (
4062: , '1-1' , fact.custom10
4063: , 0 ) -- end decode
4064: , 0 ) -- end nvl
4065: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4066: * PJI_UTILS.GET_MAU (fact.currency_code) custom10
4067: , ROUND (
4068: NVL (
4069: DECODE (
4070: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4078: , '0-1' , fact.custom11
4079: , '1-1' , fact.custom11
4080: , 0 ) -- end decode
4081: , 0 ) -- end nvl
4082: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4083: * PJI_UTILS.GET_MAU (fact.currency_code) custom11
4084: , ROUND (
4085: NVL (
4086: DECODE (
4079: , '1-1' , fact.custom11
4080: , 0 ) -- end decode
4081: , 0 ) -- end nvl
4082: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4083: * PJI_UTILS.GET_MAU (fact.currency_code) custom11
4084: , ROUND (
4085: NVL (
4086: DECODE (
4087: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4095: , '0-1' , fact.custom12
4096: , '1-1' , fact.custom12
4097: , 0 ) -- end decode
4098: , 0 ) -- end nvl
4099: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4100: * PJI_UTILS.GET_MAU (fact.currency_code) custom12
4101: , ROUND (
4102: NVL (
4103: DECODE (
4096: , '1-1' , fact.custom12
4097: , 0 ) -- end decode
4098: , 0 ) -- end nvl
4099: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4100: * PJI_UTILS.GET_MAU (fact.currency_code) custom12
4101: , ROUND (
4102: NVL (
4103: DECODE (
4104: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4112: , '0-1' , fact.custom13
4113: , '1-1' , fact.custom13
4114: , 0 ) -- end decode
4115: , 0 ) -- end nvl
4116: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4117: * PJI_UTILS.GET_MAU (fact.currency_code) custom13
4118: , ROUND (
4119: NVL (
4120: DECODE (
4113: , '1-1' , fact.custom13
4114: , 0 ) -- end decode
4115: , 0 ) -- end nvl
4116: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4117: * PJI_UTILS.GET_MAU (fact.currency_code) custom13
4118: , ROUND (
4119: NVL (
4120: DECODE (
4121: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4129: , '0-1' , fact.custom14
4130: , '1-1' , fact.custom14
4131: , 0 ) -- end decode
4132: , 0 ) -- end nvl
4133: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4134: * PJI_UTILS.GET_MAU (fact.currency_code) custom14
4135: , ROUND (
4136: NVL (
4137: DECODE (
4130: , '1-1' , fact.custom14
4131: , 0 ) -- end decode
4132: , 0 ) -- end nvl
4133: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4134: * PJI_UTILS.GET_MAU (fact.currency_code) custom14
4135: , ROUND (
4136: NVL (
4137: DECODE (
4138: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4146: , '0-1' , fact.custom15
4147: , '1-1' , fact.custom15
4148: , 0 ) -- end decode
4149: , 0 ) -- end nvl
4150: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4151: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
4152: , 'CF' line_type
4153: , fact.time_dangling_flag time_dangling_flag
4154: , fact.rate_dangling_flag rate_dangling_flag
4147: , '1-1' , fact.custom15
4148: , 0 ) -- end decode
4149: , 0 ) -- end nvl
4150: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4151: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
4152: , 'CF' line_type
4153: , fact.time_dangling_flag time_dangling_flag
4154: , fact.rate_dangling_flag rate_dangling_flag
4155: , g_default_prg_level prg_level
4679: , '0-1' , fact.raw_cost
4680: , '1-1' , fact.raw_cost
4681: , 0 ) -- end decode
4682: , 0 ) -- end nvl
4683: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4684: * PJI_UTILS.GET_MAU (fact.currency_code) raw_cost
4685: , ROUND (
4686: NVL (
4687: DECODE (
4680: , '1-1' , fact.raw_cost
4681: , 0 ) -- end decode
4682: , 0 ) -- end nvl
4683: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4684: * PJI_UTILS.GET_MAU (fact.currency_code) raw_cost
4685: , ROUND (
4686: NVL (
4687: DECODE (
4688: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4696: , '0-1' , fact.brdn_cost
4697: , '1-1' , fact.brdn_cost
4698: , 0 ) -- end decode
4699: , 0 ) -- end nvl
4700: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4701: * PJI_UTILS.GET_MAU (fact.currency_code) brdn_cost
4702: , ROUND (
4703: NVL (
4704: DECODE (
4697: , '1-1' , fact.brdn_cost
4698: , 0 ) -- end decode
4699: , 0 ) -- end nvl
4700: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4701: * PJI_UTILS.GET_MAU (fact.currency_code) brdn_cost
4702: , ROUND (
4703: NVL (
4704: DECODE (
4705: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4713: , '0-1' , fact.revenue
4714: , '1-1' , fact.revenue
4715: , 0 ) -- end decode
4716: , 0 ) -- end nvl
4717: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4718: * PJI_UTILS.GET_MAU (fact.currency_code) revenue
4719: , ROUND (
4720: NVL (
4721: DECODE (
4714: , '1-1' , fact.revenue
4715: , 0 ) -- end decode
4716: , 0 ) -- end nvl
4717: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4718: * PJI_UTILS.GET_MAU (fact.currency_code) revenue
4719: , ROUND (
4720: NVL (
4721: DECODE (
4722: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4730: , '0-1' , fact.bill_raw_cost
4731: , '1-1' , fact.bill_raw_cost
4732: , 0 ) -- end decode
4733: , 0 ) -- end nvl
4734: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4735: * PJI_UTILS.GET_MAU (fact.currency_code) bill_raw_cost
4736: , ROUND (
4737: NVL (
4738: DECODE (
4731: , '1-1' , fact.bill_raw_cost
4732: , 0 ) -- end decode
4733: , 0 ) -- end nvl
4734: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4735: * PJI_UTILS.GET_MAU (fact.currency_code) bill_raw_cost
4736: , ROUND (
4737: NVL (
4738: DECODE (
4739: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4747: , '0-1' , fact.bill_brdn_cost
4748: , '1-1' , fact.bill_brdn_cost
4749: , 0 ) -- end decode
4750: , 0 ) -- end nvl
4751: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4752: * PJI_UTILS.GET_MAU (fact.currency_code) bill_brdn_cost
4753: , ROUND (
4754: NVL (
4755: DECODE (
4748: , '1-1' , fact.bill_brdn_cost
4749: , 0 ) -- end decode
4750: , 0 ) -- end nvl
4751: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4752: * PJI_UTILS.GET_MAU (fact.currency_code) bill_brdn_cost
4753: , ROUND (
4754: NVL (
4755: DECODE (
4756: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4764: , '0-1' , fact.bill_labor_raw_cost
4765: , '1-1' , fact.bill_labor_raw_cost
4766: , 0 ) -- end decode
4767: , 0 ) -- end nvl
4768: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4769: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_raw_cost
4770: , ROUND (
4771: NVL (
4772: DECODE (
4765: , '1-1' , fact.bill_labor_raw_cost
4766: , 0 ) -- end decode
4767: , 0 ) -- end nvl
4768: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4769: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_raw_cost
4770: , ROUND (
4771: NVL (
4772: DECODE (
4773: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4781: , '0-1' , fact.bill_labor_brdn_cost
4782: , '1-1' , fact.bill_labor_brdn_cost
4783: , 0 ) -- end decode
4784: , 0 ) -- end nvl
4785: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4786: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_brdn_cost
4787: , ROUND (
4788: NVL (
4789: DECODE (
4782: , '1-1' , fact.bill_labor_brdn_cost
4783: , 0 ) -- end decode
4784: , 0 ) -- end nvl
4785: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4786: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_brdn_cost
4787: , ROUND (
4788: NVL (
4789: DECODE (
4790: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4798: , '0-1' , fact.bill_labor_hrs
4799: , '1-1' , fact.bill_labor_hrs
4800: , 0 ) -- end decode
4801: , 0 ) -- end nvl
4802: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4803: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_hrs
4804: , ROUND (
4805: NVL (
4806: DECODE (
4799: , '1-1' , fact.bill_labor_hrs
4800: , 0 ) -- end decode
4801: , 0 ) -- end nvl
4802: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4803: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_hrs
4804: , ROUND (
4805: NVL (
4806: DECODE (
4807: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4815: , '0-1' , fact.equipment_raw_cost
4816: , '1-1' , fact.equipment_raw_cost
4817: , 0 ) -- end decode
4818: , 0 ) -- end nvl
4819: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4820: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_raw_cost
4821: , ROUND (
4822: NVL (
4823: DECODE (
4816: , '1-1' , fact.equipment_raw_cost
4817: , 0 ) -- end decode
4818: , 0 ) -- end nvl
4819: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4820: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_raw_cost
4821: , ROUND (
4822: NVL (
4823: DECODE (
4824: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4832: , '0-1' , fact.equipment_brdn_cost
4833: , '1-1' , fact.equipment_brdn_cost
4834: , 0 ) -- end decode
4835: , 0 ) -- end nvl
4836: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4837: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_brdn_cost
4838: , ROUND (
4839: NVL (
4840: DECODE (
4833: , '1-1' , fact.equipment_brdn_cost
4834: , 0 ) -- end decode
4835: , 0 ) -- end nvl
4836: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4837: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_brdn_cost
4838: , ROUND (
4839: NVL (
4840: DECODE (
4841: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4849: , '0-1' , fact.capitalizable_raw_cost
4850: , '1-1' , fact.capitalizable_raw_cost
4851: , 0 ) -- end decode
4852: , 0 ) -- end nvl
4853: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4854: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_raw_cost
4855: , ROUND (
4856: NVL (
4857: DECODE (
4850: , '1-1' , fact.capitalizable_raw_cost
4851: , 0 ) -- end decode
4852: , 0 ) -- end nvl
4853: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4854: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_raw_cost
4855: , ROUND (
4856: NVL (
4857: DECODE (
4858: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4866: , '0-1' , fact.capitalizable_brdn_cost
4867: , '1-1' , fact.capitalizable_brdn_cost
4868: , 0 ) -- end decode
4869: , 0 ) -- end nvl
4870: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4871: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_brdn_cost
4872: , ROUND (
4873: NVL (
4874: DECODE (
4867: , '1-1' , fact.capitalizable_brdn_cost
4868: , 0 ) -- end decode
4869: , 0 ) -- end nvl
4870: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4871: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_brdn_cost
4872: , ROUND (
4873: NVL (
4874: DECODE (
4875: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4883: , '0-1' , fact.labor_raw_cost
4884: , '1-1' , fact.labor_raw_cost
4885: , 0 ) -- end decode
4886: , 0 ) -- end nvl
4887: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4888: * PJI_UTILS.GET_MAU (fact.currency_code) labor_raw_cost
4889: , ROUND (
4890: NVL (
4891: DECODE (
4884: , '1-1' , fact.labor_raw_cost
4885: , 0 ) -- end decode
4886: , 0 ) -- end nvl
4887: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4888: * PJI_UTILS.GET_MAU (fact.currency_code) labor_raw_cost
4889: , ROUND (
4890: NVL (
4891: DECODE (
4892: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4900: , '0-1' , fact.labor_brdn_cost
4901: , '1-1' , fact.labor_brdn_cost
4902: , 0 ) -- end decode
4903: , 0 ) -- end nvl
4904: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4905: * PJI_UTILS.GET_MAU (fact.currency_code) labor_brdn_cost
4906: , ROUND (
4907: NVL (
4908: DECODE (
4901: , '1-1' , fact.labor_brdn_cost
4902: , 0 ) -- end decode
4903: , 0 ) -- end nvl
4904: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4905: * PJI_UTILS.GET_MAU (fact.currency_code) labor_brdn_cost
4906: , ROUND (
4907: NVL (
4908: DECODE (
4909: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4917: , '0-1' , fact.labor_hrs
4918: , '1-1' , fact.labor_hrs
4919: , 0 ) -- end decode
4920: , 0 ) -- end nvl
4921: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4922: * PJI_UTILS.GET_MAU (fact.currency_code) labor_hrs
4923: , ROUND (
4924: NVL (
4925: DECODE (
4918: , '1-1' , fact.labor_hrs
4919: , 0 ) -- end decode
4920: , 0 ) -- end nvl
4921: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4922: * PJI_UTILS.GET_MAU (fact.currency_code) labor_hrs
4923: , ROUND (
4924: NVL (
4925: DECODE (
4926: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4934: , '0-1' , fact.labor_revenue
4935: , '1-1' , fact.labor_revenue
4936: , 0 ) -- end decode
4937: , 0 ) -- end nvl
4938: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4939: * PJI_UTILS.GET_MAU (fact.currency_code) labor_revenue
4940: , ROUND (
4941: NVL (
4942: DECODE (
4935: , '1-1' , fact.labor_revenue
4936: , 0 ) -- end decode
4937: , 0 ) -- end nvl
4938: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4939: * PJI_UTILS.GET_MAU (fact.currency_code) labor_revenue
4940: , ROUND (
4941: NVL (
4942: DECODE (
4943: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4951: , '0-1' , fact.equipment_hours
4952: , '1-1' , fact.equipment_hours
4953: , 0 ) -- end decode
4954: , 0 ) -- end nvl
4955: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4956: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_hours
4957: , ROUND (
4958: NVL (
4959: DECODE (
4952: , '1-1' , fact.equipment_hours
4953: , 0 ) -- end decode
4954: , 0 ) -- end nvl
4955: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4956: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_hours
4957: , ROUND (
4958: NVL (
4959: DECODE (
4960: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4968: , '0-1' , fact.billable_equipment_hours
4969: , '1-1' , fact.billable_equipment_hours
4970: , 0 ) -- end decode
4971: , 0 ) -- end nvl
4972: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4973: * PJI_UTILS.GET_MAU (fact.currency_code) billable_equipment_hours
4974: , ROUND (
4975: NVL (
4976: DECODE (
4969: , '1-1' , fact.billable_equipment_hours
4970: , 0 ) -- end decode
4971: , 0 ) -- end nvl
4972: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4973: * PJI_UTILS.GET_MAU (fact.currency_code) billable_equipment_hours
4974: , ROUND (
4975: NVL (
4976: DECODE (
4977: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
4985: , '0-1' , fact.sup_inv_committed_cost
4986: , '1-1' , fact.sup_inv_committed_cost
4987: , 0 ) -- end decode
4988: , 0 ) -- end nvl
4989: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4990: * PJI_UTILS.GET_MAU (fact.currency_code) sup_inv_committed_cost
4991: , ROUND (
4992: NVL (
4993: DECODE (
4986: , '1-1' , fact.sup_inv_committed_cost
4987: , 0 ) -- end decode
4988: , 0 ) -- end nvl
4989: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
4990: * PJI_UTILS.GET_MAU (fact.currency_code) sup_inv_committed_cost
4991: , ROUND (
4992: NVL (
4993: DECODE (
4994: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5002: , '0-1' , fact.po_committed_cost
5003: , '1-1' , fact.po_committed_cost
5004: , 0 ) -- end decode
5005: , 0 ) -- end nvl
5006: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5007: * PJI_UTILS.GET_MAU (fact.currency_code) po_committed_cost
5008: , ROUND (
5009: NVL (
5010: DECODE (
5003: , '1-1' , fact.po_committed_cost
5004: , 0 ) -- end decode
5005: , 0 ) -- end nvl
5006: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5007: * PJI_UTILS.GET_MAU (fact.currency_code) po_committed_cost
5008: , ROUND (
5009: NVL (
5010: DECODE (
5011: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5019: , '0-1' , fact.pr_committed_cost
5020: , '1-1' , fact.pr_committed_cost
5021: , 0 ) -- end decode
5022: , 0 ) -- end nvl
5023: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5024: * PJI_UTILS.GET_MAU (fact.currency_code) pr_committed_cost
5025: , ROUND (
5026: NVL (
5027: DECODE (
5020: , '1-1' , fact.pr_committed_cost
5021: , 0 ) -- end decode
5022: , 0 ) -- end nvl
5023: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5024: * PJI_UTILS.GET_MAU (fact.currency_code) pr_committed_cost
5025: , ROUND (
5026: NVL (
5027: DECODE (
5028: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5036: , '0-1' , fact.oth_committed_cost
5037: , '1-1' , fact.oth_committed_cost
5038: , 0 ) -- end decode
5039: , 0 ) -- end nvl
5040: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5041: * PJI_UTILS.GET_MAU (fact.currency_code) oth_committed_cost
5042: , ROUND (
5043: NVL (
5044: DECODE (
5037: , '1-1' , fact.oth_committed_cost
5038: , 0 ) -- end decode
5039: , 0 ) -- end nvl
5040: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5041: * PJI_UTILS.GET_MAU (fact.currency_code) oth_committed_cost
5042: , ROUND (
5043: NVL (
5044: DECODE (
5045: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5053: , '0-1' , fact.ACT_LABOR_HRS
5054: , '1-1' , fact.ACT_LABOR_HRS
5055: , 0 ) -- end decode
5056: , 0 ) -- end nvl
5057: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5058: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_HRS
5059: , ROUND (
5060: NVL (
5061: DECODE (
5054: , '1-1' , fact.ACT_LABOR_HRS
5055: , 0 ) -- end decode
5056: , 0 ) -- end nvl
5057: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5058: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_HRS
5059: , ROUND (
5060: NVL (
5061: DECODE (
5062: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5070: , '0-1' , fact.ACT_EQUIP_HRS
5071: , '1-1' , fact.ACT_EQUIP_HRS
5072: , 0 ) -- end decode
5073: , 0 ) -- end nvl
5074: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5075: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_HRS
5076: , ROUND (
5077: NVL (
5078: DECODE (
5071: , '1-1' , fact.ACT_EQUIP_HRS
5072: , 0 ) -- end decode
5073: , 0 ) -- end nvl
5074: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5075: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_HRS
5076: , ROUND (
5077: NVL (
5078: DECODE (
5079: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5087: , '0-1' , fact.ACT_LABOR_BRDN_COST
5088: , '1-1' , fact.ACT_LABOR_BRDN_COST
5089: , 0 ) -- end decode
5090: , 0 ) -- end nvl
5091: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5092: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_BRDN_COST
5093: , ROUND (
5094: NVL (
5095: DECODE (
5088: , '1-1' , fact.ACT_LABOR_BRDN_COST
5089: , 0 ) -- end decode
5090: , 0 ) -- end nvl
5091: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5092: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_BRDN_COST
5093: , ROUND (
5094: NVL (
5095: DECODE (
5096: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5104: , '0-1' , fact.ACT_EQUIP_BRDN_COST
5105: , '1-1' , fact.ACT_EQUIP_BRDN_COST
5106: , 0 ) -- end decode
5107: , 0 ) -- end nvl
5108: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5109: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_BRDN_COST
5110: , ROUND (
5111: NVL (
5112: DECODE (
5105: , '1-1' , fact.ACT_EQUIP_BRDN_COST
5106: , 0 ) -- end decode
5107: , 0 ) -- end nvl
5108: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5109: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_BRDN_COST
5110: , ROUND (
5111: NVL (
5112: DECODE (
5113: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5121: , '0-1' , fact.ACT_BRDN_COST
5122: , '1-1' , fact.ACT_BRDN_COST
5123: , 0 ) -- end decode
5124: , 0 ) -- end nvl
5125: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5126: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_BRDN_COST
5127: , ROUND (
5128: NVL (
5129: DECODE (
5122: , '1-1' , fact.ACT_BRDN_COST
5123: , 0 ) -- end decode
5124: , 0 ) -- end nvl
5125: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5126: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_BRDN_COST
5127: , ROUND (
5128: NVL (
5129: DECODE (
5130: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5138: , '0-1' , fact.ACT_RAW_COST
5139: , '1-1' , fact.ACT_RAW_COST
5140: , 0 ) -- end decode
5141: , 0 ) -- end nvl
5142: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5143: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_RAW_COST
5144: , ROUND (
5145: NVL (
5146: DECODE (
5139: , '1-1' , fact.ACT_RAW_COST
5140: , 0 ) -- end decode
5141: , 0 ) -- end nvl
5142: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5143: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_RAW_COST
5144: , ROUND (
5145: NVL (
5146: DECODE (
5147: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5155: , '0-1' , fact.ACT_REVENUE
5156: , '1-1' , fact.ACT_REVENUE
5157: , 0 ) -- end decode
5158: , 0 ) -- end nvl
5159: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5160: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_REVENUE
5161: , ROUND (
5162: NVL (
5163: DECODE (
5156: , '1-1' , fact.ACT_REVENUE
5157: , 0 ) -- end decode
5158: , 0 ) -- end nvl
5159: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5160: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_REVENUE
5161: , ROUND (
5162: NVL (
5163: DECODE (
5164: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5172: , '0-1' , fact.ACT_LABOR_RAW_COST
5173: , '1-1' , fact.ACT_LABOR_RAW_COST
5174: , 0 ) -- end decode
5175: , 0 ) -- end nvl
5176: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5177: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_RAW_COST
5178: , ROUND (
5179: NVL (
5180: DECODE (
5173: , '1-1' , fact.ACT_LABOR_RAW_COST
5174: , 0 ) -- end decode
5175: , 0 ) -- end nvl
5176: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5177: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_RAW_COST
5178: , ROUND (
5179: NVL (
5180: DECODE (
5181: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5189: , '0-1' , fact.ACT_EQUIP_RAW_COST
5190: , '1-1' , fact.ACT_EQUIP_RAW_COST
5191: , 0 ) -- end decode
5192: , 0 ) -- end nvl
5193: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5194: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_RAW_COST
5195: , ROUND (
5196: NVL (
5197: DECODE (
5190: , '1-1' , fact.ACT_EQUIP_RAW_COST
5191: , 0 ) -- end decode
5192: , 0 ) -- end nvl
5193: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5194: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_RAW_COST
5195: , ROUND (
5196: NVL (
5197: DECODE (
5198: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5206: , '0-1' , fact.ETC_LABOR_HRS
5207: , '1-1' , fact.ETC_LABOR_HRS
5208: , 0 ) -- end decode
5209: , 0 ) -- end nvl
5210: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5211: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_HRS
5212: , ROUND (
5213: NVL (
5214: DECODE (
5207: , '1-1' , fact.ETC_LABOR_HRS
5208: , 0 ) -- end decode
5209: , 0 ) -- end nvl
5210: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5211: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_HRS
5212: , ROUND (
5213: NVL (
5214: DECODE (
5215: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5223: , '0-1' , fact.ETC_EQUIP_HRS
5224: , '1-1' , fact.ETC_EQUIP_HRS
5225: , 0 ) -- end decode
5226: , 0 ) -- end nvl
5227: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5228: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_HRS
5229: , ROUND (
5230: NVL (
5231: DECODE (
5224: , '1-1' , fact.ETC_EQUIP_HRS
5225: , 0 ) -- end decode
5226: , 0 ) -- end nvl
5227: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5228: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_HRS
5229: , ROUND (
5230: NVL (
5231: DECODE (
5232: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5240: , '0-1' , fact.ETC_LABOR_BRDN_COST
5241: , '1-1' , fact.ETC_LABOR_BRDN_COST
5242: , 0 ) -- end decode
5243: , 0 ) -- end nvl
5244: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5245: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_BRDN_COST
5246: , ROUND (
5247: NVL (
5248: DECODE (
5241: , '1-1' , fact.ETC_LABOR_BRDN_COST
5242: , 0 ) -- end decode
5243: , 0 ) -- end nvl
5244: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5245: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_BRDN_COST
5246: , ROUND (
5247: NVL (
5248: DECODE (
5249: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5257: , '0-1' , fact.ETC_EQUIP_BRDN_COST
5258: , '1-1' , fact.ETC_EQUIP_BRDN_COST
5259: , 0 ) -- end decode
5260: , 0 ) -- end nvl
5261: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5262: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_BRDN_COST
5263: , ROUND (
5264: NVL (
5265: DECODE (
5258: , '1-1' , fact.ETC_EQUIP_BRDN_COST
5259: , 0 ) -- end decode
5260: , 0 ) -- end nvl
5261: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5262: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_BRDN_COST
5263: , ROUND (
5264: NVL (
5265: DECODE (
5266: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5274: , '0-1' , fact.ETC_BRDN_COST
5275: , '1-1' , fact.ETC_BRDN_COST
5276: , 0 ) -- end decode
5277: , 0 ) -- end nvl
5278: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5279: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_BRDN_COST
5280: , ROUND (
5281: NVL (
5282: DECODE (
5275: , '1-1' , fact.ETC_BRDN_COST
5276: , 0 ) -- end decode
5277: , 0 ) -- end nvl
5278: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5279: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_BRDN_COST
5280: , ROUND (
5281: NVL (
5282: DECODE (
5283: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5291: , '0-1' , fact.ETC_RAW_COST
5292: , '1-1' , fact.ETC_RAW_COST
5293: , 0 ) -- end decode
5294: , 0 ) -- end nvl
5295: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5296: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_RAW_COST
5297: , ROUND (
5298: NVL (
5299: DECODE (
5292: , '1-1' , fact.ETC_RAW_COST
5293: , 0 ) -- end decode
5294: , 0 ) -- end nvl
5295: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5296: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_RAW_COST
5297: , ROUND (
5298: NVL (
5299: DECODE (
5300: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5308: , '0-1' , fact.ETC_LABOR_RAW_COST
5309: , '1-1' , fact.ETC_LABOR_RAW_COST
5310: , 0 ) -- end decode
5311: , 0 ) -- end nvl
5312: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5313: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_RAW_COST
5314: , ROUND (
5315: NVL (
5316: DECODE (
5309: , '1-1' , fact.ETC_LABOR_RAW_COST
5310: , 0 ) -- end decode
5311: , 0 ) -- end nvl
5312: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5313: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_RAW_COST
5314: , ROUND (
5315: NVL (
5316: DECODE (
5317: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5325: , '0-1' , fact.ETC_EQUIP_RAW_COST
5326: , '1-1' , fact.ETC_EQUIP_RAW_COST
5327: , 0 ) -- end decode
5328: , 0 ) -- end nvl
5329: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5330: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_RAW_COST
5331: , ROUND (
5332: NVL (
5333: DECODE (
5326: , '1-1' , fact.ETC_EQUIP_RAW_COST
5327: , 0 ) -- end decode
5328: , 0 ) -- end nvl
5329: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5330: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_RAW_COST
5331: , ROUND (
5332: NVL (
5333: DECODE (
5334: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5342: , '0-1' , fact.custom1
5343: , '1-1' , fact.custom1
5344: , 0 ) -- end decode
5345: , 0 ) -- end nvl
5346: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5347: * PJI_UTILS.GET_MAU (fact.currency_code) custom1
5348: , ROUND (
5349: NVL (
5350: DECODE (
5343: , '1-1' , fact.custom1
5344: , 0 ) -- end decode
5345: , 0 ) -- end nvl
5346: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5347: * PJI_UTILS.GET_MAU (fact.currency_code) custom1
5348: , ROUND (
5349: NVL (
5350: DECODE (
5351: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5359: , '0-1' , fact.custom2
5360: , '1-1' , fact.custom2
5361: , 0 ) -- end decode
5362: , 0 ) -- end nvl
5363: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5364: * PJI_UTILS.GET_MAU (fact.currency_code) custom2
5365: , ROUND (
5366: NVL (
5367: DECODE (
5360: , '1-1' , fact.custom2
5361: , 0 ) -- end decode
5362: , 0 ) -- end nvl
5363: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5364: * PJI_UTILS.GET_MAU (fact.currency_code) custom2
5365: , ROUND (
5366: NVL (
5367: DECODE (
5368: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5376: , '0-1' , fact.custom3
5377: , '1-1' , fact.custom3
5378: , 0 ) -- end decode
5379: , 0 ) -- end nvl
5380: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5381: * PJI_UTILS.GET_MAU (fact.currency_code) custom3
5382: , ROUND (
5383: NVL (
5384: DECODE (
5377: , '1-1' , fact.custom3
5378: , 0 ) -- end decode
5379: , 0 ) -- end nvl
5380: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5381: * PJI_UTILS.GET_MAU (fact.currency_code) custom3
5382: , ROUND (
5383: NVL (
5384: DECODE (
5385: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5393: , '0-1' , fact.custom4
5394: , '1-1' , fact.custom4
5395: , 0 ) -- end decode
5396: , 0 ) -- end nvl
5397: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5398: * PJI_UTILS.GET_MAU (fact.currency_code) custom4
5399: , ROUND (
5400: NVL (
5401: DECODE (
5394: , '1-1' , fact.custom4
5395: , 0 ) -- end decode
5396: , 0 ) -- end nvl
5397: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5398: * PJI_UTILS.GET_MAU (fact.currency_code) custom4
5399: , ROUND (
5400: NVL (
5401: DECODE (
5402: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5410: , '0-1' , fact.custom5
5411: , '1-1' , fact.custom5
5412: , 0 ) -- end decode
5413: , 0 ) -- end nvl
5414: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5415: * PJI_UTILS.GET_MAU (fact.currency_code) custom5
5416: , ROUND (
5417: NVL (
5418: DECODE (
5411: , '1-1' , fact.custom5
5412: , 0 ) -- end decode
5413: , 0 ) -- end nvl
5414: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5415: * PJI_UTILS.GET_MAU (fact.currency_code) custom5
5416: , ROUND (
5417: NVL (
5418: DECODE (
5419: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5427: , '0-1' , fact.custom6
5428: , '1-1' , fact.custom6
5429: , 0 ) -- end decode
5430: , 0 ) -- end nvl
5431: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5432: * PJI_UTILS.GET_MAU (fact.currency_code) custom6
5433: , ROUND (
5434: NVL (
5435: DECODE (
5428: , '1-1' , fact.custom6
5429: , 0 ) -- end decode
5430: , 0 ) -- end nvl
5431: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5432: * PJI_UTILS.GET_MAU (fact.currency_code) custom6
5433: , ROUND (
5434: NVL (
5435: DECODE (
5436: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5444: , '0-1' , fact.custom7
5445: , '1-1' , fact.custom7
5446: , 0 ) -- end decode
5447: , 0 ) -- end nvl
5448: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5449: * PJI_UTILS.GET_MAU (fact.currency_code) custom7
5450: , ROUND (
5451: NVL (
5452: DECODE (
5445: , '1-1' , fact.custom7
5446: , 0 ) -- end decode
5447: , 0 ) -- end nvl
5448: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5449: * PJI_UTILS.GET_MAU (fact.currency_code) custom7
5450: , ROUND (
5451: NVL (
5452: DECODE (
5453: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5461: , '0-1' , fact.custom8
5462: , '1-1' , fact.custom8
5463: , 0 ) -- end decode
5464: , 0 ) -- end nvl
5465: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5466: * PJI_UTILS.GET_MAU (fact.currency_code) custom8
5467: , ROUND (
5468: NVL (
5469: DECODE (
5462: , '1-1' , fact.custom8
5463: , 0 ) -- end decode
5464: , 0 ) -- end nvl
5465: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5466: * PJI_UTILS.GET_MAU (fact.currency_code) custom8
5467: , ROUND (
5468: NVL (
5469: DECODE (
5470: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5478: , '0-1' , fact.custom9
5479: , '1-1' , fact.custom9
5480: , 0 ) -- end decode
5481: , 0 ) -- end nvl
5482: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5483: * PJI_UTILS.GET_MAU (fact.currency_code) custom9
5484: , ROUND (
5485: NVL (
5486: DECODE (
5479: , '1-1' , fact.custom9
5480: , 0 ) -- end decode
5481: , 0 ) -- end nvl
5482: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5483: * PJI_UTILS.GET_MAU (fact.currency_code) custom9
5484: , ROUND (
5485: NVL (
5486: DECODE (
5487: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5495: , '0-1' , fact.custom10
5496: , '1-1' , fact.custom10
5497: , 0 ) -- end decode
5498: , 0 ) -- end nvl
5499: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5500: * PJI_UTILS.GET_MAU (fact.currency_code) custom10
5501: , ROUND (
5502: NVL (
5503: DECODE (
5496: , '1-1' , fact.custom10
5497: , 0 ) -- end decode
5498: , 0 ) -- end nvl
5499: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5500: * PJI_UTILS.GET_MAU (fact.currency_code) custom10
5501: , ROUND (
5502: NVL (
5503: DECODE (
5504: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5512: , '0-1' , fact.custom11
5513: , '1-1' , fact.custom11
5514: , 0 ) -- end decode
5515: , 0 ) -- end nvl
5516: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5517: * PJI_UTILS.GET_MAU (fact.currency_code) custom11
5518: , ROUND (
5519: NVL (
5520: DECODE (
5513: , '1-1' , fact.custom11
5514: , 0 ) -- end decode
5515: , 0 ) -- end nvl
5516: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5517: * PJI_UTILS.GET_MAU (fact.currency_code) custom11
5518: , ROUND (
5519: NVL (
5520: DECODE (
5521: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5529: , '0-1' , fact.custom12
5530: , '1-1' , fact.custom12
5531: , 0 ) -- end decode
5532: , 0 ) -- end nvl
5533: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5534: * PJI_UTILS.GET_MAU (fact.currency_code) custom12
5535: , ROUND (
5536: NVL (
5537: DECODE (
5530: , '1-1' , fact.custom12
5531: , 0 ) -- end decode
5532: , 0 ) -- end nvl
5533: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5534: * PJI_UTILS.GET_MAU (fact.currency_code) custom12
5535: , ROUND (
5536: NVL (
5537: DECODE (
5538: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5546: , '0-1' , fact.custom13
5547: , '1-1' , fact.custom13
5548: , 0 ) -- end decode
5549: , 0 ) -- end nvl
5550: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5551: * PJI_UTILS.GET_MAU (fact.currency_code) custom13
5552: , ROUND (
5553: NVL (
5554: DECODE (
5547: , '1-1' , fact.custom13
5548: , 0 ) -- end decode
5549: , 0 ) -- end nvl
5550: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5551: * PJI_UTILS.GET_MAU (fact.currency_code) custom13
5552: , ROUND (
5553: NVL (
5554: DECODE (
5555: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5563: , '0-1' , fact.custom14
5564: , '1-1' , fact.custom14
5565: , 0 ) -- end decode
5566: , 0 ) -- end nvl
5567: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5568: * PJI_UTILS.GET_MAU (fact.currency_code) custom14
5569: , ROUND (
5570: NVL (
5571: DECODE (
5564: , '1-1' , fact.custom14
5565: , 0 ) -- end decode
5566: , 0 ) -- end nvl
5567: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5568: * PJI_UTILS.GET_MAU (fact.currency_code) custom14
5569: , ROUND (
5570: NVL (
5571: DECODE (
5572: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
5580: , '0-1' , fact.custom15
5581: , '1-1' , fact.custom15
5582: , 0 ) -- end decode
5583: , 0 ) -- end nvl
5584: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5585: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
5586: , fact.plan_type_code plan_type_code /* 4471527 */
5587: FROM pji_fp_xbs_accum_f fact
5588: , pji_time_cal_period non_pa_cal
5581: , '1-1' , fact.custom15
5582: , 0 ) -- end decode
5583: , 0 ) -- end nvl
5584: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5585: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
5586: , fact.plan_type_code plan_type_code /* 4471527 */
5587: FROM pji_fp_xbs_accum_f fact
5588: , pji_time_cal_period non_pa_cal
5589: -- , pji_org_extr_info orginfo
5832: , '0-1' , fact.raw_cost
5833: , '1-1' , fact.raw_cost
5834: , 0 ) -- end decode
5835: , 0 ) -- end nvl
5836: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5837: * PJI_UTILS.GET_MAU (fact.currency_code) raw_cost
5838: , ROUND (
5839: NVL (
5840: DECODE (
5833: , '1-1' , fact.raw_cost
5834: , 0 ) -- end decode
5835: , 0 ) -- end nvl
5836: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5837: * PJI_UTILS.GET_MAU (fact.currency_code) raw_cost
5838: , ROUND (
5839: NVL (
5840: DECODE (
5841: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
5849: , '0-1' , fact.brdn_cost
5850: , '1-1' , fact.brdn_cost
5851: , 0 ) -- end decode
5852: , 0 ) -- end nvl
5853: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5854: * PJI_UTILS.GET_MAU (fact.currency_code) brdn_cost
5855: , ROUND (
5856: NVL (
5857: DECODE (
5850: , '1-1' , fact.brdn_cost
5851: , 0 ) -- end decode
5852: , 0 ) -- end nvl
5853: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5854: * PJI_UTILS.GET_MAU (fact.currency_code) brdn_cost
5855: , ROUND (
5856: NVL (
5857: DECODE (
5858: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
5866: , '0-1' , fact.revenue
5867: , '1-1' , fact.revenue
5868: , 0 ) -- end decode
5869: , 0 ) -- end nvl
5870: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5871: * PJI_UTILS.GET_MAU (fact.currency_code) revenue
5872: , ROUND (
5873: NVL (
5874: DECODE (
5867: , '1-1' , fact.revenue
5868: , 0 ) -- end decode
5869: , 0 ) -- end nvl
5870: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5871: * PJI_UTILS.GET_MAU (fact.currency_code) revenue
5872: , ROUND (
5873: NVL (
5874: DECODE (
5875: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
5883: , '0-1' , fact.bill_raw_cost
5884: , '1-1' , fact.bill_raw_cost
5885: , 0 ) -- end decode
5886: , 0 ) -- end nvl
5887: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5888: * PJI_UTILS.GET_MAU (fact.currency_code) bill_raw_cost
5889: , ROUND (
5890: NVL (
5891: DECODE (
5884: , '1-1' , fact.bill_raw_cost
5885: , 0 ) -- end decode
5886: , 0 ) -- end nvl
5887: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5888: * PJI_UTILS.GET_MAU (fact.currency_code) bill_raw_cost
5889: , ROUND (
5890: NVL (
5891: DECODE (
5892: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
5900: , '0-1' , fact.bill_brdn_cost
5901: , '1-1' , fact.bill_brdn_cost
5902: , 0 ) -- end decode
5903: , 0 ) -- end nvl
5904: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5905: * PJI_UTILS.GET_MAU (fact.currency_code) bill_brdn_cost
5906: , ROUND (
5907: NVL (
5908: DECODE (
5901: , '1-1' , fact.bill_brdn_cost
5902: , 0 ) -- end decode
5903: , 0 ) -- end nvl
5904: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5905: * PJI_UTILS.GET_MAU (fact.currency_code) bill_brdn_cost
5906: , ROUND (
5907: NVL (
5908: DECODE (
5909: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
5917: , '0-1' , fact.bill_labor_raw_cost
5918: , '1-1' , fact.bill_labor_raw_cost
5919: , 0 ) -- end decode
5920: , 0 ) -- end nvl
5921: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5922: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_raw_cost
5923: , ROUND (
5924: NVL (
5925: DECODE (
5918: , '1-1' , fact.bill_labor_raw_cost
5919: , 0 ) -- end decode
5920: , 0 ) -- end nvl
5921: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5922: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_raw_cost
5923: , ROUND (
5924: NVL (
5925: DECODE (
5926: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
5934: , '0-1' , fact.bill_labor_brdn_cost
5935: , '1-1' , fact.bill_labor_brdn_cost
5936: , 0 ) -- end decode
5937: , 0 ) -- end nvl
5938: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5939: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_brdn_cost
5940: , ROUND (
5941: NVL (
5942: DECODE (
5935: , '1-1' , fact.bill_labor_brdn_cost
5936: , 0 ) -- end decode
5937: , 0 ) -- end nvl
5938: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5939: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_brdn_cost
5940: , ROUND (
5941: NVL (
5942: DECODE (
5943: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
5951: , '0-1' , fact.bill_labor_hrs
5952: , '1-1' , fact.bill_labor_hrs
5953: , 0 ) -- end decode
5954: , 0 ) -- end nvl
5955: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5956: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_hrs
5957: , ROUND (
5958: NVL (
5959: DECODE (
5952: , '1-1' , fact.bill_labor_hrs
5953: , 0 ) -- end decode
5954: , 0 ) -- end nvl
5955: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5956: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_hrs
5957: , ROUND (
5958: NVL (
5959: DECODE (
5960: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
5968: , '0-1' , fact.equipment_raw_cost
5969: , '1-1' , fact.equipment_raw_cost
5970: , 0 ) -- end decode
5971: , 0 ) -- end nvl
5972: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5973: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_raw_cost
5974: , ROUND (
5975: NVL (
5976: DECODE (
5969: , '1-1' , fact.equipment_raw_cost
5970: , 0 ) -- end decode
5971: , 0 ) -- end nvl
5972: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5973: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_raw_cost
5974: , ROUND (
5975: NVL (
5976: DECODE (
5977: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
5985: , '0-1' , fact.equipment_brdn_cost
5986: , '1-1' , fact.equipment_brdn_cost
5987: , 0 ) -- end decode
5988: , 0 ) -- end nvl
5989: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5990: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_brdn_cost
5991: , ROUND (
5992: NVL (
5993: DECODE (
5986: , '1-1' , fact.equipment_brdn_cost
5987: , 0 ) -- end decode
5988: , 0 ) -- end nvl
5989: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5990: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_brdn_cost
5991: , ROUND (
5992: NVL (
5993: DECODE (
5994: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6002: , '0-1' , fact.capitalizable_raw_cost
6003: , '1-1' , fact.capitalizable_raw_cost
6004: , 0 ) -- end decode
6005: , 0 ) -- end nvl
6006: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6007: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_raw_cost
6008: , ROUND (
6009: NVL (
6010: DECODE (
6003: , '1-1' , fact.capitalizable_raw_cost
6004: , 0 ) -- end decode
6005: , 0 ) -- end nvl
6006: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6007: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_raw_cost
6008: , ROUND (
6009: NVL (
6010: DECODE (
6011: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6019: , '0-1' , fact.capitalizable_brdn_cost
6020: , '1-1' , fact.capitalizable_brdn_cost
6021: , 0 ) -- end decode
6022: , 0 ) -- end nvl
6023: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6024: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_brdn_cost
6025: , ROUND (
6026: NVL (
6027: DECODE (
6020: , '1-1' , fact.capitalizable_brdn_cost
6021: , 0 ) -- end decode
6022: , 0 ) -- end nvl
6023: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6024: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_brdn_cost
6025: , ROUND (
6026: NVL (
6027: DECODE (
6028: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6036: , '0-1' , fact.labor_raw_cost
6037: , '1-1' , fact.labor_raw_cost
6038: , 0 ) -- end decode
6039: , 0 ) -- end nvl
6040: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6041: * PJI_UTILS.GET_MAU (fact.currency_code) labor_raw_cost
6042: , ROUND (
6043: NVL (
6044: DECODE (
6037: , '1-1' , fact.labor_raw_cost
6038: , 0 ) -- end decode
6039: , 0 ) -- end nvl
6040: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6041: * PJI_UTILS.GET_MAU (fact.currency_code) labor_raw_cost
6042: , ROUND (
6043: NVL (
6044: DECODE (
6045: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6053: , '0-1' , fact.labor_brdn_cost
6054: , '1-1' , fact.labor_brdn_cost
6055: , 0 ) -- end decode
6056: , 0 ) -- end nvl
6057: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6058: * PJI_UTILS.GET_MAU (fact.currency_code) labor_brdn_cost
6059: , ROUND (
6060: NVL (
6061: DECODE (
6054: , '1-1' , fact.labor_brdn_cost
6055: , 0 ) -- end decode
6056: , 0 ) -- end nvl
6057: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6058: * PJI_UTILS.GET_MAU (fact.currency_code) labor_brdn_cost
6059: , ROUND (
6060: NVL (
6061: DECODE (
6062: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6070: , '0-1' , fact.labor_hrs
6071: , '1-1' , fact.labor_hrs
6072: , 0 ) -- end decode
6073: , 0 ) -- end nvl
6074: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6075: * PJI_UTILS.GET_MAU (fact.currency_code) labor_hrs
6076: , ROUND (
6077: NVL (
6078: DECODE (
6071: , '1-1' , fact.labor_hrs
6072: , 0 ) -- end decode
6073: , 0 ) -- end nvl
6074: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6075: * PJI_UTILS.GET_MAU (fact.currency_code) labor_hrs
6076: , ROUND (
6077: NVL (
6078: DECODE (
6079: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6087: , '0-1' , fact.labor_revenue
6088: , '1-1' , fact.labor_revenue
6089: , 0 ) -- end decode
6090: , 0 ) -- end nvl
6091: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6092: * PJI_UTILS.GET_MAU (fact.currency_code) labor_revenue
6093: , ROUND (
6094: NVL (
6095: DECODE (
6088: , '1-1' , fact.labor_revenue
6089: , 0 ) -- end decode
6090: , 0 ) -- end nvl
6091: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6092: * PJI_UTILS.GET_MAU (fact.currency_code) labor_revenue
6093: , ROUND (
6094: NVL (
6095: DECODE (
6096: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6104: , '0-1' , fact.equipment_hours
6105: , '1-1' , fact.equipment_hours
6106: , 0 ) -- end decode
6107: , 0 ) -- end nvl
6108: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6109: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_hours
6110: , ROUND (
6111: NVL (
6112: DECODE (
6105: , '1-1' , fact.equipment_hours
6106: , 0 ) -- end decode
6107: , 0 ) -- end nvl
6108: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6109: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_hours
6110: , ROUND (
6111: NVL (
6112: DECODE (
6113: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6121: , '0-1' , fact.billable_equipment_hours
6122: , '1-1' , fact.billable_equipment_hours
6123: , 0 ) -- end decode
6124: , 0 ) -- end nvl
6125: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6126: * PJI_UTILS.GET_MAU (fact.currency_code) billable_equipment_hours
6127: , ROUND (
6128: NVL (
6129: DECODE (
6122: , '1-1' , fact.billable_equipment_hours
6123: , 0 ) -- end decode
6124: , 0 ) -- end nvl
6125: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6126: * PJI_UTILS.GET_MAU (fact.currency_code) billable_equipment_hours
6127: , ROUND (
6128: NVL (
6129: DECODE (
6130: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6138: , '0-1' , fact.sup_inv_committed_cost
6139: , '1-1' , fact.sup_inv_committed_cost
6140: , 0 ) -- end decode
6141: , 0 ) -- end nvl
6142: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6143: * PJI_UTILS.GET_MAU (fact.currency_code) sup_inv_committed_cost
6144: , ROUND (
6145: NVL (
6146: DECODE (
6139: , '1-1' , fact.sup_inv_committed_cost
6140: , 0 ) -- end decode
6141: , 0 ) -- end nvl
6142: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6143: * PJI_UTILS.GET_MAU (fact.currency_code) sup_inv_committed_cost
6144: , ROUND (
6145: NVL (
6146: DECODE (
6147: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6155: , '0-1' , fact.po_committed_cost
6156: , '1-1' , fact.po_committed_cost
6157: , 0 ) -- end decode
6158: , 0 ) -- end nvl
6159: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6160: * PJI_UTILS.GET_MAU (fact.currency_code) po_committed_cost
6161: , ROUND (
6162: NVL (
6163: DECODE (
6156: , '1-1' , fact.po_committed_cost
6157: , 0 ) -- end decode
6158: , 0 ) -- end nvl
6159: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6160: * PJI_UTILS.GET_MAU (fact.currency_code) po_committed_cost
6161: , ROUND (
6162: NVL (
6163: DECODE (
6164: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6172: , '0-1' , fact.pr_committed_cost
6173: , '1-1' , fact.pr_committed_cost
6174: , 0 ) -- end decode
6175: , 0 ) -- end nvl
6176: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6177: * PJI_UTILS.GET_MAU (fact.currency_code) pr_committed_cost
6178: , ROUND (
6179: NVL (
6180: DECODE (
6173: , '1-1' , fact.pr_committed_cost
6174: , 0 ) -- end decode
6175: , 0 ) -- end nvl
6176: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6177: * PJI_UTILS.GET_MAU (fact.currency_code) pr_committed_cost
6178: , ROUND (
6179: NVL (
6180: DECODE (
6181: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6189: , '0-1' , fact.oth_committed_cost
6190: , '1-1' , fact.oth_committed_cost
6191: , 0 ) -- end decode
6192: , 0 ) -- end nvl
6193: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6194: * PJI_UTILS.GET_MAU (fact.currency_code) oth_committed_cost
6195: , ROUND (
6196: NVL (
6197: DECODE (
6190: , '1-1' , fact.oth_committed_cost
6191: , 0 ) -- end decode
6192: , 0 ) -- end nvl
6193: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6194: * PJI_UTILS.GET_MAU (fact.currency_code) oth_committed_cost
6195: , ROUND (
6196: NVL (
6197: DECODE (
6198: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6206: , '0-1' , fact.ACT_LABOR_HRS
6207: , '1-1' , fact.ACT_LABOR_HRS
6208: , 0 ) -- end decode
6209: , 0 ) -- end nvl
6210: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6211: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_HRS
6212: , ROUND (
6213: NVL (
6214: DECODE (
6207: , '1-1' , fact.ACT_LABOR_HRS
6208: , 0 ) -- end decode
6209: , 0 ) -- end nvl
6210: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6211: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_HRS
6212: , ROUND (
6213: NVL (
6214: DECODE (
6215: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6223: , '0-1' , fact.ACT_EQUIP_HRS
6224: , '1-1' , fact.ACT_EQUIP_HRS
6225: , 0 ) -- end decode
6226: , 0 ) -- end nvl
6227: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6228: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_HRS
6229: , ROUND (
6230: NVL (
6231: DECODE (
6224: , '1-1' , fact.ACT_EQUIP_HRS
6225: , 0 ) -- end decode
6226: , 0 ) -- end nvl
6227: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6228: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_HRS
6229: , ROUND (
6230: NVL (
6231: DECODE (
6232: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6240: , '0-1' , fact.ACT_LABOR_BRDN_COST
6241: , '1-1' , fact.ACT_LABOR_BRDN_COST
6242: , 0 ) -- end decode
6243: , 0 ) -- end nvl
6244: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6245: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_BRDN_COST
6246: , ROUND (
6247: NVL (
6248: DECODE (
6241: , '1-1' , fact.ACT_LABOR_BRDN_COST
6242: , 0 ) -- end decode
6243: , 0 ) -- end nvl
6244: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6245: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_BRDN_COST
6246: , ROUND (
6247: NVL (
6248: DECODE (
6249: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6257: , '0-1' , fact.ACT_EQUIP_BRDN_COST
6258: , '1-1' , fact.ACT_EQUIP_BRDN_COST
6259: , 0 ) -- end decode
6260: , 0 ) -- end nvl
6261: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6262: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_BRDN_COST
6263: , ROUND (
6264: NVL (
6265: DECODE (
6258: , '1-1' , fact.ACT_EQUIP_BRDN_COST
6259: , 0 ) -- end decode
6260: , 0 ) -- end nvl
6261: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6262: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_BRDN_COST
6263: , ROUND (
6264: NVL (
6265: DECODE (
6266: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6274: , '0-1' , fact.ACT_BRDN_COST
6275: , '1-1' , fact.ACT_BRDN_COST
6276: , 0 ) -- end decode
6277: , 0 ) -- end nvl
6278: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6279: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_BRDN_COST
6280: , ROUND (
6281: NVL (
6282: DECODE (
6275: , '1-1' , fact.ACT_BRDN_COST
6276: , 0 ) -- end decode
6277: , 0 ) -- end nvl
6278: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6279: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_BRDN_COST
6280: , ROUND (
6281: NVL (
6282: DECODE (
6283: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6291: , '0-1' , fact.ACT_RAW_COST
6292: , '1-1' , fact.ACT_RAW_COST
6293: , 0 ) -- end decode
6294: , 0 ) -- end nvl
6295: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6296: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_RAW_COST
6297: , ROUND (
6298: NVL (
6299: DECODE (
6292: , '1-1' , fact.ACT_RAW_COST
6293: , 0 ) -- end decode
6294: , 0 ) -- end nvl
6295: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6296: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_RAW_COST
6297: , ROUND (
6298: NVL (
6299: DECODE (
6300: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6308: , '0-1' , fact.ACT_REVENUE
6309: , '1-1' , fact.ACT_REVENUE
6310: , 0 ) -- end decode
6311: , 0 ) -- end nvl
6312: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6313: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_REVENUE
6314: , ROUND (
6315: NVL (
6316: DECODE (
6309: , '1-1' , fact.ACT_REVENUE
6310: , 0 ) -- end decode
6311: , 0 ) -- end nvl
6312: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6313: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_REVENUE
6314: , ROUND (
6315: NVL (
6316: DECODE (
6317: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6325: , '0-1' , fact.ACT_LABOR_RAW_COST
6326: , '1-1' , fact.ACT_LABOR_RAW_COST
6327: , 0 ) -- end decode
6328: , 0 ) -- end nvl
6329: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6330: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_RAW_COST
6331: , ROUND (
6332: NVL (
6333: DECODE (
6326: , '1-1' , fact.ACT_LABOR_RAW_COST
6327: , 0 ) -- end decode
6328: , 0 ) -- end nvl
6329: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6330: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_RAW_COST
6331: , ROUND (
6332: NVL (
6333: DECODE (
6334: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6342: , '0-1' , fact.ACT_EQUIP_RAW_COST
6343: , '1-1' , fact.ACT_EQUIP_RAW_COST
6344: , 0 ) -- end decode
6345: , 0 ) -- end nvl
6346: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6347: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_RAW_COST
6348: , ROUND (
6349: NVL (
6350: DECODE (
6343: , '1-1' , fact.ACT_EQUIP_RAW_COST
6344: , 0 ) -- end decode
6345: , 0 ) -- end nvl
6346: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6347: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_RAW_COST
6348: , ROUND (
6349: NVL (
6350: DECODE (
6351: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6359: , '0-1' , fact.ETC_LABOR_HRS
6360: , '1-1' , fact.ETC_LABOR_HRS
6361: , 0 ) -- end decode
6362: , 0 ) -- end nvl
6363: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6364: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_HRS
6365: , ROUND (
6366: NVL (
6367: DECODE (
6360: , '1-1' , fact.ETC_LABOR_HRS
6361: , 0 ) -- end decode
6362: , 0 ) -- end nvl
6363: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6364: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_HRS
6365: , ROUND (
6366: NVL (
6367: DECODE (
6368: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6376: , '0-1' , fact.ETC_EQUIP_HRS
6377: , '1-1' , fact.ETC_EQUIP_HRS
6378: , 0 ) -- end decode
6379: , 0 ) -- end nvl
6380: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6381: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_HRS
6382: , ROUND (
6383: NVL (
6384: DECODE (
6377: , '1-1' , fact.ETC_EQUIP_HRS
6378: , 0 ) -- end decode
6379: , 0 ) -- end nvl
6380: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6381: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_HRS
6382: , ROUND (
6383: NVL (
6384: DECODE (
6385: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6393: , '0-1' , fact.ETC_LABOR_BRDN_COST
6394: , '1-1' , fact.ETC_LABOR_BRDN_COST
6395: , 0 ) -- end decode
6396: , 0 ) -- end nvl
6397: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6398: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_BRDN_COST
6399: , ROUND (
6400: NVL (
6401: DECODE (
6394: , '1-1' , fact.ETC_LABOR_BRDN_COST
6395: , 0 ) -- end decode
6396: , 0 ) -- end nvl
6397: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6398: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_BRDN_COST
6399: , ROUND (
6400: NVL (
6401: DECODE (
6402: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6410: , '0-1' , fact.ETC_EQUIP_BRDN_COST
6411: , '1-1' , fact.ETC_EQUIP_BRDN_COST
6412: , 0 ) -- end decode
6413: , 0 ) -- end nvl
6414: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6415: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_BRDN_COST
6416: , ROUND (
6417: NVL (
6418: DECODE (
6411: , '1-1' , fact.ETC_EQUIP_BRDN_COST
6412: , 0 ) -- end decode
6413: , 0 ) -- end nvl
6414: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6415: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_BRDN_COST
6416: , ROUND (
6417: NVL (
6418: DECODE (
6419: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6427: , '0-1' , fact.ETC_BRDN_COST
6428: , '1-1' , fact.ETC_BRDN_COST
6429: , 0 ) -- end decode
6430: , 0 ) -- end nvl
6431: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6432: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_BRDN_COST
6433: , ROUND (
6434: NVL (
6435: DECODE (
6428: , '1-1' , fact.ETC_BRDN_COST
6429: , 0 ) -- end decode
6430: , 0 ) -- end nvl
6431: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6432: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_BRDN_COST
6433: , ROUND (
6434: NVL (
6435: DECODE (
6436: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6444: , '0-1' , fact.ETC_RAW_COST
6445: , '1-1' , fact.ETC_RAW_COST
6446: , 0 ) -- end decode
6447: , 0 ) -- end nvl
6448: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6449: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_RAW_COST
6450: , ROUND (
6451: NVL (
6452: DECODE (
6445: , '1-1' , fact.ETC_RAW_COST
6446: , 0 ) -- end decode
6447: , 0 ) -- end nvl
6448: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6449: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_RAW_COST
6450: , ROUND (
6451: NVL (
6452: DECODE (
6453: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6461: , '0-1' , fact.ETC_LABOR_RAW_COST
6462: , '1-1' , fact.ETC_LABOR_RAW_COST
6463: , 0 ) -- end decode
6464: , 0 ) -- end nvl
6465: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6466: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_RAW_COST
6467: , ROUND (
6468: NVL (
6469: DECODE (
6462: , '1-1' , fact.ETC_LABOR_RAW_COST
6463: , 0 ) -- end decode
6464: , 0 ) -- end nvl
6465: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6466: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_RAW_COST
6467: , ROUND (
6468: NVL (
6469: DECODE (
6470: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6478: , '0-1' , fact.ETC_EQUIP_RAW_COST
6479: , '1-1' , fact.ETC_EQUIP_RAW_COST
6480: , 0 ) -- end decode
6481: , 0 ) -- end nvl
6482: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6483: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_RAW_COST
6484: , ROUND (
6485: NVL (
6486: DECODE (
6479: , '1-1' , fact.ETC_EQUIP_RAW_COST
6480: , 0 ) -- end decode
6481: , 0 ) -- end nvl
6482: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6483: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_RAW_COST
6484: , ROUND (
6485: NVL (
6486: DECODE (
6487: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6495: , '0-1' , fact.custom1
6496: , '1-1' , fact.custom1
6497: , 0 ) -- end decode
6498: , 0 ) -- end nvl
6499: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6500: * PJI_UTILS.GET_MAU (fact.currency_code) custom1
6501: , ROUND (
6502: NVL (
6503: DECODE (
6496: , '1-1' , fact.custom1
6497: , 0 ) -- end decode
6498: , 0 ) -- end nvl
6499: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6500: * PJI_UTILS.GET_MAU (fact.currency_code) custom1
6501: , ROUND (
6502: NVL (
6503: DECODE (
6504: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6512: , '0-1' , fact.custom2
6513: , '1-1' , fact.custom2
6514: , 0 ) -- end decode
6515: , 0 ) -- end nvl
6516: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6517: * PJI_UTILS.GET_MAU (fact.currency_code) custom2
6518: , ROUND (
6519: NVL (
6520: DECODE (
6513: , '1-1' , fact.custom2
6514: , 0 ) -- end decode
6515: , 0 ) -- end nvl
6516: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6517: * PJI_UTILS.GET_MAU (fact.currency_code) custom2
6518: , ROUND (
6519: NVL (
6520: DECODE (
6521: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6529: , '0-1' , fact.custom3
6530: , '1-1' , fact.custom3
6531: , 0 ) -- end decode
6532: , 0 ) -- end nvl
6533: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6534: * PJI_UTILS.GET_MAU (fact.currency_code) custom3
6535: , ROUND (
6536: NVL (
6537: DECODE (
6530: , '1-1' , fact.custom3
6531: , 0 ) -- end decode
6532: , 0 ) -- end nvl
6533: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6534: * PJI_UTILS.GET_MAU (fact.currency_code) custom3
6535: , ROUND (
6536: NVL (
6537: DECODE (
6538: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6546: , '0-1' , fact.custom4
6547: , '1-1' , fact.custom4
6548: , 0 ) -- end decode
6549: , 0 ) -- end nvl
6550: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6551: * PJI_UTILS.GET_MAU (fact.currency_code) custom4
6552: , ROUND (
6553: NVL (
6554: DECODE (
6547: , '1-1' , fact.custom4
6548: , 0 ) -- end decode
6549: , 0 ) -- end nvl
6550: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6551: * PJI_UTILS.GET_MAU (fact.currency_code) custom4
6552: , ROUND (
6553: NVL (
6554: DECODE (
6555: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6563: , '0-1' , fact.custom5
6564: , '1-1' , fact.custom5
6565: , 0 ) -- end decode
6566: , 0 ) -- end nvl
6567: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6568: * PJI_UTILS.GET_MAU (fact.currency_code) custom5
6569: , ROUND (
6570: NVL (
6571: DECODE (
6564: , '1-1' , fact.custom5
6565: , 0 ) -- end decode
6566: , 0 ) -- end nvl
6567: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6568: * PJI_UTILS.GET_MAU (fact.currency_code) custom5
6569: , ROUND (
6570: NVL (
6571: DECODE (
6572: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6580: , '0-1' , fact.custom6
6581: , '1-1' , fact.custom6
6582: , 0 ) -- end decode
6583: , 0 ) -- end nvl
6584: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6585: * PJI_UTILS.GET_MAU (fact.currency_code) custom6
6586: , ROUND (
6587: NVL (
6588: DECODE (
6581: , '1-1' , fact.custom6
6582: , 0 ) -- end decode
6583: , 0 ) -- end nvl
6584: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6585: * PJI_UTILS.GET_MAU (fact.currency_code) custom6
6586: , ROUND (
6587: NVL (
6588: DECODE (
6589: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6597: , '0-1' , fact.custom7
6598: , '1-1' , fact.custom7
6599: , 0 ) -- end decode
6600: , 0 ) -- end nvl
6601: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6602: * PJI_UTILS.GET_MAU (fact.currency_code) custom7
6603: , ROUND (
6604: NVL (
6605: DECODE (
6598: , '1-1' , fact.custom7
6599: , 0 ) -- end decode
6600: , 0 ) -- end nvl
6601: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6602: * PJI_UTILS.GET_MAU (fact.currency_code) custom7
6603: , ROUND (
6604: NVL (
6605: DECODE (
6606: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6614: , '0-1' , fact.custom8
6615: , '1-1' , fact.custom8
6616: , 0 ) -- end decode
6617: , 0 ) -- end nvl
6618: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6619: * PJI_UTILS.GET_MAU (fact.currency_code) custom8
6620: , ROUND (
6621: NVL (
6622: DECODE (
6615: , '1-1' , fact.custom8
6616: , 0 ) -- end decode
6617: , 0 ) -- end nvl
6618: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6619: * PJI_UTILS.GET_MAU (fact.currency_code) custom8
6620: , ROUND (
6621: NVL (
6622: DECODE (
6623: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6631: , '0-1' , fact.custom9
6632: , '1-1' , fact.custom9
6633: , 0 ) -- end decode
6634: , 0 ) -- end nvl
6635: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6636: * PJI_UTILS.GET_MAU (fact.currency_code) custom9
6637: , ROUND (
6638: NVL (
6639: DECODE (
6632: , '1-1' , fact.custom9
6633: , 0 ) -- end decode
6634: , 0 ) -- end nvl
6635: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6636: * PJI_UTILS.GET_MAU (fact.currency_code) custom9
6637: , ROUND (
6638: NVL (
6639: DECODE (
6640: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6648: , '0-1' , fact.custom10
6649: , '1-1' , fact.custom10
6650: , 0 ) -- end decode
6651: , 0 ) -- end nvl
6652: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6653: * PJI_UTILS.GET_MAU (fact.currency_code) custom10
6654: , ROUND (
6655: NVL (
6656: DECODE (
6649: , '1-1' , fact.custom10
6650: , 0 ) -- end decode
6651: , 0 ) -- end nvl
6652: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6653: * PJI_UTILS.GET_MAU (fact.currency_code) custom10
6654: , ROUND (
6655: NVL (
6656: DECODE (
6657: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6665: , '0-1' , fact.custom11
6666: , '1-1' , fact.custom11
6667: , 0 ) -- end decode
6668: , 0 ) -- end nvl
6669: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6670: * PJI_UTILS.GET_MAU (fact.currency_code) custom11
6671: , ROUND (
6672: NVL (
6673: DECODE (
6666: , '1-1' , fact.custom11
6667: , 0 ) -- end decode
6668: , 0 ) -- end nvl
6669: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6670: * PJI_UTILS.GET_MAU (fact.currency_code) custom11
6671: , ROUND (
6672: NVL (
6673: DECODE (
6674: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6682: , '0-1' , fact.custom12
6683: , '1-1' , fact.custom12
6684: , 0 ) -- end decode
6685: , 0 ) -- end nvl
6686: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6687: * PJI_UTILS.GET_MAU (fact.currency_code) custom12
6688: , ROUND (
6689: NVL (
6690: DECODE (
6683: , '1-1' , fact.custom12
6684: , 0 ) -- end decode
6685: , 0 ) -- end nvl
6686: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6687: * PJI_UTILS.GET_MAU (fact.currency_code) custom12
6688: , ROUND (
6689: NVL (
6690: DECODE (
6691: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6699: , '0-1' , fact.custom13
6700: , '1-1' , fact.custom13
6701: , 0 ) -- end decode
6702: , 0 ) -- end nvl
6703: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6704: * PJI_UTILS.GET_MAU (fact.currency_code) custom13
6705: , ROUND (
6706: NVL (
6707: DECODE (
6700: , '1-1' , fact.custom13
6701: , 0 ) -- end decode
6702: , 0 ) -- end nvl
6703: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6704: * PJI_UTILS.GET_MAU (fact.currency_code) custom13
6705: , ROUND (
6706: NVL (
6707: DECODE (
6708: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6716: , '0-1' , fact.custom14
6717: , '1-1' , fact.custom14
6718: , 0 ) -- end decode
6719: , 0 ) -- end nvl
6720: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6721: * PJI_UTILS.GET_MAU (fact.currency_code) custom14
6722: , ROUND (
6723: NVL (
6724: DECODE (
6717: , '1-1' , fact.custom14
6718: , 0 ) -- end decode
6719: , 0 ) -- end nvl
6720: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6721: * PJI_UTILS.GET_MAU (fact.currency_code) custom14
6722: , ROUND (
6723: NVL (
6724: DECODE (
6725: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
6733: , '0-1' , fact.custom15
6734: , '1-1' , fact.custom15
6735: , 0 ) -- end decode
6736: , 0 ) -- end nvl
6737: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6738: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
6739: , 'CN' line_type
6740: , fact.time_dangling_flag time_dangling_flag
6741: , fact.rate_dangling_flag rate_dangling_flag
6734: , '1-1' , fact.custom15
6735: , 0 ) -- end decode
6736: , 0 ) -- end nvl
6737: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
6738: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
6739: , 'CN' line_type
6740: , fact.time_dangling_flag time_dangling_flag
6741: , fact.rate_dangling_flag rate_dangling_flag
6742: , g_default_prg_level prg_level
8309: , '0-1' , fact.raw_cost
8310: , '1-1' , fact.raw_cost
8311: , 0 ) -- end decode
8312: , 0 ) -- end nvl
8313: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8314: * PJI_UTILS.GET_MAU (fact.currency_code) raw_cost
8315: , ROUND (
8316: NVL (
8317: DECODE (
8310: , '1-1' , fact.raw_cost
8311: , 0 ) -- end decode
8312: , 0 ) -- end nvl
8313: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8314: * PJI_UTILS.GET_MAU (fact.currency_code) raw_cost
8315: , ROUND (
8316: NVL (
8317: DECODE (
8318: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8326: , '0-1' , fact.brdn_cost
8327: , '1-1' , fact.brdn_cost
8328: , 0 ) -- end decode
8329: , 0 ) -- end nvl
8330: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8331: * PJI_UTILS.GET_MAU (fact.currency_code) brdn_cost
8332: , ROUND (
8333: NVL (
8334: DECODE (
8327: , '1-1' , fact.brdn_cost
8328: , 0 ) -- end decode
8329: , 0 ) -- end nvl
8330: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8331: * PJI_UTILS.GET_MAU (fact.currency_code) brdn_cost
8332: , ROUND (
8333: NVL (
8334: DECODE (
8335: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8343: , '0-1' , fact.revenue
8344: , '1-1' , fact.revenue
8345: , 0 ) -- end decode
8346: , 0 ) -- end nvl
8347: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8348: * PJI_UTILS.GET_MAU (fact.currency_code) revenue
8349: , ROUND (
8350: NVL (
8351: DECODE (
8344: , '1-1' , fact.revenue
8345: , 0 ) -- end decode
8346: , 0 ) -- end nvl
8347: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8348: * PJI_UTILS.GET_MAU (fact.currency_code) revenue
8349: , ROUND (
8350: NVL (
8351: DECODE (
8352: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8360: , '0-1' , fact.bill_raw_cost
8361: , '1-1' , fact.bill_raw_cost
8362: , 0 ) -- end decode
8363: , 0 ) -- end nvl
8364: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8365: * PJI_UTILS.GET_MAU (fact.currency_code) bill_raw_cost
8366: , ROUND (
8367: NVL (
8368: DECODE (
8361: , '1-1' , fact.bill_raw_cost
8362: , 0 ) -- end decode
8363: , 0 ) -- end nvl
8364: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8365: * PJI_UTILS.GET_MAU (fact.currency_code) bill_raw_cost
8366: , ROUND (
8367: NVL (
8368: DECODE (
8369: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8377: , '0-1' , fact.bill_brdn_cost
8378: , '1-1' , fact.bill_brdn_cost
8379: , 0 ) -- end decode
8380: , 0 ) -- end nvl
8381: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8382: * PJI_UTILS.GET_MAU (fact.currency_code) bill_brdn_cost
8383: , ROUND (
8384: NVL (
8385: DECODE (
8378: , '1-1' , fact.bill_brdn_cost
8379: , 0 ) -- end decode
8380: , 0 ) -- end nvl
8381: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8382: * PJI_UTILS.GET_MAU (fact.currency_code) bill_brdn_cost
8383: , ROUND (
8384: NVL (
8385: DECODE (
8386: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8394: , '0-1' , fact.bill_labor_raw_cost
8395: , '1-1' , fact.bill_labor_raw_cost
8396: , 0 ) -- end decode
8397: , 0 ) -- end nvl
8398: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8399: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_raw_cost
8400: , ROUND (
8401: NVL (
8402: DECODE (
8395: , '1-1' , fact.bill_labor_raw_cost
8396: , 0 ) -- end decode
8397: , 0 ) -- end nvl
8398: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8399: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_raw_cost
8400: , ROUND (
8401: NVL (
8402: DECODE (
8403: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8411: , '0-1' , fact.bill_labor_brdn_cost
8412: , '1-1' , fact.bill_labor_brdn_cost
8413: , 0 ) -- end decode
8414: , 0 ) -- end nvl
8415: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8416: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_brdn_cost
8417: , ROUND (
8418: NVL (
8419: DECODE (
8412: , '1-1' , fact.bill_labor_brdn_cost
8413: , 0 ) -- end decode
8414: , 0 ) -- end nvl
8415: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8416: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_brdn_cost
8417: , ROUND (
8418: NVL (
8419: DECODE (
8420: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8428: , '0-1' , fact.bill_labor_hrs
8429: , '1-1' , fact.bill_labor_hrs
8430: , 0 ) -- end decode
8431: , 0 ) -- end nvl
8432: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8433: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_hrs
8434: , ROUND (
8435: NVL (
8436: DECODE (
8429: , '1-1' , fact.bill_labor_hrs
8430: , 0 ) -- end decode
8431: , 0 ) -- end nvl
8432: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8433: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_hrs
8434: , ROUND (
8435: NVL (
8436: DECODE (
8437: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8445: , '0-1' , fact.equipment_raw_cost
8446: , '1-1' , fact.equipment_raw_cost
8447: , 0 ) -- end decode
8448: , 0 ) -- end nvl
8449: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8450: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_raw_cost
8451: , ROUND (
8452: NVL (
8453: DECODE (
8446: , '1-1' , fact.equipment_raw_cost
8447: , 0 ) -- end decode
8448: , 0 ) -- end nvl
8449: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8450: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_raw_cost
8451: , ROUND (
8452: NVL (
8453: DECODE (
8454: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8462: , '0-1' , fact.equipment_brdn_cost
8463: , '1-1' , fact.equipment_brdn_cost
8464: , 0 ) -- end decode
8465: , 0 ) -- end nvl
8466: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8467: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_brdn_cost
8468: , ROUND (
8469: NVL (
8470: DECODE (
8463: , '1-1' , fact.equipment_brdn_cost
8464: , 0 ) -- end decode
8465: , 0 ) -- end nvl
8466: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8467: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_brdn_cost
8468: , ROUND (
8469: NVL (
8470: DECODE (
8471: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8479: , '0-1' , fact.capitalizable_raw_cost
8480: , '1-1' , fact.capitalizable_raw_cost
8481: , 0 ) -- end decode
8482: , 0 ) -- end nvl
8483: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8484: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_raw_cost
8485: , ROUND (
8486: NVL (
8487: DECODE (
8480: , '1-1' , fact.capitalizable_raw_cost
8481: , 0 ) -- end decode
8482: , 0 ) -- end nvl
8483: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8484: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_raw_cost
8485: , ROUND (
8486: NVL (
8487: DECODE (
8488: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8496: , '0-1' , fact.capitalizable_brdn_cost
8497: , '1-1' , fact.capitalizable_brdn_cost
8498: , 0 ) -- end decode
8499: , 0 ) -- end nvl
8500: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8501: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_brdn_cost
8502: , ROUND (
8503: NVL (
8504: DECODE (
8497: , '1-1' , fact.capitalizable_brdn_cost
8498: , 0 ) -- end decode
8499: , 0 ) -- end nvl
8500: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8501: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_brdn_cost
8502: , ROUND (
8503: NVL (
8504: DECODE (
8505: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8513: , '0-1' , fact.labor_raw_cost
8514: , '1-1' , fact.labor_raw_cost
8515: , 0 ) -- end decode
8516: , 0 ) -- end nvl
8517: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8518: * PJI_UTILS.GET_MAU (fact.currency_code) labor_raw_cost
8519: , ROUND (
8520: NVL (
8521: DECODE (
8514: , '1-1' , fact.labor_raw_cost
8515: , 0 ) -- end decode
8516: , 0 ) -- end nvl
8517: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8518: * PJI_UTILS.GET_MAU (fact.currency_code) labor_raw_cost
8519: , ROUND (
8520: NVL (
8521: DECODE (
8522: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8530: , '0-1' , fact.labor_brdn_cost
8531: , '1-1' , fact.labor_brdn_cost
8532: , 0 ) -- end decode
8533: , 0 ) -- end nvl
8534: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8535: * PJI_UTILS.GET_MAU (fact.currency_code) labor_brdn_cost
8536: , ROUND (
8537: NVL (
8538: DECODE (
8531: , '1-1' , fact.labor_brdn_cost
8532: , 0 ) -- end decode
8533: , 0 ) -- end nvl
8534: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8535: * PJI_UTILS.GET_MAU (fact.currency_code) labor_brdn_cost
8536: , ROUND (
8537: NVL (
8538: DECODE (
8539: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8547: , '0-1' , fact.labor_hrs
8548: , '1-1' , fact.labor_hrs
8549: , 0 ) -- end decode
8550: , 0 ) -- end nvl
8551: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8552: * PJI_UTILS.GET_MAU (fact.currency_code) labor_hrs
8553: , ROUND (
8554: NVL (
8555: DECODE (
8548: , '1-1' , fact.labor_hrs
8549: , 0 ) -- end decode
8550: , 0 ) -- end nvl
8551: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8552: * PJI_UTILS.GET_MAU (fact.currency_code) labor_hrs
8553: , ROUND (
8554: NVL (
8555: DECODE (
8556: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8564: , '0-1' , fact.labor_revenue
8565: , '1-1' , fact.labor_revenue
8566: , 0 ) -- end decode
8567: , 0 ) -- end nvl
8568: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8569: * PJI_UTILS.GET_MAU (fact.currency_code) labor_revenue
8570: , ROUND (
8571: NVL (
8572: DECODE (
8565: , '1-1' , fact.labor_revenue
8566: , 0 ) -- end decode
8567: , 0 ) -- end nvl
8568: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8569: * PJI_UTILS.GET_MAU (fact.currency_code) labor_revenue
8570: , ROUND (
8571: NVL (
8572: DECODE (
8573: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8581: , '0-1' , fact.equipment_hours
8582: , '1-1' , fact.equipment_hours
8583: , 0 ) -- end decode
8584: , 0 ) -- end nvl
8585: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8586: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_hours
8587: , ROUND (
8588: NVL (
8589: DECODE (
8582: , '1-1' , fact.equipment_hours
8583: , 0 ) -- end decode
8584: , 0 ) -- end nvl
8585: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8586: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_hours
8587: , ROUND (
8588: NVL (
8589: DECODE (
8590: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8598: , '0-1' , fact.billable_equipment_hours
8599: , '1-1' , fact.billable_equipment_hours
8600: , 0 ) -- end decode
8601: , 0 ) -- end nvl
8602: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8603: * PJI_UTILS.GET_MAU (fact.currency_code) billable_equipment_hours
8604: , ROUND (
8605: NVL (
8606: DECODE (
8599: , '1-1' , fact.billable_equipment_hours
8600: , 0 ) -- end decode
8601: , 0 ) -- end nvl
8602: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8603: * PJI_UTILS.GET_MAU (fact.currency_code) billable_equipment_hours
8604: , ROUND (
8605: NVL (
8606: DECODE (
8607: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8615: , '0-1' , fact.sup_inv_committed_cost
8616: , '1-1' , fact.sup_inv_committed_cost
8617: , 0 ) -- end decode
8618: , 0 ) -- end nvl
8619: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8620: * PJI_UTILS.GET_MAU (fact.currency_code) sup_inv_committed_cost
8621: , ROUND (
8622: NVL (
8623: DECODE (
8616: , '1-1' , fact.sup_inv_committed_cost
8617: , 0 ) -- end decode
8618: , 0 ) -- end nvl
8619: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8620: * PJI_UTILS.GET_MAU (fact.currency_code) sup_inv_committed_cost
8621: , ROUND (
8622: NVL (
8623: DECODE (
8624: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8632: , '0-1' , fact.po_committed_cost
8633: , '1-1' , fact.po_committed_cost
8634: , 0 ) -- end decode
8635: , 0 ) -- end nvl
8636: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8637: * PJI_UTILS.GET_MAU (fact.currency_code) po_committed_cost
8638: , ROUND (
8639: NVL (
8640: DECODE (
8633: , '1-1' , fact.po_committed_cost
8634: , 0 ) -- end decode
8635: , 0 ) -- end nvl
8636: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8637: * PJI_UTILS.GET_MAU (fact.currency_code) po_committed_cost
8638: , ROUND (
8639: NVL (
8640: DECODE (
8641: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8649: , '0-1' , fact.pr_committed_cost
8650: , '1-1' , fact.pr_committed_cost
8651: , 0 ) -- end decode
8652: , 0 ) -- end nvl
8653: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8654: * PJI_UTILS.GET_MAU (fact.currency_code) pr_committed_cost
8655: , ROUND (
8656: NVL (
8657: DECODE (
8650: , '1-1' , fact.pr_committed_cost
8651: , 0 ) -- end decode
8652: , 0 ) -- end nvl
8653: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8654: * PJI_UTILS.GET_MAU (fact.currency_code) pr_committed_cost
8655: , ROUND (
8656: NVL (
8657: DECODE (
8658: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8666: , '0-1' , fact.oth_committed_cost
8667: , '1-1' , fact.oth_committed_cost
8668: , 0 ) -- end decode
8669: , 0 ) -- end nvl
8670: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8671: * PJI_UTILS.GET_MAU (fact.currency_code) oth_committed_cost
8672: , ROUND (
8673: NVL (
8674: DECODE (
8667: , '1-1' , fact.oth_committed_cost
8668: , 0 ) -- end decode
8669: , 0 ) -- end nvl
8670: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8671: * PJI_UTILS.GET_MAU (fact.currency_code) oth_committed_cost
8672: , ROUND (
8673: NVL (
8674: DECODE (
8675: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8683: , '0-1' , fact.ACT_LABOR_HRS
8684: , '1-1' , fact.ACT_LABOR_HRS
8685: , 0 ) -- end decode
8686: , 0 ) -- end nvl
8687: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8688: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_HRS
8689: , ROUND (
8690: NVL (
8691: DECODE (
8684: , '1-1' , fact.ACT_LABOR_HRS
8685: , 0 ) -- end decode
8686: , 0 ) -- end nvl
8687: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8688: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_HRS
8689: , ROUND (
8690: NVL (
8691: DECODE (
8692: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8700: , '0-1' , fact.ACT_EQUIP_HRS
8701: , '1-1' , fact.ACT_EQUIP_HRS
8702: , 0 ) -- end decode
8703: , 0 ) -- end nvl
8704: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8705: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_HRS
8706: , ROUND (
8707: NVL (
8708: DECODE (
8701: , '1-1' , fact.ACT_EQUIP_HRS
8702: , 0 ) -- end decode
8703: , 0 ) -- end nvl
8704: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8705: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_HRS
8706: , ROUND (
8707: NVL (
8708: DECODE (
8709: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8717: , '0-1' , fact.ACT_LABOR_BRDN_COST
8718: , '1-1' , fact.ACT_LABOR_BRDN_COST
8719: , 0 ) -- end decode
8720: , 0 ) -- end nvl
8721: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8722: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_BRDN_COST
8723: , ROUND (
8724: NVL (
8725: DECODE (
8718: , '1-1' , fact.ACT_LABOR_BRDN_COST
8719: , 0 ) -- end decode
8720: , 0 ) -- end nvl
8721: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8722: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_BRDN_COST
8723: , ROUND (
8724: NVL (
8725: DECODE (
8726: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8734: , '0-1' , fact.ACT_EQUIP_BRDN_COST
8735: , '1-1' , fact.ACT_EQUIP_BRDN_COST
8736: , 0 ) -- end decode
8737: , 0 ) -- end nvl
8738: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8739: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_BRDN_COST
8740: , ROUND (
8741: NVL (
8742: DECODE (
8735: , '1-1' , fact.ACT_EQUIP_BRDN_COST
8736: , 0 ) -- end decode
8737: , 0 ) -- end nvl
8738: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8739: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_BRDN_COST
8740: , ROUND (
8741: NVL (
8742: DECODE (
8743: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8751: , '0-1' , fact.ACT_BRDN_COST
8752: , '1-1' , fact.ACT_BRDN_COST
8753: , 0 ) -- end decode
8754: , 0 ) -- end nvl
8755: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8756: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_BRDN_COST
8757: , ROUND (
8758: NVL (
8759: DECODE (
8752: , '1-1' , fact.ACT_BRDN_COST
8753: , 0 ) -- end decode
8754: , 0 ) -- end nvl
8755: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8756: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_BRDN_COST
8757: , ROUND (
8758: NVL (
8759: DECODE (
8760: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8768: , '0-1' , fact.ACT_RAW_COST
8769: , '1-1' , fact.ACT_RAW_COST
8770: , 0 ) -- end decode
8771: , 0 ) -- end nvl
8772: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8773: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_RAW_COST
8774: , ROUND (
8775: NVL (
8776: DECODE (
8769: , '1-1' , fact.ACT_RAW_COST
8770: , 0 ) -- end decode
8771: , 0 ) -- end nvl
8772: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8773: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_RAW_COST
8774: , ROUND (
8775: NVL (
8776: DECODE (
8777: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8785: , '0-1' , fact.ACT_REVENUE
8786: , '1-1' , fact.ACT_REVENUE
8787: , 0 ) -- end decode
8788: , 0 ) -- end nvl
8789: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8790: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_REVENUE
8791: , ROUND (
8792: NVL (
8793: DECODE (
8786: , '1-1' , fact.ACT_REVENUE
8787: , 0 ) -- end decode
8788: , 0 ) -- end nvl
8789: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8790: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_REVENUE
8791: , ROUND (
8792: NVL (
8793: DECODE (
8794: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8802: , '0-1' , fact.ACT_LABOR_RAW_COST
8803: , '1-1' , fact.ACT_LABOR_RAW_COST
8804: , 0 ) -- end decode
8805: , 0 ) -- end nvl
8806: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8807: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_RAW_COST
8808: , ROUND (
8809: NVL (
8810: DECODE (
8803: , '1-1' , fact.ACT_LABOR_RAW_COST
8804: , 0 ) -- end decode
8805: , 0 ) -- end nvl
8806: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8807: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_RAW_COST
8808: , ROUND (
8809: NVL (
8810: DECODE (
8811: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8819: , '0-1' , fact.ACT_EQUIP_RAW_COST
8820: , '1-1' , fact.ACT_EQUIP_RAW_COST
8821: , 0 ) -- end decode
8822: , 0 ) -- end nvl
8823: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8824: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_RAW_COST
8825: , ROUND (
8826: NVL (
8827: DECODE (
8820: , '1-1' , fact.ACT_EQUIP_RAW_COST
8821: , 0 ) -- end decode
8822: , 0 ) -- end nvl
8823: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8824: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_RAW_COST
8825: , ROUND (
8826: NVL (
8827: DECODE (
8828: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8836: , '0-1' , fact.ETC_LABOR_HRS
8837: , '1-1' , fact.ETC_LABOR_HRS
8838: , 0 ) -- end decode
8839: , 0 ) -- end nvl
8840: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8841: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_HRS
8842: , ROUND (
8843: NVL (
8844: DECODE (
8837: , '1-1' , fact.ETC_LABOR_HRS
8838: , 0 ) -- end decode
8839: , 0 ) -- end nvl
8840: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8841: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_HRS
8842: , ROUND (
8843: NVL (
8844: DECODE (
8845: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8853: , '0-1' , fact.ETC_EQUIP_HRS
8854: , '1-1' , fact.ETC_EQUIP_HRS
8855: , 0 ) -- end decode
8856: , 0 ) -- end nvl
8857: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8858: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_HRS
8859: , ROUND (
8860: NVL (
8861: DECODE (
8854: , '1-1' , fact.ETC_EQUIP_HRS
8855: , 0 ) -- end decode
8856: , 0 ) -- end nvl
8857: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8858: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_HRS
8859: , ROUND (
8860: NVL (
8861: DECODE (
8862: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8870: , '0-1' , fact.ETC_LABOR_BRDN_COST
8871: , '1-1' , fact.ETC_LABOR_BRDN_COST
8872: , 0 ) -- end decode
8873: , 0 ) -- end nvl
8874: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8875: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_BRDN_COST
8876: , ROUND (
8877: NVL (
8878: DECODE (
8871: , '1-1' , fact.ETC_LABOR_BRDN_COST
8872: , 0 ) -- end decode
8873: , 0 ) -- end nvl
8874: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8875: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_BRDN_COST
8876: , ROUND (
8877: NVL (
8878: DECODE (
8879: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8887: , '0-1' , fact.ETC_EQUIP_BRDN_COST
8888: , '1-1' , fact.ETC_EQUIP_BRDN_COST
8889: , 0 ) -- end decode
8890: , 0 ) -- end nvl
8891: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8892: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_BRDN_COST
8893: , ROUND (
8894: NVL (
8895: DECODE (
8888: , '1-1' , fact.ETC_EQUIP_BRDN_COST
8889: , 0 ) -- end decode
8890: , 0 ) -- end nvl
8891: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8892: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_BRDN_COST
8893: , ROUND (
8894: NVL (
8895: DECODE (
8896: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8904: , '0-1' , fact.ETC_BRDN_COST
8905: , '1-1' , fact.ETC_BRDN_COST
8906: , 0 ) -- end decode
8907: , 0 ) -- end nvl
8908: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8909: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_BRDN_COST
8910: , ROUND (
8911: NVL (
8912: DECODE (
8905: , '1-1' , fact.ETC_BRDN_COST
8906: , 0 ) -- end decode
8907: , 0 ) -- end nvl
8908: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8909: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_BRDN_COST
8910: , ROUND (
8911: NVL (
8912: DECODE (
8913: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8921: , '0-1' , fact.ETC_RAW_COST
8922: , '1-1' , fact.ETC_RAW_COST
8923: , 0 ) -- end decode
8924: , 0 ) -- end nvl
8925: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8926: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_RAW_COST
8927: , ROUND (
8928: NVL (
8929: DECODE (
8922: , '1-1' , fact.ETC_RAW_COST
8923: , 0 ) -- end decode
8924: , 0 ) -- end nvl
8925: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8926: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_RAW_COST
8927: , ROUND (
8928: NVL (
8929: DECODE (
8930: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8938: , '0-1' , fact.ETC_LABOR_RAW_COST
8939: , '1-1' , fact.ETC_LABOR_RAW_COST
8940: , 0 ) -- end decode
8941: , 0 ) -- end nvl
8942: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8943: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_RAW_COST
8944: , ROUND (
8945: NVL (
8946: DECODE (
8939: , '1-1' , fact.ETC_LABOR_RAW_COST
8940: , 0 ) -- end decode
8941: , 0 ) -- end nvl
8942: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8943: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_RAW_COST
8944: , ROUND (
8945: NVL (
8946: DECODE (
8947: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8955: , '0-1' , fact.ETC_EQUIP_RAW_COST
8956: , '1-1' , fact.ETC_EQUIP_RAW_COST
8957: , 0 ) -- end decode
8958: , 0 ) -- end nvl
8959: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8960: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_RAW_COST
8961: , ROUND (
8962: NVL (
8963: DECODE (
8956: , '1-1' , fact.ETC_EQUIP_RAW_COST
8957: , 0 ) -- end decode
8958: , 0 ) -- end nvl
8959: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8960: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_RAW_COST
8961: , ROUND (
8962: NVL (
8963: DECODE (
8964: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8972: , '0-1' , fact.custom1
8973: , '1-1' , fact.custom1
8974: , 0 ) -- end decode
8975: , 0 ) -- end nvl
8976: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8977: * PJI_UTILS.GET_MAU (fact.currency_code) custom1
8978: , ROUND (
8979: NVL (
8980: DECODE (
8973: , '1-1' , fact.custom1
8974: , 0 ) -- end decode
8975: , 0 ) -- end nvl
8976: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8977: * PJI_UTILS.GET_MAU (fact.currency_code) custom1
8978: , ROUND (
8979: NVL (
8980: DECODE (
8981: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
8989: , '0-1' , fact.custom2
8990: , '1-1' , fact.custom2
8991: , 0 ) -- end decode
8992: , 0 ) -- end nvl
8993: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8994: * PJI_UTILS.GET_MAU (fact.currency_code) custom2
8995: , ROUND (
8996: NVL (
8997: DECODE (
8990: , '1-1' , fact.custom2
8991: , 0 ) -- end decode
8992: , 0 ) -- end nvl
8993: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
8994: * PJI_UTILS.GET_MAU (fact.currency_code) custom2
8995: , ROUND (
8996: NVL (
8997: DECODE (
8998: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9006: , '0-1' , fact.custom3
9007: , '1-1' , fact.custom3
9008: , 0 ) -- end decode
9009: , 0 ) -- end nvl
9010: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9011: * PJI_UTILS.GET_MAU (fact.currency_code) custom3
9012: , ROUND (
9013: NVL (
9014: DECODE (
9007: , '1-1' , fact.custom3
9008: , 0 ) -- end decode
9009: , 0 ) -- end nvl
9010: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9011: * PJI_UTILS.GET_MAU (fact.currency_code) custom3
9012: , ROUND (
9013: NVL (
9014: DECODE (
9015: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9023: , '0-1' , fact.custom4
9024: , '1-1' , fact.custom4
9025: , 0 ) -- end decode
9026: , 0 ) -- end nvl
9027: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9028: * PJI_UTILS.GET_MAU (fact.currency_code) custom4
9029: , ROUND (
9030: NVL (
9031: DECODE (
9024: , '1-1' , fact.custom4
9025: , 0 ) -- end decode
9026: , 0 ) -- end nvl
9027: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9028: * PJI_UTILS.GET_MAU (fact.currency_code) custom4
9029: , ROUND (
9030: NVL (
9031: DECODE (
9032: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9040: , '0-1' , fact.custom5
9041: , '1-1' , fact.custom5
9042: , 0 ) -- end decode
9043: , 0 ) -- end nvl
9044: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9045: * PJI_UTILS.GET_MAU (fact.currency_code) custom5
9046: , ROUND (
9047: NVL (
9048: DECODE (
9041: , '1-1' , fact.custom5
9042: , 0 ) -- end decode
9043: , 0 ) -- end nvl
9044: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9045: * PJI_UTILS.GET_MAU (fact.currency_code) custom5
9046: , ROUND (
9047: NVL (
9048: DECODE (
9049: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9057: , '0-1' , fact.custom6
9058: , '1-1' , fact.custom6
9059: , 0 ) -- end decode
9060: , 0 ) -- end nvl
9061: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9062: * PJI_UTILS.GET_MAU (fact.currency_code) custom6
9063: , ROUND (
9064: NVL (
9065: DECODE (
9058: , '1-1' , fact.custom6
9059: , 0 ) -- end decode
9060: , 0 ) -- end nvl
9061: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9062: * PJI_UTILS.GET_MAU (fact.currency_code) custom6
9063: , ROUND (
9064: NVL (
9065: DECODE (
9066: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9074: , '0-1' , fact.custom7
9075: , '1-1' , fact.custom7
9076: , 0 ) -- end decode
9077: , 0 ) -- end nvl
9078: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9079: * PJI_UTILS.GET_MAU (fact.currency_code) custom7
9080: , ROUND (
9081: NVL (
9082: DECODE (
9075: , '1-1' , fact.custom7
9076: , 0 ) -- end decode
9077: , 0 ) -- end nvl
9078: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9079: * PJI_UTILS.GET_MAU (fact.currency_code) custom7
9080: , ROUND (
9081: NVL (
9082: DECODE (
9083: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9091: , '0-1' , fact.custom8
9092: , '1-1' , fact.custom8
9093: , 0 ) -- end decode
9094: , 0 ) -- end nvl
9095: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9096: * PJI_UTILS.GET_MAU (fact.currency_code) custom8
9097: , ROUND (
9098: NVL (
9099: DECODE (
9092: , '1-1' , fact.custom8
9093: , 0 ) -- end decode
9094: , 0 ) -- end nvl
9095: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9096: * PJI_UTILS.GET_MAU (fact.currency_code) custom8
9097: , ROUND (
9098: NVL (
9099: DECODE (
9100: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9108: , '0-1' , fact.custom9
9109: , '1-1' , fact.custom9
9110: , 0 ) -- end decode
9111: , 0 ) -- end nvl
9112: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9113: * PJI_UTILS.GET_MAU (fact.currency_code) custom9
9114: , ROUND (
9115: NVL (
9116: DECODE (
9109: , '1-1' , fact.custom9
9110: , 0 ) -- end decode
9111: , 0 ) -- end nvl
9112: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9113: * PJI_UTILS.GET_MAU (fact.currency_code) custom9
9114: , ROUND (
9115: NVL (
9116: DECODE (
9117: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9125: , '0-1' , fact.custom10
9126: , '1-1' , fact.custom10
9127: , 0 ) -- end decode
9128: , 0 ) -- end nvl
9129: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9130: * PJI_UTILS.GET_MAU (fact.currency_code) custom10
9131: , ROUND (
9132: NVL (
9133: DECODE (
9126: , '1-1' , fact.custom10
9127: , 0 ) -- end decode
9128: , 0 ) -- end nvl
9129: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9130: * PJI_UTILS.GET_MAU (fact.currency_code) custom10
9131: , ROUND (
9132: NVL (
9133: DECODE (
9134: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9142: , '0-1' , fact.custom11
9143: , '1-1' , fact.custom11
9144: , 0 ) -- end decode
9145: , 0 ) -- end nvl
9146: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9147: * PJI_UTILS.GET_MAU (fact.currency_code) custom11
9148: , ROUND (
9149: NVL (
9150: DECODE (
9143: , '1-1' , fact.custom11
9144: , 0 ) -- end decode
9145: , 0 ) -- end nvl
9146: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9147: * PJI_UTILS.GET_MAU (fact.currency_code) custom11
9148: , ROUND (
9149: NVL (
9150: DECODE (
9151: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9159: , '0-1' , fact.custom12
9160: , '1-1' , fact.custom12
9161: , 0 ) -- end decode
9162: , 0 ) -- end nvl
9163: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9164: * PJI_UTILS.GET_MAU (fact.currency_code) custom12
9165: , ROUND (
9166: NVL (
9167: DECODE (
9160: , '1-1' , fact.custom12
9161: , 0 ) -- end decode
9162: , 0 ) -- end nvl
9163: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9164: * PJI_UTILS.GET_MAU (fact.currency_code) custom12
9165: , ROUND (
9166: NVL (
9167: DECODE (
9168: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9176: , '0-1' , fact.custom13
9177: , '1-1' , fact.custom13
9178: , 0 ) -- end decode
9179: , 0 ) -- end nvl
9180: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9181: * PJI_UTILS.GET_MAU (fact.currency_code) custom13
9182: , ROUND (
9183: NVL (
9184: DECODE (
9177: , '1-1' , fact.custom13
9178: , 0 ) -- end decode
9179: , 0 ) -- end nvl
9180: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9181: * PJI_UTILS.GET_MAU (fact.currency_code) custom13
9182: , ROUND (
9183: NVL (
9184: DECODE (
9185: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9193: , '0-1' , fact.custom14
9194: , '1-1' , fact.custom14
9195: , 0 ) -- end decode
9196: , 0 ) -- end nvl
9197: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9198: * PJI_UTILS.GET_MAU (fact.currency_code) custom14
9199: , ROUND (
9200: NVL (
9201: DECODE (
9194: , '1-1' , fact.custom14
9195: , 0 ) -- end decode
9196: , 0 ) -- end nvl
9197: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9198: * PJI_UTILS.GET_MAU (fact.currency_code) custom14
9199: , ROUND (
9200: NVL (
9201: DECODE (
9202: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9210: , '0-1' , fact.custom15
9211: , '1-1' , fact.custom15
9212: , 0 ) -- end decode
9213: , 0 ) -- end nvl
9214: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9215: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
9216: , 'CF' line_type
9217: , fact.time_dangling_flag time_dangling_flag
9218: , fact.rate_dangling_flag rate_dangling_flag
9211: , '1-1' , fact.custom15
9212: , 0 ) -- end decode
9213: , 0 ) -- end nvl
9214: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9215: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
9216: , 'CF' line_type
9217: , fact.time_dangling_flag time_dangling_flag
9218: , fact.rate_dangling_flag rate_dangling_flag
9219: FROM pji_fp_aggr_pjp1_t fact
9775: , '0-1' , fact.raw_cost
9776: , '1-1' , fact.raw_cost
9777: , 0 ) -- end decode
9778: , 0 ) -- end nvl
9779: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9780: * PJI_UTILS.GET_MAU (fact.currency_code) raw_cost
9781: , ROUND (
9782: NVL (
9783: DECODE (
9776: , '1-1' , fact.raw_cost
9777: , 0 ) -- end decode
9778: , 0 ) -- end nvl
9779: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9780: * PJI_UTILS.GET_MAU (fact.currency_code) raw_cost
9781: , ROUND (
9782: NVL (
9783: DECODE (
9784: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9792: , '0-1' , fact.brdn_cost
9793: , '1-1' , fact.brdn_cost
9794: , 0 ) -- end decode
9795: , 0 ) -- end nvl
9796: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9797: * PJI_UTILS.GET_MAU (fact.currency_code) brdn_cost
9798: , ROUND (
9799: NVL (
9800: DECODE (
9793: , '1-1' , fact.brdn_cost
9794: , 0 ) -- end decode
9795: , 0 ) -- end nvl
9796: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9797: * PJI_UTILS.GET_MAU (fact.currency_code) brdn_cost
9798: , ROUND (
9799: NVL (
9800: DECODE (
9801: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9809: , '0-1' , fact.revenue
9810: , '1-1' , fact.revenue
9811: , 0 ) -- end decode
9812: , 0 ) -- end nvl
9813: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9814: * PJI_UTILS.GET_MAU (fact.currency_code) revenue
9815: , ROUND (
9816: NVL (
9817: DECODE (
9810: , '1-1' , fact.revenue
9811: , 0 ) -- end decode
9812: , 0 ) -- end nvl
9813: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9814: * PJI_UTILS.GET_MAU (fact.currency_code) revenue
9815: , ROUND (
9816: NVL (
9817: DECODE (
9818: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9826: , '0-1' , fact.bill_raw_cost
9827: , '1-1' , fact.bill_raw_cost
9828: , 0 ) -- end decode
9829: , 0 ) -- end nvl
9830: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9831: * PJI_UTILS.GET_MAU (fact.currency_code) bill_raw_cost
9832: , ROUND (
9833: NVL (
9834: DECODE (
9827: , '1-1' , fact.bill_raw_cost
9828: , 0 ) -- end decode
9829: , 0 ) -- end nvl
9830: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9831: * PJI_UTILS.GET_MAU (fact.currency_code) bill_raw_cost
9832: , ROUND (
9833: NVL (
9834: DECODE (
9835: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9843: , '0-1' , fact.bill_brdn_cost
9844: , '1-1' , fact.bill_brdn_cost
9845: , 0 ) -- end decode
9846: , 0 ) -- end nvl
9847: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9848: * PJI_UTILS.GET_MAU (fact.currency_code) bill_brdn_cost
9849: , ROUND (
9850: NVL (
9851: DECODE (
9844: , '1-1' , fact.bill_brdn_cost
9845: , 0 ) -- end decode
9846: , 0 ) -- end nvl
9847: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9848: * PJI_UTILS.GET_MAU (fact.currency_code) bill_brdn_cost
9849: , ROUND (
9850: NVL (
9851: DECODE (
9852: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9860: , '0-1' , fact.bill_labor_raw_cost
9861: , '1-1' , fact.bill_labor_raw_cost
9862: , 0 ) -- end decode
9863: , 0 ) -- end nvl
9864: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9865: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_raw_cost
9866: , ROUND (
9867: NVL (
9868: DECODE (
9861: , '1-1' , fact.bill_labor_raw_cost
9862: , 0 ) -- end decode
9863: , 0 ) -- end nvl
9864: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9865: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_raw_cost
9866: , ROUND (
9867: NVL (
9868: DECODE (
9869: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9877: , '0-1' , fact.bill_labor_brdn_cost
9878: , '1-1' , fact.bill_labor_brdn_cost
9879: , 0 ) -- end decode
9880: , 0 ) -- end nvl
9881: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9882: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_brdn_cost
9883: , ROUND (
9884: NVL (
9885: DECODE (
9878: , '1-1' , fact.bill_labor_brdn_cost
9879: , 0 ) -- end decode
9880: , 0 ) -- end nvl
9881: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9882: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_brdn_cost
9883: , ROUND (
9884: NVL (
9885: DECODE (
9886: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9894: , '0-1' , fact.bill_labor_hrs
9895: , '1-1' , fact.bill_labor_hrs
9896: , 0 ) -- end decode
9897: , 0 ) -- end nvl
9898: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9899: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_hrs
9900: , ROUND (
9901: NVL (
9902: DECODE (
9895: , '1-1' , fact.bill_labor_hrs
9896: , 0 ) -- end decode
9897: , 0 ) -- end nvl
9898: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9899: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_hrs
9900: , ROUND (
9901: NVL (
9902: DECODE (
9903: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9911: , '0-1' , fact.equipment_raw_cost
9912: , '1-1' , fact.equipment_raw_cost
9913: , 0 ) -- end decode
9914: , 0 ) -- end nvl
9915: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9916: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_raw_cost
9917: , ROUND (
9918: NVL (
9919: DECODE (
9912: , '1-1' , fact.equipment_raw_cost
9913: , 0 ) -- end decode
9914: , 0 ) -- end nvl
9915: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9916: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_raw_cost
9917: , ROUND (
9918: NVL (
9919: DECODE (
9920: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9928: , '0-1' , fact.equipment_brdn_cost
9929: , '1-1' , fact.equipment_brdn_cost
9930: , 0 ) -- end decode
9931: , 0 ) -- end nvl
9932: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9933: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_brdn_cost
9934: , ROUND (
9935: NVL (
9936: DECODE (
9929: , '1-1' , fact.equipment_brdn_cost
9930: , 0 ) -- end decode
9931: , 0 ) -- end nvl
9932: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9933: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_brdn_cost
9934: , ROUND (
9935: NVL (
9936: DECODE (
9937: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9945: , '0-1' , fact.capitalizable_raw_cost
9946: , '1-1' , fact.capitalizable_raw_cost
9947: , 0 ) -- end decode
9948: , 0 ) -- end nvl
9949: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9950: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_raw_cost
9951: , ROUND (
9952: NVL (
9953: DECODE (
9946: , '1-1' , fact.capitalizable_raw_cost
9947: , 0 ) -- end decode
9948: , 0 ) -- end nvl
9949: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9950: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_raw_cost
9951: , ROUND (
9952: NVL (
9953: DECODE (
9954: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9962: , '0-1' , fact.capitalizable_brdn_cost
9963: , '1-1' , fact.capitalizable_brdn_cost
9964: , 0 ) -- end decode
9965: , 0 ) -- end nvl
9966: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9967: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_brdn_cost
9968: , ROUND (
9969: NVL (
9970: DECODE (
9963: , '1-1' , fact.capitalizable_brdn_cost
9964: , 0 ) -- end decode
9965: , 0 ) -- end nvl
9966: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9967: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_brdn_cost
9968: , ROUND (
9969: NVL (
9970: DECODE (
9971: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9979: , '0-1' , fact.labor_raw_cost
9980: , '1-1' , fact.labor_raw_cost
9981: , 0 ) -- end decode
9982: , 0 ) -- end nvl
9983: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9984: * PJI_UTILS.GET_MAU (fact.currency_code) labor_raw_cost
9985: , ROUND (
9986: NVL (
9987: DECODE (
9980: , '1-1' , fact.labor_raw_cost
9981: , 0 ) -- end decode
9982: , 0 ) -- end nvl
9983: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
9984: * PJI_UTILS.GET_MAU (fact.currency_code) labor_raw_cost
9985: , ROUND (
9986: NVL (
9987: DECODE (
9988: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
9996: , '0-1' , fact.labor_brdn_cost
9997: , '1-1' , fact.labor_brdn_cost
9998: , 0 ) -- end decode
9999: , 0 ) -- end nvl
10000: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10001: * PJI_UTILS.GET_MAU (fact.currency_code) labor_brdn_cost
10002: , ROUND (
10003: NVL (
10004: DECODE (
9997: , '1-1' , fact.labor_brdn_cost
9998: , 0 ) -- end decode
9999: , 0 ) -- end nvl
10000: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10001: * PJI_UTILS.GET_MAU (fact.currency_code) labor_brdn_cost
10002: , ROUND (
10003: NVL (
10004: DECODE (
10005: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10013: , '0-1' , fact.labor_hrs
10014: , '1-1' , fact.labor_hrs
10015: , 0 ) -- end decode
10016: , 0 ) -- end nvl
10017: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10018: * PJI_UTILS.GET_MAU (fact.currency_code) labor_hrs
10019: , ROUND (
10020: NVL (
10021: DECODE (
10014: , '1-1' , fact.labor_hrs
10015: , 0 ) -- end decode
10016: , 0 ) -- end nvl
10017: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10018: * PJI_UTILS.GET_MAU (fact.currency_code) labor_hrs
10019: , ROUND (
10020: NVL (
10021: DECODE (
10022: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10030: , '0-1' , fact.labor_revenue
10031: , '1-1' , fact.labor_revenue
10032: , 0 ) -- end decode
10033: , 0 ) -- end nvl
10034: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10035: * PJI_UTILS.GET_MAU (fact.currency_code) labor_revenue
10036: , ROUND (
10037: NVL (
10038: DECODE (
10031: , '1-1' , fact.labor_revenue
10032: , 0 ) -- end decode
10033: , 0 ) -- end nvl
10034: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10035: * PJI_UTILS.GET_MAU (fact.currency_code) labor_revenue
10036: , ROUND (
10037: NVL (
10038: DECODE (
10039: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10047: , '0-1' , fact.equipment_hours
10048: , '1-1' , fact.equipment_hours
10049: , 0 ) -- end decode
10050: , 0 ) -- end nvl
10051: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10052: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_hours
10053: , ROUND (
10054: NVL (
10055: DECODE (
10048: , '1-1' , fact.equipment_hours
10049: , 0 ) -- end decode
10050: , 0 ) -- end nvl
10051: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10052: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_hours
10053: , ROUND (
10054: NVL (
10055: DECODE (
10056: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10064: , '0-1' , fact.billable_equipment_hours
10065: , '1-1' , fact.billable_equipment_hours
10066: , 0 ) -- end decode
10067: , 0 ) -- end nvl
10068: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10069: * PJI_UTILS.GET_MAU (fact.currency_code) billable_equipment_hours
10070: , ROUND (
10071: NVL (
10072: DECODE (
10065: , '1-1' , fact.billable_equipment_hours
10066: , 0 ) -- end decode
10067: , 0 ) -- end nvl
10068: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10069: * PJI_UTILS.GET_MAU (fact.currency_code) billable_equipment_hours
10070: , ROUND (
10071: NVL (
10072: DECODE (
10073: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10081: , '0-1' , fact.sup_inv_committed_cost
10082: , '1-1' , fact.sup_inv_committed_cost
10083: , 0 ) -- end decode
10084: , 0 ) -- end nvl
10085: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10086: * PJI_UTILS.GET_MAU (fact.currency_code) sup_inv_committed_cost
10087: , ROUND (
10088: NVL (
10089: DECODE (
10082: , '1-1' , fact.sup_inv_committed_cost
10083: , 0 ) -- end decode
10084: , 0 ) -- end nvl
10085: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10086: * PJI_UTILS.GET_MAU (fact.currency_code) sup_inv_committed_cost
10087: , ROUND (
10088: NVL (
10089: DECODE (
10090: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10098: , '0-1' , fact.po_committed_cost
10099: , '1-1' , fact.po_committed_cost
10100: , 0 ) -- end decode
10101: , 0 ) -- end nvl
10102: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10103: * PJI_UTILS.GET_MAU (fact.currency_code) po_committed_cost
10104: , ROUND (
10105: NVL (
10106: DECODE (
10099: , '1-1' , fact.po_committed_cost
10100: , 0 ) -- end decode
10101: , 0 ) -- end nvl
10102: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10103: * PJI_UTILS.GET_MAU (fact.currency_code) po_committed_cost
10104: , ROUND (
10105: NVL (
10106: DECODE (
10107: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10115: , '0-1' , fact.pr_committed_cost
10116: , '1-1' , fact.pr_committed_cost
10117: , 0 ) -- end decode
10118: , 0 ) -- end nvl
10119: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10120: * PJI_UTILS.GET_MAU (fact.currency_code) pr_committed_cost
10121: , ROUND (
10122: NVL (
10123: DECODE (
10116: , '1-1' , fact.pr_committed_cost
10117: , 0 ) -- end decode
10118: , 0 ) -- end nvl
10119: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10120: * PJI_UTILS.GET_MAU (fact.currency_code) pr_committed_cost
10121: , ROUND (
10122: NVL (
10123: DECODE (
10124: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10132: , '0-1' , fact.oth_committed_cost
10133: , '1-1' , fact.oth_committed_cost
10134: , 0 ) -- end decode
10135: , 0 ) -- end nvl
10136: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10137: * PJI_UTILS.GET_MAU (fact.currency_code) oth_committed_cost
10138: , ROUND (
10139: NVL (
10140: DECODE (
10133: , '1-1' , fact.oth_committed_cost
10134: , 0 ) -- end decode
10135: , 0 ) -- end nvl
10136: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10137: * PJI_UTILS.GET_MAU (fact.currency_code) oth_committed_cost
10138: , ROUND (
10139: NVL (
10140: DECODE (
10141: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10149: , '0-1' , fact.ACT_LABOR_HRS
10150: , '1-1' , fact.ACT_LABOR_HRS
10151: , 0 ) -- end decode
10152: , 0 ) -- end nvl
10153: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10154: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_HRS
10155: , ROUND (
10156: NVL (
10157: DECODE (
10150: , '1-1' , fact.ACT_LABOR_HRS
10151: , 0 ) -- end decode
10152: , 0 ) -- end nvl
10153: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10154: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_HRS
10155: , ROUND (
10156: NVL (
10157: DECODE (
10158: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10166: , '0-1' , fact.ACT_EQUIP_HRS
10167: , '1-1' , fact.ACT_EQUIP_HRS
10168: , 0 ) -- end decode
10169: , 0 ) -- end nvl
10170: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10171: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_HRS
10172: , ROUND (
10173: NVL (
10174: DECODE (
10167: , '1-1' , fact.ACT_EQUIP_HRS
10168: , 0 ) -- end decode
10169: , 0 ) -- end nvl
10170: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10171: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_HRS
10172: , ROUND (
10173: NVL (
10174: DECODE (
10175: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10183: , '0-1' , fact.ACT_LABOR_BRDN_COST
10184: , '1-1' , fact.ACT_LABOR_BRDN_COST
10185: , 0 ) -- end decode
10186: , 0 ) -- end nvl
10187: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10188: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_BRDN_COST
10189: , ROUND (
10190: NVL (
10191: DECODE (
10184: , '1-1' , fact.ACT_LABOR_BRDN_COST
10185: , 0 ) -- end decode
10186: , 0 ) -- end nvl
10187: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10188: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_BRDN_COST
10189: , ROUND (
10190: NVL (
10191: DECODE (
10192: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10200: , '0-1' , fact.ACT_EQUIP_BRDN_COST
10201: , '1-1' , fact.ACT_EQUIP_BRDN_COST
10202: , 0 ) -- end decode
10203: , 0 ) -- end nvl
10204: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10205: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_BRDN_COST
10206: , ROUND (
10207: NVL (
10208: DECODE (
10201: , '1-1' , fact.ACT_EQUIP_BRDN_COST
10202: , 0 ) -- end decode
10203: , 0 ) -- end nvl
10204: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10205: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_BRDN_COST
10206: , ROUND (
10207: NVL (
10208: DECODE (
10209: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10217: , '0-1' , fact.ACT_BRDN_COST
10218: , '1-1' , fact.ACT_BRDN_COST
10219: , 0 ) -- end decode
10220: , 0 ) -- end nvl
10221: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10222: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_BRDN_COST
10223: , ROUND (
10224: NVL (
10225: DECODE (
10218: , '1-1' , fact.ACT_BRDN_COST
10219: , 0 ) -- end decode
10220: , 0 ) -- end nvl
10221: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10222: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_BRDN_COST
10223: , ROUND (
10224: NVL (
10225: DECODE (
10226: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10234: , '0-1' , fact.ACT_RAW_COST
10235: , '1-1' , fact.ACT_RAW_COST
10236: , 0 ) -- end decode
10237: , 0 ) -- end nvl
10238: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10239: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_RAW_COST
10240: , ROUND (
10241: NVL (
10242: DECODE (
10235: , '1-1' , fact.ACT_RAW_COST
10236: , 0 ) -- end decode
10237: , 0 ) -- end nvl
10238: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10239: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_RAW_COST
10240: , ROUND (
10241: NVL (
10242: DECODE (
10243: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10251: , '0-1' , fact.ACT_REVENUE
10252: , '1-1' , fact.ACT_REVENUE
10253: , 0 ) -- end decode
10254: , 0 ) -- end nvl
10255: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10256: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_REVENUE
10257: , ROUND (
10258: NVL (
10259: DECODE (
10252: , '1-1' , fact.ACT_REVENUE
10253: , 0 ) -- end decode
10254: , 0 ) -- end nvl
10255: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10256: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_REVENUE
10257: , ROUND (
10258: NVL (
10259: DECODE (
10260: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10268: , '0-1' , fact.ACT_LABOR_RAW_COST
10269: , '1-1' , fact.ACT_LABOR_RAW_COST
10270: , 0 ) -- end decode
10271: , 0 ) -- end nvl
10272: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10273: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_RAW_COST
10274: , ROUND (
10275: NVL (
10276: DECODE (
10269: , '1-1' , fact.ACT_LABOR_RAW_COST
10270: , 0 ) -- end decode
10271: , 0 ) -- end nvl
10272: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10273: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_RAW_COST
10274: , ROUND (
10275: NVL (
10276: DECODE (
10277: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10285: , '0-1' , fact.ACT_EQUIP_RAW_COST
10286: , '1-1' , fact.ACT_EQUIP_RAW_COST
10287: , 0 ) -- end decode
10288: , 0 ) -- end nvl
10289: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10290: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_RAW_COST
10291: , ROUND (
10292: NVL (
10293: DECODE (
10286: , '1-1' , fact.ACT_EQUIP_RAW_COST
10287: , 0 ) -- end decode
10288: , 0 ) -- end nvl
10289: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10290: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_RAW_COST
10291: , ROUND (
10292: NVL (
10293: DECODE (
10294: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10302: , '0-1' , fact.ETC_LABOR_HRS
10303: , '1-1' , fact.ETC_LABOR_HRS
10304: , 0 ) -- end decode
10305: , 0 ) -- end nvl
10306: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10307: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_HRS
10308: , ROUND (
10309: NVL (
10310: DECODE (
10303: , '1-1' , fact.ETC_LABOR_HRS
10304: , 0 ) -- end decode
10305: , 0 ) -- end nvl
10306: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10307: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_HRS
10308: , ROUND (
10309: NVL (
10310: DECODE (
10311: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10319: , '0-1' , fact.ETC_EQUIP_HRS
10320: , '1-1' , fact.ETC_EQUIP_HRS
10321: , 0 ) -- end decode
10322: , 0 ) -- end nvl
10323: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10324: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_HRS
10325: , ROUND (
10326: NVL (
10327: DECODE (
10320: , '1-1' , fact.ETC_EQUIP_HRS
10321: , 0 ) -- end decode
10322: , 0 ) -- end nvl
10323: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10324: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_HRS
10325: , ROUND (
10326: NVL (
10327: DECODE (
10328: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10336: , '0-1' , fact.ETC_LABOR_BRDN_COST
10337: , '1-1' , fact.ETC_LABOR_BRDN_COST
10338: , 0 ) -- end decode
10339: , 0 ) -- end nvl
10340: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10341: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_BRDN_COST
10342: , ROUND (
10343: NVL (
10344: DECODE (
10337: , '1-1' , fact.ETC_LABOR_BRDN_COST
10338: , 0 ) -- end decode
10339: , 0 ) -- end nvl
10340: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10341: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_BRDN_COST
10342: , ROUND (
10343: NVL (
10344: DECODE (
10345: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10353: , '0-1' , fact.ETC_EQUIP_BRDN_COST
10354: , '1-1' , fact.ETC_EQUIP_BRDN_COST
10355: , 0 ) -- end decode
10356: , 0 ) -- end nvl
10357: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10358: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_BRDN_COST
10359: , ROUND (
10360: NVL (
10361: DECODE (
10354: , '1-1' , fact.ETC_EQUIP_BRDN_COST
10355: , 0 ) -- end decode
10356: , 0 ) -- end nvl
10357: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10358: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_BRDN_COST
10359: , ROUND (
10360: NVL (
10361: DECODE (
10362: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10370: , '0-1' , fact.ETC_BRDN_COST
10371: , '1-1' , fact.ETC_BRDN_COST
10372: , 0 ) -- end decode
10373: , 0 ) -- end nvl
10374: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10375: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_BRDN_COST
10376: , ROUND (
10377: NVL (
10378: DECODE (
10371: , '1-1' , fact.ETC_BRDN_COST
10372: , 0 ) -- end decode
10373: , 0 ) -- end nvl
10374: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10375: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_BRDN_COST
10376: , ROUND (
10377: NVL (
10378: DECODE (
10379: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10387: , '0-1' , fact.ETC_RAW_COST
10388: , '1-1' , fact.ETC_RAW_COST
10389: , 0 ) -- end decode
10390: , 0 ) -- end nvl
10391: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10392: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_RAW_COST
10393: , ROUND (
10394: NVL (
10395: DECODE (
10388: , '1-1' , fact.ETC_RAW_COST
10389: , 0 ) -- end decode
10390: , 0 ) -- end nvl
10391: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10392: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_RAW_COST
10393: , ROUND (
10394: NVL (
10395: DECODE (
10396: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10404: , '0-1' , fact.ETC_LABOR_RAW_COST
10405: , '1-1' , fact.ETC_LABOR_RAW_COST
10406: , 0 ) -- end decode
10407: , 0 ) -- end nvl
10408: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10409: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_RAW_COST
10410: , ROUND (
10411: NVL (
10412: DECODE (
10405: , '1-1' , fact.ETC_LABOR_RAW_COST
10406: , 0 ) -- end decode
10407: , 0 ) -- end nvl
10408: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10409: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_RAW_COST
10410: , ROUND (
10411: NVL (
10412: DECODE (
10413: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10421: , '0-1' , fact.ETC_EQUIP_RAW_COST
10422: , '1-1' , fact.ETC_EQUIP_RAW_COST
10423: , 0 ) -- end decode
10424: , 0 ) -- end nvl
10425: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10426: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_RAW_COST
10427: , ROUND (
10428: NVL (
10429: DECODE (
10422: , '1-1' , fact.ETC_EQUIP_RAW_COST
10423: , 0 ) -- end decode
10424: , 0 ) -- end nvl
10425: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10426: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_RAW_COST
10427: , ROUND (
10428: NVL (
10429: DECODE (
10430: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10438: , '0-1' , fact.custom1
10439: , '1-1' , fact.custom1
10440: , 0 ) -- end decode
10441: , 0 ) -- end nvl
10442: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10443: * PJI_UTILS.GET_MAU (fact.currency_code) custom1
10444: , ROUND (
10445: NVL (
10446: DECODE (
10439: , '1-1' , fact.custom1
10440: , 0 ) -- end decode
10441: , 0 ) -- end nvl
10442: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10443: * PJI_UTILS.GET_MAU (fact.currency_code) custom1
10444: , ROUND (
10445: NVL (
10446: DECODE (
10447: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10455: , '0-1' , fact.custom2
10456: , '1-1' , fact.custom2
10457: , 0 ) -- end decode
10458: , 0 ) -- end nvl
10459: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10460: * PJI_UTILS.GET_MAU (fact.currency_code) custom2
10461: , ROUND (
10462: NVL (
10463: DECODE (
10456: , '1-1' , fact.custom2
10457: , 0 ) -- end decode
10458: , 0 ) -- end nvl
10459: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10460: * PJI_UTILS.GET_MAU (fact.currency_code) custom2
10461: , ROUND (
10462: NVL (
10463: DECODE (
10464: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10472: , '0-1' , fact.custom3
10473: , '1-1' , fact.custom3
10474: , 0 ) -- end decode
10475: , 0 ) -- end nvl
10476: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10477: * PJI_UTILS.GET_MAU (fact.currency_code) custom3
10478: , ROUND (
10479: NVL (
10480: DECODE (
10473: , '1-1' , fact.custom3
10474: , 0 ) -- end decode
10475: , 0 ) -- end nvl
10476: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10477: * PJI_UTILS.GET_MAU (fact.currency_code) custom3
10478: , ROUND (
10479: NVL (
10480: DECODE (
10481: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10489: , '0-1' , fact.custom4
10490: , '1-1' , fact.custom4
10491: , 0 ) -- end decode
10492: , 0 ) -- end nvl
10493: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10494: * PJI_UTILS.GET_MAU (fact.currency_code) custom4
10495: , ROUND (
10496: NVL (
10497: DECODE (
10490: , '1-1' , fact.custom4
10491: , 0 ) -- end decode
10492: , 0 ) -- end nvl
10493: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10494: * PJI_UTILS.GET_MAU (fact.currency_code) custom4
10495: , ROUND (
10496: NVL (
10497: DECODE (
10498: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10506: , '0-1' , fact.custom5
10507: , '1-1' , fact.custom5
10508: , 0 ) -- end decode
10509: , 0 ) -- end nvl
10510: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10511: * PJI_UTILS.GET_MAU (fact.currency_code) custom5
10512: , ROUND (
10513: NVL (
10514: DECODE (
10507: , '1-1' , fact.custom5
10508: , 0 ) -- end decode
10509: , 0 ) -- end nvl
10510: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10511: * PJI_UTILS.GET_MAU (fact.currency_code) custom5
10512: , ROUND (
10513: NVL (
10514: DECODE (
10515: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10523: , '0-1' , fact.custom6
10524: , '1-1' , fact.custom6
10525: , 0 ) -- end decode
10526: , 0 ) -- end nvl
10527: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10528: * PJI_UTILS.GET_MAU (fact.currency_code) custom6
10529: , ROUND (
10530: NVL (
10531: DECODE (
10524: , '1-1' , fact.custom6
10525: , 0 ) -- end decode
10526: , 0 ) -- end nvl
10527: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10528: * PJI_UTILS.GET_MAU (fact.currency_code) custom6
10529: , ROUND (
10530: NVL (
10531: DECODE (
10532: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10540: , '0-1' , fact.custom7
10541: , '1-1' , fact.custom7
10542: , 0 ) -- end decode
10543: , 0 ) -- end nvl
10544: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10545: * PJI_UTILS.GET_MAU (fact.currency_code) custom7
10546: , ROUND (
10547: NVL (
10548: DECODE (
10541: , '1-1' , fact.custom7
10542: , 0 ) -- end decode
10543: , 0 ) -- end nvl
10544: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10545: * PJI_UTILS.GET_MAU (fact.currency_code) custom7
10546: , ROUND (
10547: NVL (
10548: DECODE (
10549: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10557: , '0-1' , fact.custom8
10558: , '1-1' , fact.custom8
10559: , 0 ) -- end decode
10560: , 0 ) -- end nvl
10561: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10562: * PJI_UTILS.GET_MAU (fact.currency_code) custom8
10563: , ROUND (
10564: NVL (
10565: DECODE (
10558: , '1-1' , fact.custom8
10559: , 0 ) -- end decode
10560: , 0 ) -- end nvl
10561: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10562: * PJI_UTILS.GET_MAU (fact.currency_code) custom8
10563: , ROUND (
10564: NVL (
10565: DECODE (
10566: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10574: , '0-1' , fact.custom9
10575: , '1-1' , fact.custom9
10576: , 0 ) -- end decode
10577: , 0 ) -- end nvl
10578: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10579: * PJI_UTILS.GET_MAU (fact.currency_code) custom9
10580: , ROUND (
10581: NVL (
10582: DECODE (
10575: , '1-1' , fact.custom9
10576: , 0 ) -- end decode
10577: , 0 ) -- end nvl
10578: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10579: * PJI_UTILS.GET_MAU (fact.currency_code) custom9
10580: , ROUND (
10581: NVL (
10582: DECODE (
10583: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10591: , '0-1' , fact.custom10
10592: , '1-1' , fact.custom10
10593: , 0 ) -- end decode
10594: , 0 ) -- end nvl
10595: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10596: * PJI_UTILS.GET_MAU (fact.currency_code) custom10
10597: , ROUND (
10598: NVL (
10599: DECODE (
10592: , '1-1' , fact.custom10
10593: , 0 ) -- end decode
10594: , 0 ) -- end nvl
10595: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10596: * PJI_UTILS.GET_MAU (fact.currency_code) custom10
10597: , ROUND (
10598: NVL (
10599: DECODE (
10600: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10608: , '0-1' , fact.custom11
10609: , '1-1' , fact.custom11
10610: , 0 ) -- end decode
10611: , 0 ) -- end nvl
10612: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10613: * PJI_UTILS.GET_MAU (fact.currency_code) custom11
10614: , ROUND (
10615: NVL (
10616: DECODE (
10609: , '1-1' , fact.custom11
10610: , 0 ) -- end decode
10611: , 0 ) -- end nvl
10612: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10613: * PJI_UTILS.GET_MAU (fact.currency_code) custom11
10614: , ROUND (
10615: NVL (
10616: DECODE (
10617: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10625: , '0-1' , fact.custom12
10626: , '1-1' , fact.custom12
10627: , 0 ) -- end decode
10628: , 0 ) -- end nvl
10629: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10630: * PJI_UTILS.GET_MAU (fact.currency_code) custom12
10631: , ROUND (
10632: NVL (
10633: DECODE (
10626: , '1-1' , fact.custom12
10627: , 0 ) -- end decode
10628: , 0 ) -- end nvl
10629: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10630: * PJI_UTILS.GET_MAU (fact.currency_code) custom12
10631: , ROUND (
10632: NVL (
10633: DECODE (
10634: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10642: , '0-1' , fact.custom13
10643: , '1-1' , fact.custom13
10644: , 0 ) -- end decode
10645: , 0 ) -- end nvl
10646: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10647: * PJI_UTILS.GET_MAU (fact.currency_code) custom13
10648: , ROUND (
10649: NVL (
10650: DECODE (
10643: , '1-1' , fact.custom13
10644: , 0 ) -- end decode
10645: , 0 ) -- end nvl
10646: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10647: * PJI_UTILS.GET_MAU (fact.currency_code) custom13
10648: , ROUND (
10649: NVL (
10650: DECODE (
10651: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10659: , '0-1' , fact.custom14
10660: , '1-1' , fact.custom14
10661: , 0 ) -- end decode
10662: , 0 ) -- end nvl
10663: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10664: * PJI_UTILS.GET_MAU (fact.currency_code) custom14
10665: , ROUND (
10666: NVL (
10667: DECODE (
10660: , '1-1' , fact.custom14
10661: , 0 ) -- end decode
10662: , 0 ) -- end nvl
10663: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10664: * PJI_UTILS.GET_MAU (fact.currency_code) custom14
10665: , ROUND (
10666: NVL (
10667: DECODE (
10668: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )
10676: , '0-1' , fact.custom15
10677: , '1-1' , fact.custom15
10678: , 0 ) -- end decode
10679: , 0 ) -- end nvl
10680: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10681: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
10682: , 'CF' line_type
10683: , NULL time_dangling_flag
10684: , NULL rate_dangling_flag
10677: , '1-1' , fact.custom15
10678: , 0 ) -- end decode
10679: , 0 ) -- end nvl
10680: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10681: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
10682: , 'CF' line_type
10683: , NULL time_dangling_flag
10684: , NULL rate_dangling_flag
10685: ,fact.plan_type_code plan_type_code /*4471527 */
10933: , '0-1' , fact.raw_cost
10934: , '1-1' , fact.raw_cost
10935: , 0 ) -- end decode
10936: , 0 ) -- end nvl
10937: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10938: * PJI_UTILS.GET_MAU (fact.currency_code) raw_cost
10939: , ROUND (
10940: NVL (
10941: DECODE (
10934: , '1-1' , fact.raw_cost
10935: , 0 ) -- end decode
10936: , 0 ) -- end nvl
10937: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10938: * PJI_UTILS.GET_MAU (fact.currency_code) raw_cost
10939: , ROUND (
10940: NVL (
10941: DECODE (
10942: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
10950: , '0-1' , fact.brdn_cost
10951: , '1-1' , fact.brdn_cost
10952: , 0 ) -- end decode
10953: , 0 ) -- end nvl
10954: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10955: * PJI_UTILS.GET_MAU (fact.currency_code) brdn_cost
10956: , ROUND (
10957: NVL (
10958: DECODE (
10951: , '1-1' , fact.brdn_cost
10952: , 0 ) -- end decode
10953: , 0 ) -- end nvl
10954: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10955: * PJI_UTILS.GET_MAU (fact.currency_code) brdn_cost
10956: , ROUND (
10957: NVL (
10958: DECODE (
10959: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
10967: , '0-1' , fact.revenue
10968: , '1-1' , fact.revenue
10969: , 0 ) -- end decode
10970: , 0 ) -- end nvl
10971: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10972: * PJI_UTILS.GET_MAU (fact.currency_code) revenue
10973: , ROUND (
10974: NVL (
10975: DECODE (
10968: , '1-1' , fact.revenue
10969: , 0 ) -- end decode
10970: , 0 ) -- end nvl
10971: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10972: * PJI_UTILS.GET_MAU (fact.currency_code) revenue
10973: , ROUND (
10974: NVL (
10975: DECODE (
10976: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
10984: , '0-1' , fact.bill_raw_cost
10985: , '1-1' , fact.bill_raw_cost
10986: , 0 ) -- end decode
10987: , 0 ) -- end nvl
10988: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10989: * PJI_UTILS.GET_MAU (fact.currency_code) bill_raw_cost
10990: , ROUND (
10991: NVL (
10992: DECODE (
10985: , '1-1' , fact.bill_raw_cost
10986: , 0 ) -- end decode
10987: , 0 ) -- end nvl
10988: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
10989: * PJI_UTILS.GET_MAU (fact.currency_code) bill_raw_cost
10990: , ROUND (
10991: NVL (
10992: DECODE (
10993: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11001: , '0-1' , fact.bill_brdn_cost
11002: , '1-1' , fact.bill_brdn_cost
11003: , 0 ) -- end decode
11004: , 0 ) -- end nvl
11005: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11006: * PJI_UTILS.GET_MAU (fact.currency_code) bill_brdn_cost
11007: , ROUND (
11008: NVL (
11009: DECODE (
11002: , '1-1' , fact.bill_brdn_cost
11003: , 0 ) -- end decode
11004: , 0 ) -- end nvl
11005: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11006: * PJI_UTILS.GET_MAU (fact.currency_code) bill_brdn_cost
11007: , ROUND (
11008: NVL (
11009: DECODE (
11010: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11018: , '0-1' , fact.bill_labor_raw_cost
11019: , '1-1' , fact.bill_labor_raw_cost
11020: , 0 ) -- end decode
11021: , 0 ) -- end nvl
11022: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11023: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_raw_cost
11024: , ROUND (
11025: NVL (
11026: DECODE (
11019: , '1-1' , fact.bill_labor_raw_cost
11020: , 0 ) -- end decode
11021: , 0 ) -- end nvl
11022: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11023: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_raw_cost
11024: , ROUND (
11025: NVL (
11026: DECODE (
11027: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11035: , '0-1' , fact.bill_labor_brdn_cost
11036: , '1-1' , fact.bill_labor_brdn_cost
11037: , 0 ) -- end decode
11038: , 0 ) -- end nvl
11039: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11040: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_brdn_cost
11041: , ROUND (
11042: NVL (
11043: DECODE (
11036: , '1-1' , fact.bill_labor_brdn_cost
11037: , 0 ) -- end decode
11038: , 0 ) -- end nvl
11039: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11040: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_brdn_cost
11041: , ROUND (
11042: NVL (
11043: DECODE (
11044: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11052: , '0-1' , fact.bill_labor_hrs
11053: , '1-1' , fact.bill_labor_hrs
11054: , 0 ) -- end decode
11055: , 0 ) -- end nvl
11056: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11057: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_hrs
11058: , ROUND (
11059: NVL (
11060: DECODE (
11053: , '1-1' , fact.bill_labor_hrs
11054: , 0 ) -- end decode
11055: , 0 ) -- end nvl
11056: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11057: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_hrs
11058: , ROUND (
11059: NVL (
11060: DECODE (
11061: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11069: , '0-1' , fact.equipment_raw_cost
11070: , '1-1' , fact.equipment_raw_cost
11071: , 0 ) -- end decode
11072: , 0 ) -- end nvl
11073: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11074: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_raw_cost
11075: , ROUND (
11076: NVL (
11077: DECODE (
11070: , '1-1' , fact.equipment_raw_cost
11071: , 0 ) -- end decode
11072: , 0 ) -- end nvl
11073: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11074: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_raw_cost
11075: , ROUND (
11076: NVL (
11077: DECODE (
11078: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11086: , '0-1' , fact.equipment_brdn_cost
11087: , '1-1' , fact.equipment_brdn_cost
11088: , 0 ) -- end decode
11089: , 0 ) -- end nvl
11090: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11091: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_brdn_cost
11092: , ROUND (
11093: NVL (
11094: DECODE (
11087: , '1-1' , fact.equipment_brdn_cost
11088: , 0 ) -- end decode
11089: , 0 ) -- end nvl
11090: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11091: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_brdn_cost
11092: , ROUND (
11093: NVL (
11094: DECODE (
11095: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11103: , '0-1' , fact.capitalizable_raw_cost
11104: , '1-1' , fact.capitalizable_raw_cost
11105: , 0 ) -- end decode
11106: , 0 ) -- end nvl
11107: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11108: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_raw_cost
11109: , ROUND (
11110: NVL (
11111: DECODE (
11104: , '1-1' , fact.capitalizable_raw_cost
11105: , 0 ) -- end decode
11106: , 0 ) -- end nvl
11107: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11108: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_raw_cost
11109: , ROUND (
11110: NVL (
11111: DECODE (
11112: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11120: , '0-1' , fact.capitalizable_brdn_cost
11121: , '1-1' , fact.capitalizable_brdn_cost
11122: , 0 ) -- end decode
11123: , 0 ) -- end nvl
11124: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11125: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_brdn_cost
11126: , ROUND (
11127: NVL (
11128: DECODE (
11121: , '1-1' , fact.capitalizable_brdn_cost
11122: , 0 ) -- end decode
11123: , 0 ) -- end nvl
11124: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11125: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_brdn_cost
11126: , ROUND (
11127: NVL (
11128: DECODE (
11129: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11137: , '0-1' , fact.labor_raw_cost
11138: , '1-1' , fact.labor_raw_cost
11139: , 0 ) -- end decode
11140: , 0 ) -- end nvl
11141: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11142: * PJI_UTILS.GET_MAU (fact.currency_code) labor_raw_cost
11143: , ROUND (
11144: NVL (
11145: DECODE (
11138: , '1-1' , fact.labor_raw_cost
11139: , 0 ) -- end decode
11140: , 0 ) -- end nvl
11141: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11142: * PJI_UTILS.GET_MAU (fact.currency_code) labor_raw_cost
11143: , ROUND (
11144: NVL (
11145: DECODE (
11146: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11154: , '0-1' , fact.labor_brdn_cost
11155: , '1-1' , fact.labor_brdn_cost
11156: , 0 ) -- end decode
11157: , 0 ) -- end nvl
11158: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11159: * PJI_UTILS.GET_MAU (fact.currency_code) labor_brdn_cost
11160: , ROUND (
11161: NVL (
11162: DECODE (
11155: , '1-1' , fact.labor_brdn_cost
11156: , 0 ) -- end decode
11157: , 0 ) -- end nvl
11158: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11159: * PJI_UTILS.GET_MAU (fact.currency_code) labor_brdn_cost
11160: , ROUND (
11161: NVL (
11162: DECODE (
11163: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11171: , '0-1' , fact.labor_hrs
11172: , '1-1' , fact.labor_hrs
11173: , 0 ) -- end decode
11174: , 0 ) -- end nvl
11175: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11176: * PJI_UTILS.GET_MAU (fact.currency_code) labor_hrs
11177: , ROUND (
11178: NVL (
11179: DECODE (
11172: , '1-1' , fact.labor_hrs
11173: , 0 ) -- end decode
11174: , 0 ) -- end nvl
11175: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11176: * PJI_UTILS.GET_MAU (fact.currency_code) labor_hrs
11177: , ROUND (
11178: NVL (
11179: DECODE (
11180: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11188: , '0-1' , fact.labor_revenue
11189: , '1-1' , fact.labor_revenue
11190: , 0 ) -- end decode
11191: , 0 ) -- end nvl
11192: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11193: * PJI_UTILS.GET_MAU (fact.currency_code) labor_revenue
11194: , ROUND (
11195: NVL (
11196: DECODE (
11189: , '1-1' , fact.labor_revenue
11190: , 0 ) -- end decode
11191: , 0 ) -- end nvl
11192: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11193: * PJI_UTILS.GET_MAU (fact.currency_code) labor_revenue
11194: , ROUND (
11195: NVL (
11196: DECODE (
11197: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11205: , '0-1' , fact.equipment_hours
11206: , '1-1' , fact.equipment_hours
11207: , 0 ) -- end decode
11208: , 0 ) -- end nvl
11209: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11210: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_hours
11211: , ROUND (
11212: NVL (
11213: DECODE (
11206: , '1-1' , fact.equipment_hours
11207: , 0 ) -- end decode
11208: , 0 ) -- end nvl
11209: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11210: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_hours
11211: , ROUND (
11212: NVL (
11213: DECODE (
11214: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11222: , '0-1' , fact.billable_equipment_hours
11223: , '1-1' , fact.billable_equipment_hours
11224: , 0 ) -- end decode
11225: , 0 ) -- end nvl
11226: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11227: * PJI_UTILS.GET_MAU (fact.currency_code) billable_equipment_hours
11228: , ROUND (
11229: NVL (
11230: DECODE (
11223: , '1-1' , fact.billable_equipment_hours
11224: , 0 ) -- end decode
11225: , 0 ) -- end nvl
11226: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11227: * PJI_UTILS.GET_MAU (fact.currency_code) billable_equipment_hours
11228: , ROUND (
11229: NVL (
11230: DECODE (
11231: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11239: , '0-1' , fact.sup_inv_committed_cost
11240: , '1-1' , fact.sup_inv_committed_cost
11241: , 0 ) -- end decode
11242: , 0 ) -- end nvl
11243: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11244: * PJI_UTILS.GET_MAU (fact.currency_code) sup_inv_committed_cost
11245: , ROUND (
11246: NVL (
11247: DECODE (
11240: , '1-1' , fact.sup_inv_committed_cost
11241: , 0 ) -- end decode
11242: , 0 ) -- end nvl
11243: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11244: * PJI_UTILS.GET_MAU (fact.currency_code) sup_inv_committed_cost
11245: , ROUND (
11246: NVL (
11247: DECODE (
11248: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11256: , '0-1' , fact.po_committed_cost
11257: , '1-1' , fact.po_committed_cost
11258: , 0 ) -- end decode
11259: , 0 ) -- end nvl
11260: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11261: * PJI_UTILS.GET_MAU (fact.currency_code) po_committed_cost
11262: , ROUND (
11263: NVL (
11264: DECODE (
11257: , '1-1' , fact.po_committed_cost
11258: , 0 ) -- end decode
11259: , 0 ) -- end nvl
11260: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11261: * PJI_UTILS.GET_MAU (fact.currency_code) po_committed_cost
11262: , ROUND (
11263: NVL (
11264: DECODE (
11265: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11273: , '0-1' , fact.pr_committed_cost
11274: , '1-1' , fact.pr_committed_cost
11275: , 0 ) -- end decode
11276: , 0 ) -- end nvl
11277: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11278: * PJI_UTILS.GET_MAU (fact.currency_code) pr_committed_cost
11279: , ROUND (
11280: NVL (
11281: DECODE (
11274: , '1-1' , fact.pr_committed_cost
11275: , 0 ) -- end decode
11276: , 0 ) -- end nvl
11277: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11278: * PJI_UTILS.GET_MAU (fact.currency_code) pr_committed_cost
11279: , ROUND (
11280: NVL (
11281: DECODE (
11282: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11290: , '0-1' , fact.oth_committed_cost
11291: , '1-1' , fact.oth_committed_cost
11292: , 0 ) -- end decode
11293: , 0 ) -- end nvl
11294: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11295: * PJI_UTILS.GET_MAU (fact.currency_code) oth_committed_cost
11296: , ROUND (
11297: NVL (
11298: DECODE (
11291: , '1-1' , fact.oth_committed_cost
11292: , 0 ) -- end decode
11293: , 0 ) -- end nvl
11294: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11295: * PJI_UTILS.GET_MAU (fact.currency_code) oth_committed_cost
11296: , ROUND (
11297: NVL (
11298: DECODE (
11299: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11307: , '0-1' , fact.ACT_LABOR_HRS
11308: , '1-1' , fact.ACT_LABOR_HRS
11309: , 0 ) -- end decode
11310: , 0 ) -- end nvl
11311: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11312: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_HRS
11313: , ROUND (
11314: NVL (
11315: DECODE (
11308: , '1-1' , fact.ACT_LABOR_HRS
11309: , 0 ) -- end decode
11310: , 0 ) -- end nvl
11311: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11312: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_HRS
11313: , ROUND (
11314: NVL (
11315: DECODE (
11316: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11324: , '0-1' , fact.ACT_EQUIP_HRS
11325: , '1-1' , fact.ACT_EQUIP_HRS
11326: , 0 ) -- end decode
11327: , 0 ) -- end nvl
11328: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11329: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_HRS
11330: , ROUND (
11331: NVL (
11332: DECODE (
11325: , '1-1' , fact.ACT_EQUIP_HRS
11326: , 0 ) -- end decode
11327: , 0 ) -- end nvl
11328: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11329: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_HRS
11330: , ROUND (
11331: NVL (
11332: DECODE (
11333: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11341: , '0-1' , fact.ACT_LABOR_BRDN_COST
11342: , '1-1' , fact.ACT_LABOR_BRDN_COST
11343: , 0 ) -- end decode
11344: , 0 ) -- end nvl
11345: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11346: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_BRDN_COST
11347: , ROUND (
11348: NVL (
11349: DECODE (
11342: , '1-1' , fact.ACT_LABOR_BRDN_COST
11343: , 0 ) -- end decode
11344: , 0 ) -- end nvl
11345: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11346: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_BRDN_COST
11347: , ROUND (
11348: NVL (
11349: DECODE (
11350: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11358: , '0-1' , fact.ACT_EQUIP_BRDN_COST
11359: , '1-1' , fact.ACT_EQUIP_BRDN_COST
11360: , 0 ) -- end decode
11361: , 0 ) -- end nvl
11362: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11363: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_BRDN_COST
11364: , ROUND (
11365: NVL (
11366: DECODE (
11359: , '1-1' , fact.ACT_EQUIP_BRDN_COST
11360: , 0 ) -- end decode
11361: , 0 ) -- end nvl
11362: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11363: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_BRDN_COST
11364: , ROUND (
11365: NVL (
11366: DECODE (
11367: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11375: , '0-1' , fact.ACT_BRDN_COST
11376: , '1-1' , fact.ACT_BRDN_COST
11377: , 0 ) -- end decode
11378: , 0 ) -- end nvl
11379: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11380: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_BRDN_COST
11381: , ROUND (
11382: NVL (
11383: DECODE (
11376: , '1-1' , fact.ACT_BRDN_COST
11377: , 0 ) -- end decode
11378: , 0 ) -- end nvl
11379: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11380: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_BRDN_COST
11381: , ROUND (
11382: NVL (
11383: DECODE (
11384: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11392: , '0-1' , fact.ACT_RAW_COST
11393: , '1-1' , fact.ACT_RAW_COST
11394: , 0 ) -- end decode
11395: , 0 ) -- end nvl
11396: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11397: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_RAW_COST
11398: , ROUND (
11399: NVL (
11400: DECODE (
11393: , '1-1' , fact.ACT_RAW_COST
11394: , 0 ) -- end decode
11395: , 0 ) -- end nvl
11396: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11397: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_RAW_COST
11398: , ROUND (
11399: NVL (
11400: DECODE (
11401: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11409: , '0-1' , fact.ACT_REVENUE
11410: , '1-1' , fact.ACT_REVENUE
11411: , 0 ) -- end decode
11412: , 0 ) -- end nvl
11413: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11414: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_REVENUE
11415: , ROUND (
11416: NVL (
11417: DECODE (
11410: , '1-1' , fact.ACT_REVENUE
11411: , 0 ) -- end decode
11412: , 0 ) -- end nvl
11413: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11414: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_REVENUE
11415: , ROUND (
11416: NVL (
11417: DECODE (
11418: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11426: , '0-1' , fact.ACT_LABOR_RAW_COST
11427: , '1-1' , fact.ACT_LABOR_RAW_COST
11428: , 0 ) -- end decode
11429: , 0 ) -- end nvl
11430: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11431: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_RAW_COST
11432: , ROUND (
11433: NVL (
11434: DECODE (
11427: , '1-1' , fact.ACT_LABOR_RAW_COST
11428: , 0 ) -- end decode
11429: , 0 ) -- end nvl
11430: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11431: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_RAW_COST
11432: , ROUND (
11433: NVL (
11434: DECODE (
11435: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11443: , '0-1' , fact.ACT_EQUIP_RAW_COST
11444: , '1-1' , fact.ACT_EQUIP_RAW_COST
11445: , 0 ) -- end decode
11446: , 0 ) -- end nvl
11447: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11448: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_RAW_COST
11449: , ROUND (
11450: NVL (
11451: DECODE (
11444: , '1-1' , fact.ACT_EQUIP_RAW_COST
11445: , 0 ) -- end decode
11446: , 0 ) -- end nvl
11447: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11448: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_RAW_COST
11449: , ROUND (
11450: NVL (
11451: DECODE (
11452: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11460: , '0-1' , fact.ETC_LABOR_HRS
11461: , '1-1' , fact.ETC_LABOR_HRS
11462: , 0 ) -- end decode
11463: , 0 ) -- end nvl
11464: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11465: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_HRS
11466: , ROUND (
11467: NVL (
11468: DECODE (
11461: , '1-1' , fact.ETC_LABOR_HRS
11462: , 0 ) -- end decode
11463: , 0 ) -- end nvl
11464: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11465: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_HRS
11466: , ROUND (
11467: NVL (
11468: DECODE (
11469: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11477: , '0-1' , fact.ETC_EQUIP_HRS
11478: , '1-1' , fact.ETC_EQUIP_HRS
11479: , 0 ) -- end decode
11480: , 0 ) -- end nvl
11481: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11482: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_HRS
11483: , ROUND (
11484: NVL (
11485: DECODE (
11478: , '1-1' , fact.ETC_EQUIP_HRS
11479: , 0 ) -- end decode
11480: , 0 ) -- end nvl
11481: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11482: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_HRS
11483: , ROUND (
11484: NVL (
11485: DECODE (
11486: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11494: , '0-1' , fact.ETC_LABOR_BRDN_COST
11495: , '1-1' , fact.ETC_LABOR_BRDN_COST
11496: , 0 ) -- end decode
11497: , 0 ) -- end nvl
11498: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11499: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_BRDN_COST
11500: , ROUND (
11501: NVL (
11502: DECODE (
11495: , '1-1' , fact.ETC_LABOR_BRDN_COST
11496: , 0 ) -- end decode
11497: , 0 ) -- end nvl
11498: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11499: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_BRDN_COST
11500: , ROUND (
11501: NVL (
11502: DECODE (
11503: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11511: , '0-1' , fact.ETC_EQUIP_BRDN_COST
11512: , '1-1' , fact.ETC_EQUIP_BRDN_COST
11513: , 0 ) -- end decode
11514: , 0 ) -- end nvl
11515: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11516: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_BRDN_COST
11517: , ROUND (
11518: NVL (
11519: DECODE (
11512: , '1-1' , fact.ETC_EQUIP_BRDN_COST
11513: , 0 ) -- end decode
11514: , 0 ) -- end nvl
11515: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11516: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_BRDN_COST
11517: , ROUND (
11518: NVL (
11519: DECODE (
11520: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11528: , '0-1' , fact.ETC_BRDN_COST
11529: , '1-1' , fact.ETC_BRDN_COST
11530: , 0 ) -- end decode
11531: , 0 ) -- end nvl
11532: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11533: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_BRDN_COST
11534: , ROUND (
11535: NVL (
11536: DECODE (
11529: , '1-1' , fact.ETC_BRDN_COST
11530: , 0 ) -- end decode
11531: , 0 ) -- end nvl
11532: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11533: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_BRDN_COST
11534: , ROUND (
11535: NVL (
11536: DECODE (
11537: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11545: , '0-1' , fact.ETC_RAW_COST
11546: , '1-1' , fact.ETC_RAW_COST
11547: , 0 ) -- end decode
11548: , 0 ) -- end nvl
11549: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11550: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_RAW_COST
11551: , ROUND (
11552: NVL (
11553: DECODE (
11546: , '1-1' , fact.ETC_RAW_COST
11547: , 0 ) -- end decode
11548: , 0 ) -- end nvl
11549: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11550: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_RAW_COST
11551: , ROUND (
11552: NVL (
11553: DECODE (
11554: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11562: , '0-1' , fact.ETC_LABOR_RAW_COST
11563: , '1-1' , fact.ETC_LABOR_RAW_COST
11564: , 0 ) -- end decode
11565: , 0 ) -- end nvl
11566: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11567: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_RAW_COST
11568: , ROUND (
11569: NVL (
11570: DECODE (
11563: , '1-1' , fact.ETC_LABOR_RAW_COST
11564: , 0 ) -- end decode
11565: , 0 ) -- end nvl
11566: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11567: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_RAW_COST
11568: , ROUND (
11569: NVL (
11570: DECODE (
11571: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11579: , '0-1' , fact.ETC_EQUIP_RAW_COST
11580: , '1-1' , fact.ETC_EQUIP_RAW_COST
11581: , 0 ) -- end decode
11582: , 0 ) -- end nvl
11583: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11584: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_RAW_COST
11585: , ROUND (
11586: NVL (
11587: DECODE (
11580: , '1-1' , fact.ETC_EQUIP_RAW_COST
11581: , 0 ) -- end decode
11582: , 0 ) -- end nvl
11583: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11584: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_RAW_COST
11585: , ROUND (
11586: NVL (
11587: DECODE (
11588: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11596: , '0-1' , fact.custom1
11597: , '1-1' , fact.custom1
11598: , 0 ) -- end decode
11599: , 0 ) -- end nvl
11600: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11601: * PJI_UTILS.GET_MAU (fact.currency_code) custom1
11602: , ROUND (
11603: NVL (
11604: DECODE (
11597: , '1-1' , fact.custom1
11598: , 0 ) -- end decode
11599: , 0 ) -- end nvl
11600: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11601: * PJI_UTILS.GET_MAU (fact.currency_code) custom1
11602: , ROUND (
11603: NVL (
11604: DECODE (
11605: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11613: , '0-1' , fact.custom2
11614: , '1-1' , fact.custom2
11615: , 0 ) -- end decode
11616: , 0 ) -- end nvl
11617: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11618: * PJI_UTILS.GET_MAU (fact.currency_code) custom2
11619: , ROUND (
11620: NVL (
11621: DECODE (
11614: , '1-1' , fact.custom2
11615: , 0 ) -- end decode
11616: , 0 ) -- end nvl
11617: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11618: * PJI_UTILS.GET_MAU (fact.currency_code) custom2
11619: , ROUND (
11620: NVL (
11621: DECODE (
11622: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11630: , '0-1' , fact.custom3
11631: , '1-1' , fact.custom3
11632: , 0 ) -- end decode
11633: , 0 ) -- end nvl
11634: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11635: * PJI_UTILS.GET_MAU (fact.currency_code) custom3
11636: , ROUND (
11637: NVL (
11638: DECODE (
11631: , '1-1' , fact.custom3
11632: , 0 ) -- end decode
11633: , 0 ) -- end nvl
11634: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11635: * PJI_UTILS.GET_MAU (fact.currency_code) custom3
11636: , ROUND (
11637: NVL (
11638: DECODE (
11639: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11647: , '0-1' , fact.custom4
11648: , '1-1' , fact.custom4
11649: , 0 ) -- end decode
11650: , 0 ) -- end nvl
11651: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11652: * PJI_UTILS.GET_MAU (fact.currency_code) custom4
11653: , ROUND (
11654: NVL (
11655: DECODE (
11648: , '1-1' , fact.custom4
11649: , 0 ) -- end decode
11650: , 0 ) -- end nvl
11651: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11652: * PJI_UTILS.GET_MAU (fact.currency_code) custom4
11653: , ROUND (
11654: NVL (
11655: DECODE (
11656: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11664: , '0-1' , fact.custom5
11665: , '1-1' , fact.custom5
11666: , 0 ) -- end decode
11667: , 0 ) -- end nvl
11668: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11669: * PJI_UTILS.GET_MAU (fact.currency_code) custom5
11670: , ROUND (
11671: NVL (
11672: DECODE (
11665: , '1-1' , fact.custom5
11666: , 0 ) -- end decode
11667: , 0 ) -- end nvl
11668: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11669: * PJI_UTILS.GET_MAU (fact.currency_code) custom5
11670: , ROUND (
11671: NVL (
11672: DECODE (
11673: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11681: , '0-1' , fact.custom6
11682: , '1-1' , fact.custom6
11683: , 0 ) -- end decode
11684: , 0 ) -- end nvl
11685: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11686: * PJI_UTILS.GET_MAU (fact.currency_code) custom6
11687: , ROUND (
11688: NVL (
11689: DECODE (
11682: , '1-1' , fact.custom6
11683: , 0 ) -- end decode
11684: , 0 ) -- end nvl
11685: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11686: * PJI_UTILS.GET_MAU (fact.currency_code) custom6
11687: , ROUND (
11688: NVL (
11689: DECODE (
11690: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11698: , '0-1' , fact.custom7
11699: , '1-1' , fact.custom7
11700: , 0 ) -- end decode
11701: , 0 ) -- end nvl
11702: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11703: * PJI_UTILS.GET_MAU (fact.currency_code) custom7
11704: , ROUND (
11705: NVL (
11706: DECODE (
11699: , '1-1' , fact.custom7
11700: , 0 ) -- end decode
11701: , 0 ) -- end nvl
11702: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11703: * PJI_UTILS.GET_MAU (fact.currency_code) custom7
11704: , ROUND (
11705: NVL (
11706: DECODE (
11707: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11715: , '0-1' , fact.custom8
11716: , '1-1' , fact.custom8
11717: , 0 ) -- end decode
11718: , 0 ) -- end nvl
11719: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11720: * PJI_UTILS.GET_MAU (fact.currency_code) custom8
11721: , ROUND (
11722: NVL (
11723: DECODE (
11716: , '1-1' , fact.custom8
11717: , 0 ) -- end decode
11718: , 0 ) -- end nvl
11719: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11720: * PJI_UTILS.GET_MAU (fact.currency_code) custom8
11721: , ROUND (
11722: NVL (
11723: DECODE (
11724: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11732: , '0-1' , fact.custom9
11733: , '1-1' , fact.custom9
11734: , 0 ) -- end decode
11735: , 0 ) -- end nvl
11736: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11737: * PJI_UTILS.GET_MAU (fact.currency_code) custom9
11738: , ROUND (
11739: NVL (
11740: DECODE (
11733: , '1-1' , fact.custom9
11734: , 0 ) -- end decode
11735: , 0 ) -- end nvl
11736: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11737: * PJI_UTILS.GET_MAU (fact.currency_code) custom9
11738: , ROUND (
11739: NVL (
11740: DECODE (
11741: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11749: , '0-1' , fact.custom10
11750: , '1-1' , fact.custom10
11751: , 0 ) -- end decode
11752: , 0 ) -- end nvl
11753: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11754: * PJI_UTILS.GET_MAU (fact.currency_code) custom10
11755: , ROUND (
11756: NVL (
11757: DECODE (
11750: , '1-1' , fact.custom10
11751: , 0 ) -- end decode
11752: , 0 ) -- end nvl
11753: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11754: * PJI_UTILS.GET_MAU (fact.currency_code) custom10
11755: , ROUND (
11756: NVL (
11757: DECODE (
11758: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11766: , '0-1' , fact.custom11
11767: , '1-1' , fact.custom11
11768: , 0 ) -- end decode
11769: , 0 ) -- end nvl
11770: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11771: * PJI_UTILS.GET_MAU (fact.currency_code) custom11
11772: , ROUND (
11773: NVL (
11774: DECODE (
11767: , '1-1' , fact.custom11
11768: , 0 ) -- end decode
11769: , 0 ) -- end nvl
11770: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11771: * PJI_UTILS.GET_MAU (fact.currency_code) custom11
11772: , ROUND (
11773: NVL (
11774: DECODE (
11775: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11783: , '0-1' , fact.custom12
11784: , '1-1' , fact.custom12
11785: , 0 ) -- end decode
11786: , 0 ) -- end nvl
11787: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11788: * PJI_UTILS.GET_MAU (fact.currency_code) custom12
11789: , ROUND (
11790: NVL (
11791: DECODE (
11784: , '1-1' , fact.custom12
11785: , 0 ) -- end decode
11786: , 0 ) -- end nvl
11787: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11788: * PJI_UTILS.GET_MAU (fact.currency_code) custom12
11789: , ROUND (
11790: NVL (
11791: DECODE (
11792: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11800: , '0-1' , fact.custom13
11801: , '1-1' , fact.custom13
11802: , 0 ) -- end decode
11803: , 0 ) -- end nvl
11804: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11805: * PJI_UTILS.GET_MAU (fact.currency_code) custom13
11806: , ROUND (
11807: NVL (
11808: DECODE (
11801: , '1-1' , fact.custom13
11802: , 0 ) -- end decode
11803: , 0 ) -- end nvl
11804: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11805: * PJI_UTILS.GET_MAU (fact.currency_code) custom13
11806: , ROUND (
11807: NVL (
11808: DECODE (
11809: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11817: , '0-1' , fact.custom14
11818: , '1-1' , fact.custom14
11819: , 0 ) -- end decode
11820: , 0 ) -- end nvl
11821: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11822: * PJI_UTILS.GET_MAU (fact.currency_code) custom14
11823: , ROUND (
11824: NVL (
11825: DECODE (
11818: , '1-1' , fact.custom14
11819: , 0 ) -- end decode
11820: , 0 ) -- end nvl
11821: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11822: * PJI_UTILS.GET_MAU (fact.currency_code) custom14
11823: , ROUND (
11824: NVL (
11825: DECODE (
11826: ( sign (fact.start_date - pa_cal.start_date) || sign (fact.end_date - pa_cal.end_date) )
11834: , '0-1' , fact.custom15
11835: , '1-1' , fact.custom15
11836: , 0 ) -- end decode
11837: , 0 ) -- end nvl
11838: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11839: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
11840: , 'CF' line_type
11841: , NULL time_dangling_flag
11842: , NULL rate_dangling_flag
11835: , '1-1' , fact.custom15
11836: , 0 ) -- end decode
11837: , 0 ) -- end nvl
11838: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
11839: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
11840: , 'CF' line_type
11841: , NULL time_dangling_flag
11842: , NULL rate_dangling_flag
11843: FROM pji_fp_aggr_pjp1_t fact