[Home] [Help]
2707: DECODE(cdl.billable_flag,'Y',NVL(cdl.burdened_cost,0),0) billable_burdened_cost,
2708: decode(et.unit_of_measure,NULL, ei.unit_of_measure, et.unit_of_measure) unit_of_measure,
2709: cdl.ind_compiled_set_id cost_ind_compiled_set_id
2710: FROM
2711: pa_expenditures_all pe,
2712: pa_expenditure_types et,
2713: pa_expenditure_items_all ei,
2714: pa_cost_distribution_lines_all cdl
2715: WHERE
2756: DECODE(cdl.billable_flag,'Y',NVL(cdl.burdened_cost,0),0) billable_burdened_cost,
2757: decode(et.unit_of_measure ,NULL, ei.unit_of_measure, et.unit_of_measure) unit_of_measure,
2758: cdl.ind_compiled_set_id cost_ind_compiled_set_id
2759: FROM
2760: pa_expenditures_all pe,
2761: pa_expenditure_types et,
2762: pa_expenditure_items_all ei,
2763: pa_cost_distribution_lines_all cdl
2764: WHERE
2787: g.period_name gl_period1
2788: FROM
2789: gl_date_period_map p,
2790: gl_date_period_map g,
2791: pa_expenditures_all pe,
2792: pa_expenditure_types et,
2793: pa_expenditure_items_all ei,
2794: pa_cost_distribution_lines_all cdl,
2795: pa_implementations pi,
3033: rdl.inv_ind_compiled_set_id inv_ind_compiled_set_id,
3034: NVL(rdl.amount,0) amount,
3035: decode(et.unit_of_measure,NULL,et.unit_of_measure,ei.unit_of_measure) unit_of_measure
3036: FROM
3037: pa_expenditures_all pe,
3038: pa_expenditure_types et,
3039: pa_expenditure_items_all ei,
3040: pa_cust_rev_dist_lines rdl,
3041: pa_draft_revenues dr
3061: g.period_name gl_period1
3062: FROM
3063: gl_date_period_map p,
3064: gl_date_period_map g,
3065: pa_expenditures_all pe,
3066: pa_expenditure_types et,
3067: pa_expenditure_items_all ei,
3068: pa_cust_rev_dist_lines rdl,
3069: pa_draft_revenues dr,
3484: NULL event_type,
3485: NULL event_type_classification,
3486: et.unit_of_measure unit_of_measure
3487: FROM
3488: pa_expenditures_all pe,
3489: pa_expenditure_types et,
3490: pa_expenditure_items_all ei,
3491: pa_cust_rev_dist_lines rdl,
3492: pa_draft_revenues dr