[Home] [Help]
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
2818: cdl.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id
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
2878: -- cdl.project_id BETWEEN x_start_project_id AND x_end_project_id -- Modified for bug 3736097
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,
2909: gl_sets_of_books sob
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
3222: WHERE
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,
3250: pa_implementations pi,
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
3673: WHERE