[Home] [Help]
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
2716: cdl.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id
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
2765: -- cdl.project_id BETWEEN x_start_project_id AND x_end_project_id -- Modified for bug 3736097
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,
2796: gl_sets_of_books sob
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
3042: WHERE
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,
3070: pa_implementations pi,
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
3493: WHERE