[Home] [Help]
2809: DECODE(cdl.billable_flag,'Y',NVL(cdl.burdened_cost,0),0) billable_burdened_cost,
2810: decode(et.unit_of_measure,NULL, ei.unit_of_measure, et.unit_of_measure) unit_of_measure,
2811: cdl.ind_compiled_set_id cost_ind_compiled_set_id
2812: FROM
2813: pa_expenditures_all pe,
2814: pa_expenditure_types et,
2815: pa_expenditure_items_all ei,
2816: pa_cost_distribution_lines_all cdl
2817: WHERE
2869: DECODE(cdl.billable_flag,'Y',NVL(cdl.burdened_cost,0),0) billable_burdened_cost,
2870: decode(et.unit_of_measure ,NULL, ei.unit_of_measure, et.unit_of_measure) unit_of_measure,
2871: cdl.ind_compiled_set_id cost_ind_compiled_set_id
2872: FROM
2873: pa_expenditures_all pe,
2874: pa_expenditure_types et,
2875: pa_expenditure_items_all ei,
2876: pa_cost_distribution_lines_all cdl
2877: WHERE
2900: g.period_name gl_period1
2901: FROM
2902: gl_date_period_map p,
2903: gl_date_period_map g,
2904: pa_expenditures_all pe,
2905: pa_expenditure_types et,
2906: pa_expenditure_items_all ei,
2907: pa_cost_distribution_lines_all cdl,
2908: pa_implementations pi,
3213: rdl.inv_ind_compiled_set_id inv_ind_compiled_set_id,
3214: NVL(rdl.amount,0) amount,
3215: decode(et.unit_of_measure,NULL,et.unit_of_measure,ei.unit_of_measure) unit_of_measure
3216: FROM
3217: pa_expenditures_all pe,
3218: pa_expenditure_types et,
3219: pa_expenditure_items_all ei,
3220: pa_cust_rev_dist_lines rdl,
3221: pa_draft_revenues dr
3241: g.period_name gl_period1
3242: FROM
3243: gl_date_period_map p,
3244: gl_date_period_map g,
3245: pa_expenditures_all pe,
3246: pa_expenditure_types et,
3247: pa_expenditure_items_all ei,
3248: pa_cust_rev_dist_lines rdl,
3249: pa_draft_revenues dr,
3664: NULL event_type,
3665: NULL event_type_classification,
3666: et.unit_of_measure unit_of_measure
3667: FROM
3668: pa_expenditures_all pe,
3669: pa_expenditure_types et,
3670: pa_expenditure_items_all ei,
3671: pa_cust_rev_dist_lines rdl,
3672: pa_draft_revenues dr