[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
x_new_exp_id expenditure_id,
pa_ei_denorm_s.nextval denorm_id,
G_inc_by_person_id person_id,
project_id,
task_id,
billable_flag,
decode(G_copy_exp_type_flag,'Y',expenditure_type,NULL) expenditure_type,
decode(G_copy_exp_type_flag,'Y',default_sys_link_func,NULL) default_sys_link_func,
decode(G_copy_exp_type_flag,'Y',unit_of_measure_code,NULL) unit_of_measure_code,
decode(G_copy_exp_type_flag,'Y',unit_of_measure,NULL) unit_of_measure,
l_dummy expenditure_item_id_1,
decode(nvl(net_zero_adjustment_flag_1,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
trunc(nvl(expenditure_item_date_1,sysdate) + x_days_diff),
l_dummy_date),l_dummy_date),l_dummy_date) expenditure_item_date_1,
decode(nvl(net_zero_adjustment_flag_1,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',quantity_1,
l_dummy),l_dummy),l_dummy) quantity_1,
decode(nvl(net_zero_adjustment_flag_1,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',system_linkage_function_1,
NULL),NULL),NULL) system_linkage_function_1,
null non_labor_resource_1,
l_dummy organization_id_1,
l_dummy override_to_organization_id_1,
l_dummy raw_cost_1,
l_dummy raw_cost_rate_1,
decode(nvl(net_zero_adjustment_flag_1,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute_category_1,
NULL),NULL),NULL),NULL) attribute_category_1,
decode(nvl(net_zero_adjustment_flag_1,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute1_1,
NULL),NULL),NULL),NULL) attribute1_1,
decode(nvl(net_zero_adjustment_flag_1,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute1_2,
NULL),NULL),NULL),NULL) attribute1_2,
decode(nvl(net_zero_adjustment_flag_1,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute1_3,
NULL),NULL),NULL),NULL) attribute1_3,
decode(nvl(net_zero_adjustment_flag_1,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute1_4,
NULL),NULL),NULL),NULL) attribute1_4,
decode(nvl(net_zero_adjustment_flag_1,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute1_5,
NULL),NULL),NULL),NULL) attribute1_5,
decode(nvl(net_zero_adjustment_flag_1,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute1_6,
NULL),NULL),NULL),NULL) attribute1_6,
decode(nvl(net_zero_adjustment_flag_1,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute1_7,
NULL),NULL),NULL),NULL) attribute1_7,
decode(nvl(net_zero_adjustment_flag_1,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute1_8,
NULL),NULL),NULL),NULL) attribute1_8,
decode(nvl(net_zero_adjustment_flag_1,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute1_9,
NULL),NULL),NULL),NULL) attribute1_9,
decode(nvl(net_zero_adjustment_flag_1,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute1_10,
NULL),NULL),NULL),NULL) attribute1_10,
null orig_transaction_reference_1,
l_dummy adjusted_expenditure_item_id_1,
net_zero_adjustment_flag_1,
decode(nvl(net_zero_adjustment_flag_1,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_cmt_flag,'Y',expenditure_comment_1,
NULL),NULL),NULL),NULL) expenditure_comment_1,
l_dummy expenditure_item_id_2,
decode(nvl(net_zero_adjustment_flag_2,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
trunc(nvl(expenditure_item_date_2, sysdate) + x_days_diff),
l_dummy_date),l_dummy_date),l_dummy_date) expenditure_item_date_2,
decode(nvl(net_zero_adjustment_flag_2,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',quantity_2,
l_dummy),l_dummy),l_dummy) quantity_2,
decode(nvl(net_zero_adjustment_flag_2,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',system_linkage_function_2,
NULL),NULL),NULL) system_linkage_function_2,
null non_labor_resource_2,
l_dummy organization_id_2,
l_dummy override_to_organization_id_2,
l_dummy raw_cost_2,
l_dummy raw_cost_rate_2,
decode(nvl(net_zero_adjustment_flag_2,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute_category_2,
NULL),NULL),NULL),NULL) attribute_category_2,
decode(nvl(net_zero_adjustment_flag_2,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute2_1,
NULL),NULL),NULL),NULL) attribute2_1,
decode(nvl(net_zero_adjustment_flag_2,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute2_2,
NULL),NULL),NULL),NULL) attribute2_2,
decode(nvl(net_zero_adjustment_flag_2,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute2_3,
NULL),NULL),NULL),NULL) attribute2_3,
decode(nvl(net_zero_adjustment_flag_2,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute2_4,
NULL),NULL),NULL),NULL) attribute2_4,
decode(nvl(net_zero_adjustment_flag_2,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute2_5,
NULL),NULL),NULL),NULL) attribute2_5,
decode(nvl(net_zero_adjustment_flag_2,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute2_6,
NULL),NULL),NULL),NULL) attribute2_6,
decode(nvl(net_zero_adjustment_flag_2,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute2_7,
NULL),NULL),NULL),NULL) attribute2_7,
decode(nvl(net_zero_adjustment_flag_2,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute2_8,
NULL),NULL),NULL),NULL) attribute2_8,
decode(nvl(net_zero_adjustment_flag_2,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute2_9,
NULL),NULL),NULL),NULL) attribute2_9,
decode(nvl(net_zero_adjustment_flag_2,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute2_10,
NULL),NULL),NULL),NULL) attribute2_10,
null orig_transaction_reference_2,
l_dummy adjusted_expenditure_item_id_2,
net_zero_adjustment_flag_2,
decode(nvl(net_zero_adjustment_flag_2,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_cmt_flag,'Y',expenditure_comment_2,
NULL),NULL),NULL),NULL) expenditure_comment_2,
l_dummy expenditure_item_id_3,
decode(nvl(net_zero_adjustment_flag_3,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
trunc(nvl(expenditure_item_date_3,sysdate) + x_days_diff),
l_dummy_date),l_dummy_date),l_dummy_date) expenditure_item_date_3,
decode(nvl(net_zero_adjustment_flag_3,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',quantity_3,
l_dummy),l_dummy),l_dummy) quantity_3,
decode(nvl(net_zero_adjustment_flag_3,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y', system_linkage_function_3,
NULL),NULL),NULL) system_linkage_function_3,
non_labor_resource_3,
l_dummy organization_id_3,
l_dummy override_to_organization_id_3,
l_dummy raw_cost_3,
l_dummy raw_cost_rate_3,
decode(nvl(net_zero_adjustment_flag_3,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute_category_3,
NULL),NULL),NULL),NULL) attribute_category_3,
decode(nvl(net_zero_adjustment_flag_3,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute3_1,
NULL),NULL),NULL),NULL) attribute3_1,
decode(nvl(net_zero_adjustment_flag_3,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute3_2,
NULL),NULL),NULL),NULL) attribute3_2,
decode(nvl(net_zero_adjustment_flag_3,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute3_3,
NULL),NULL),NULL),NULL) attribute3_3,
decode(nvl(net_zero_adjustment_flag_3,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute3_4,
NULL),NULL),NULL),NULL) attribute3_4,
decode(nvl(net_zero_adjustment_flag_3,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute3_5,
NULL),NULL),NULL),NULL) attribute3_5,
decode(nvl(net_zero_adjustment_flag_3,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute3_6,
NULL),NULL),NULL),NULL) attribute3_6,
decode(nvl(net_zero_adjustment_flag_3,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute3_7,
NULL),NULL),NULL),NULL) attribute3_7,
decode(nvl(net_zero_adjustment_flag_3,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute3_8,
NULL),NULL),NULL),NULL) attribute3_8,
decode(nvl(net_zero_adjustment_flag_3,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute3_9,
NULL),NULL),NULL),NULL) attribute3_9,
decode(nvl(net_zero_adjustment_flag_3,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute3_10,
NULL),NULL),NULL),NULL) attribute3_10,
null orig_transaction_reference_3,
l_dummy adjusted_expenditure_item_id_3,
net_zero_adjustment_flag_3,
decode(nvl(net_zero_adjustment_flag_3,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_cmt_flag,'Y',expenditure_comment_3,
NULL),NULL),NULL),NULL) expenditure_comment_3,
l_dummy expenditure_item_id_4,
decode(nvl(net_zero_adjustment_flag_4,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
trunc(nvl(expenditure_item_date_4,sysdate) + x_days_diff),
l_dummy_date),l_dummy_date),l_dummy_date) expenditure_item_date_4,
decode(nvl(net_zero_adjustment_flag_4,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',quantity_4,
l_dummy),l_dummy),l_dummy) quantity_4,
decode(nvl(net_zero_adjustment_flag_4,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',system_linkage_function_4,
NULL),NULL),NULL) system_linkage_function_4,
null non_labor_resource_4,
l_dummy organization_id_4,
l_dummy override_to_organization_id_4,
l_dummy raw_cost_4,
l_dummy raw_cost_rate_4,
decode(nvl(net_zero_adjustment_flag_4,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute_category_4,
NULL),NULL),NULL),NULL) attribute_category_4,
decode(nvl(net_zero_adjustment_flag_4,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute4_1,
NULL),NULL),NULL),NULL) attribute4_1,
decode(nvl(net_zero_adjustment_flag_4,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute4_2,
NULL),NULL),NULL),NULL) attribute4_2,
decode(nvl(net_zero_adjustment_flag_4,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute4_3,
NULL),NULL),NULL),NULL) attribute4_3,
decode(nvl(net_zero_adjustment_flag_4,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute4_4,
NULL),NULL),NULL),NULL) attribute4_4,
decode(nvl(net_zero_adjustment_flag_4,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute4_5,
NULL),NULL),NULL),NULL) attribute4_5,
decode(nvl(net_zero_adjustment_flag_4,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute4_6,
NULL),NULL),NULL),NULL) attribute4_6,
decode(nvl(net_zero_adjustment_flag_4,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute4_7,
NULL),NULL),NULL),NULL) attribute4_7,
decode(nvl(net_zero_adjustment_flag_4,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute4_8,
NULL),NULL),NULL),NULL) attribute4_8,
decode(nvl(net_zero_adjustment_flag_4,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute4_9,
NULL),NULL),NULL),NULL) attribute4_9,
decode(nvl(net_zero_adjustment_flag_4,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute4_10,
NULL),NULL),NULL),NULL) attribute4_10,
null orig_transaction_reference_4,
l_dummy adjusted_expenditure_item_id_4,
null net_zero_adjustment_flag_4,
decode(nvl(net_zero_adjustment_flag_4,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_cmt_flag,'Y',expenditure_comment_4,
NULL),NULL),NULL),NULL) expenditure_comment_4,
l_dummy expenditure_item_id_5,
decode(nvl(net_zero_adjustment_flag_5,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
trunc(nvl(expenditure_item_date_5,sysdate) + x_days_diff),
l_dummy_date),l_dummy_date),l_dummy_date) expenditure_item_date_5,
decode(nvl(net_zero_adjustment_flag_5,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',quantity_5,
l_dummy),l_dummy),l_dummy) quantity_5,
decode(nvl(net_zero_adjustment_flag_5,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',system_linkage_function_5,
NULL),NULL),NULL) system_linkage_function_5,
null non_labor_resource_5,
l_dummy organization_id_5,
l_dummy override_to_organization_id_5,
l_dummy raw_cost_5,
l_dummy raw_cost_rate_5,
decode(nvl(net_zero_adjustment_flag_5,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute_category_5,
NULL),NULL),NULL),NULL) attribute_category_5,
decode(nvl(net_zero_adjustment_flag_5,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute5_1,
NULL),NULL),NULL),NULL) attribute5_1,
decode(nvl(net_zero_adjustment_flag_5,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute5_2,
NULL),NULL),NULL),NULL) attribute5_2,
decode(nvl(net_zero_adjustment_flag_5,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute5_3,
NULL),NULL),NULL),NULL) attribute5_3,
decode(nvl(net_zero_adjustment_flag_5,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute5_4,
NULL),NULL),NULL),NULL) attribute5_4,
decode(nvl(net_zero_adjustment_flag_5,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute5_5,
NULL),NULL),NULL),NULL) attribute5_5,
decode(nvl(net_zero_adjustment_flag_5,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute5_6,
NULL),NULL),NULL),NULL) attribute5_6,
decode(nvl(net_zero_adjustment_flag_5,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute5_7,
NULL),NULL),NULL),NULL) attribute5_7,
decode(nvl(net_zero_adjustment_flag_5,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute5_8,
NULL),NULL),NULL),NULL) attribute5_8,
decode(nvl(net_zero_adjustment_flag_5,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute5_9,
NULL),NULL),NULL),NULL) attribute5_9,
decode(nvl(net_zero_adjustment_flag_5,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute5_10,
NULL),NULL),NULL),NULL) attribute5_10,
null orig_transaction_reference_5,
l_dummy adjusted_expenditure_item_id_5,
net_zero_adjustment_flag_5,
decode(nvl(net_zero_adjustment_flag_5,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_cmt_flag,'Y',expenditure_comment_5,
NULL),NULL),NULL),NULL) expenditure_comment_5,
l_dummy expenditure_item_id_6,
decode(nvl(net_zero_adjustment_flag_6,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
trunc(nvl(expenditure_item_date_6,sysdate) + x_days_diff),
l_dummy_date),l_dummy_date),l_dummy_date) expenditure_item_date_6,
decode(nvl(net_zero_adjustment_flag_6,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',quantity_6,
l_dummy),l_dummy),l_dummy) quantity_6,
decode(nvl(net_zero_adjustment_flag_6,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',system_linkage_function_6,
NULL),NULL),NULL) system_linkage_function_6,
null non_labor_resource_6,
l_dummy organization_id_6,
l_dummy override_to_organization_id_6,
l_dummy raw_cost_6,
l_dummy raw_cost_rate_6,
decode(nvl(net_zero_adjustment_flag_6,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute_category_6,
NULL),NULL),NULL),NULL) attribute_category_6,
decode(nvl(net_zero_adjustment_flag_6,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute6_1,
NULL),NULL),NULL),NULL) attribute6_1,
decode(nvl(net_zero_adjustment_flag_6,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute6_2,
NULL),NULL),NULL),NULL) attribute6_2,
decode(nvl(net_zero_adjustment_flag_6,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute6_3,
NULL),NULL),NULL),NULL) attribute6_3,
decode(nvl(net_zero_adjustment_flag_6,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute6_4,
NULL),NULL),NULL),NULL) attribute6_4,
decode(nvl(net_zero_adjustment_flag_6,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute6_5,
NULL),NULL),NULL),NULL) attribute6_5,
decode(nvl(net_zero_adjustment_flag_6,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute6_6,
NULL),NULL),NULL),NULL) attribute6_6,
decode(nvl(net_zero_adjustment_flag_6,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute6_7,
NULL),NULL),NULL),NULL) attribute6_7,
decode(nvl(net_zero_adjustment_flag_6,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute6_8,
NULL),NULL),NULL),NULL) attribute6_8,
decode(nvl(net_zero_adjustment_flag_6,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute6_9,
NULL),NULL),NULL),NULL) attribute6_9,
decode(nvl(net_zero_adjustment_flag_6,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute6_10,
NULL),NULL),NULL),NULL) attribute6_10,
null orig_transaction_reference_6,
l_dummy adjusted_expenditure_item_id_6,
net_zero_adjustment_flag_6,
decode(nvl(net_zero_adjustment_flag_6,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_cmt_flag,'Y',expenditure_comment_6,
NULL),NULL),NULL),NULL) expenditure_comment_6,
l_dummy expenditure_item_id_7,
decode(nvl(net_zero_adjustment_flag_7,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
trunc(nvl(expenditure_item_date_7,sysdate) + x_days_diff),
l_dummy_date),l_dummy_date),l_dummy_date) expenditure_item_date_7,
decode(nvl(net_zero_adjustment_flag_7,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',quantity_7,
l_dummy),l_dummy),l_dummy) quantity_7,
decode(nvl(net_zero_adjustment_flag_7,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',system_linkage_function_7,
NULL),NULL),NULL) system_linkage_function_7,
null non_labor_resource_7,
l_dummy organization_id_7,
l_dummy override_to_organization_id_7,
l_dummy raw_cost_7,
l_dummy raw_cost_rate_7,
decode(nvl(net_zero_adjustment_flag_7,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute_category_7,
NULL),NULL),NULL),NULL) attribute_category_7,
decode(nvl(net_zero_adjustment_flag_7,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute7_1,
NULL),NULL),NULL),NULL) attribute7_1,
decode(nvl(net_zero_adjustment_flag_7,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute7_2,
NULL),NULL),NULL),NULL) attribute7_2,
decode(nvl(net_zero_adjustment_flag_7,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute7_3,
NULL),NULL),NULL),NULL) attribute7_3,
decode(nvl(net_zero_adjustment_flag_7,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute7_4,
NULL),NULL),NULL),NULL) attribute7_4,
decode(nvl(net_zero_adjustment_flag_7,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute7_5,
NULL),NULL),NULL),NULL) attribute7_5,
decode(nvl(net_zero_adjustment_flag_7,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute7_6,
NULL),NULL),NULL),NULL) attribute7_6,
decode(nvl(net_zero_adjustment_flag_7,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute7_7,
NULL),NULL),NULL),NULL) attribute7_7,
decode(nvl(net_zero_adjustment_flag_7,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute7_8,
NULL),NULL),NULL),NULL) attribute7_8,
decode(nvl(net_zero_adjustment_flag_7,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute7_9,
NULL),NULL),NULL),NULL) attribute7_9,
decode(nvl(net_zero_adjustment_flag_7,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_dff_flag,'Y',attribute7_10,
NULL),NULL),NULL),NULL) attribute7_10,
null orig_transaction_reference_7,
l_dummy adjusted_expenditure_item_id_7,
net_zero_adjustment_flag_7,
decode(nvl(net_zero_adjustment_flag_7,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',
decode(G_copy_cmt_flag,'Y',expenditure_comment_7,
NULL),NULL),NULL),NULL) expenditure_comment_7,
0 denorm_total_qty,
0 denorm_total_amount,
G_user created_by,
trunc(sysdate) creation_date,
trunc(sysdate) last_update_date,
G_user last_updated_by,
FND_PROFILE.VALUE('LOGIN_ID') last_update_login,
decode(nvl(net_zero_adjustment_flag_1,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',job_id_1,
l_dummy),l_dummy),l_dummy) job_id_1,
decode(nvl(net_zero_adjustment_flag_2,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',job_id_2,
l_dummy),l_dummy),l_dummy) job_id_2,
decode(nvl(net_zero_adjustment_flag_3,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',job_id_3,
l_dummy),l_dummy),l_dummy) job_id_3,
decode(nvl(net_zero_adjustment_flag_4,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',job_id_4,
l_dummy),l_dummy),l_dummy) job_id_4,
decode(nvl(net_zero_adjustment_flag_5,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',job_id_5,
l_dummy),l_dummy),l_dummy) job_id_5,
decode(nvl(net_zero_adjustment_flag_6,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',job_id_6,
l_dummy),l_dummy),l_dummy) job_id_6,
decode(nvl(net_zero_adjustment_flag_7,'N'),'N',
decode(G_copy_exp_type_flag,'Y',
decode(G_copy_qty_flag,'Y',job_id_7,
l_dummy),l_dummy),l_dummy) job_id_7
FROM
pa_ei_denorm
WHERE expenditure_id = x_orig_exp_id;
-- Insert denorm record into pa_ei_denorm regards if any quantities got thru or not.
pa_online_exp.insert_pa_ei_denorm_rec(
ei_denorm.expenditure_id,
ei_denorm.denorm_id,
ei_denorm.person_id,
ei_denorm.project_id,
ei_denorm.task_id,
ei_denorm.billable_flag,
ei_denorm.expenditure_type,
ei_denorm.default_sys_link_func,
ei_denorm.unit_of_measure_code,
ei_denorm.unit_of_measure,
ei_denorm.expenditure_item_id_1,
ei_denorm.expenditure_item_date_1,
ei_denorm.quantity_1,
ei_denorm.system_linkage_function_1,
ei_denorm.non_labor_resource_1,
ei_denorm.organization_id_1,
ei_denorm.override_to_organization_id_1,
ei_denorm.raw_cost_1,
ei_denorm.raw_cost_rate_1,
ei_denorm.attribute_category_1,
ei_denorm.attribute1_1,
ei_denorm.attribute1_2,
ei_denorm.attribute1_3,
ei_denorm.attribute1_4,
ei_denorm.attribute1_5,
ei_denorm.attribute1_6,
ei_denorm.attribute1_7,
ei_denorm.attribute1_8,
ei_denorm.attribute1_9,
ei_denorm.attribute1_10,
ei_denorm.orig_transaction_reference_1,
ei_denorm.adjusted_expenditure_item_id_1,
ei_denorm.net_zero_adjustment_flag_1,
ei_denorm.expenditure_comment_1,
ei_denorm.expenditure_item_id_2,
ei_denorm.expenditure_item_date_2,
ei_denorm.quantity_2,
ei_denorm.system_linkage_function_2,
ei_denorm.non_labor_resource_2,
ei_denorm.organization_id_2,
ei_denorm.override_to_organization_id_2,
ei_denorm.raw_cost_2,
ei_denorm.raw_cost_rate_2,
ei_denorm.attribute_category_2,
ei_denorm.attribute2_1,
ei_denorm.attribute2_2,
ei_denorm.attribute2_3,
ei_denorm.attribute2_4,
ei_denorm.attribute2_5,
ei_denorm.attribute2_6,
ei_denorm.attribute2_7,
ei_denorm.attribute2_8,
ei_denorm.attribute2_9,
ei_denorm.attribute2_10,
ei_denorm.orig_transaction_reference_2,
ei_denorm.adjusted_expenditure_item_id_2,
ei_denorm.net_zero_adjustment_flag_2,
ei_denorm.expenditure_comment_2,
ei_denorm.expenditure_item_id_3,
ei_denorm.expenditure_item_date_3,
ei_denorm.quantity_3,
ei_denorm.system_linkage_function_3,
ei_denorm.non_labor_resource_3,
ei_denorm.organization_id_3,
ei_denorm.override_to_organization_id_3,
ei_denorm.raw_cost_3,
ei_denorm.raw_cost_rate_3,
ei_denorm.attribute_category_3,
ei_denorm.attribute3_1,
ei_denorm.attribute3_2,
ei_denorm.attribute3_3,
ei_denorm.attribute3_4,
ei_denorm.attribute3_5,
ei_denorm.attribute3_6,
ei_denorm.attribute3_7,
ei_denorm.attribute3_8,
ei_denorm.attribute3_9,
ei_denorm.attribute3_10,
ei_denorm.orig_transaction_reference_3,
ei_denorm.adjusted_expenditure_item_id_3,
ei_denorm.net_zero_adjustment_flag_3,
ei_denorm.expenditure_comment_3,
ei_denorm.expenditure_item_id_4,
ei_denorm.expenditure_item_date_4,
ei_denorm.quantity_4,
ei_denorm.system_linkage_function_4,
ei_denorm.non_labor_resource_4,
ei_denorm.organization_id_4,
ei_denorm.override_to_organization_id_4,
ei_denorm.raw_cost_4,
ei_denorm.raw_cost_rate_4,
ei_denorm.attribute_category_4,
ei_denorm.attribute4_1,
ei_denorm.attribute4_2,
ei_denorm.attribute4_3,
ei_denorm.attribute4_4,
ei_denorm.attribute4_5,
ei_denorm.attribute4_6,
ei_denorm.attribute4_7,
ei_denorm.attribute4_8,
ei_denorm.attribute4_9,
ei_denorm.attribute4_10,
ei_denorm.orig_transaction_reference_4,
ei_denorm.adjusted_expenditure_item_id_4,
ei_denorm.net_zero_adjustment_flag_4,
ei_denorm.expenditure_comment_4,
ei_denorm.expenditure_item_id_5,
ei_denorm.expenditure_item_date_5,
ei_denorm.quantity_5,
ei_denorm.system_linkage_function_5,
ei_denorm.non_labor_resource_5,
ei_denorm.organization_id_5,
ei_denorm.override_to_organization_id_5,
ei_denorm.raw_cost_5,
ei_denorm.raw_cost_rate_5,
ei_denorm.attribute_category_5,
ei_denorm.attribute5_1,
ei_denorm.attribute5_2,
ei_denorm.attribute5_3,
ei_denorm.attribute5_4,
ei_denorm.attribute5_5,
ei_denorm.attribute5_6,
ei_denorm.attribute5_7,
ei_denorm.attribute5_8,
ei_denorm.attribute5_9,
ei_denorm.attribute5_10,
ei_denorm.orig_transaction_reference_5,
ei_denorm.adjusted_expenditure_item_id_5,
ei_denorm.net_zero_adjustment_flag_5,
ei_denorm.expenditure_comment_5,
ei_denorm.expenditure_item_id_6,
ei_denorm.expenditure_item_date_6,
ei_denorm.quantity_6,
ei_denorm.system_linkage_function_6,
ei_denorm.non_labor_resource_6,
ei_denorm.organization_id_6,
ei_denorm.override_to_organization_id_6,
ei_denorm.raw_cost_6,
ei_denorm.raw_cost_rate_6,
ei_denorm.attribute_category_6,
ei_denorm.attribute6_1,
ei_denorm.attribute6_2,
ei_denorm.attribute6_3,
ei_denorm.attribute6_4,
ei_denorm.attribute6_5,
ei_denorm.attribute6_6,
ei_denorm.attribute6_7,
ei_denorm.attribute6_8,
ei_denorm.attribute6_9,
ei_denorm.attribute6_10,
ei_denorm.orig_transaction_reference_6,
ei_denorm.adjusted_expenditure_item_id_6,
ei_denorm.net_zero_adjustment_flag_6,
ei_denorm.expenditure_comment_6,
ei_denorm.expenditure_item_id_7,
ei_denorm.expenditure_item_date_7,
ei_denorm.quantity_7,
ei_denorm.system_linkage_function_7,
ei_denorm.non_labor_resource_7,
ei_denorm.organization_id_7,
ei_denorm.override_to_organization_id_7,
ei_denorm.raw_cost_7,
ei_denorm.raw_cost_rate_7,
ei_denorm.attribute_category_7,
ei_denorm.attribute7_1,
ei_denorm.attribute7_2,
ei_denorm.attribute7_3,
ei_denorm.attribute7_4,
ei_denorm.attribute7_5,
ei_denorm.attribute7_6,
ei_denorm.attribute7_7,
ei_denorm.attribute7_8,
ei_denorm.attribute7_9,
ei_denorm.attribute7_10,
ei_denorm.orig_transaction_reference_7,
ei_denorm.adjusted_expenditure_item_id_7,
ei_denorm.net_zero_adjustment_flag_7,
ei_denorm.expenditure_comment_7,
ei_denorm.denorm_total_qty,
ei_denorm.denorm_total_amount,
ei_denorm.created_by,
ei_denorm.creation_date,
ei_denorm.last_update_date,
ei_denorm.last_updated_by,
ei_denorm.last_update_login,
ei_denorm.job_id_1,
ei_denorm.job_id_2,
ei_denorm.job_id_3,
ei_denorm.job_id_4,
ei_denorm.job_id_5,
ei_denorm.job_id_6,
ei_denorm.job_id_7);
SELECT 'Y'
INTO x_return
FROM SYS.DUAL
WHERE EXISTS (SELECT 'x'
FROM PA_EI_DENORM
WHERE EXPENDITURE_ID = x_orig_exp_id);