eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TRANSACTIONS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 605


SELECT net_zero_adjustment_flag
FROM   pa_expenditure_items_all ei,
       pa_expenditures_all exp,
       per_all_people_f per,
       pa_projects_all proj,
       pa_tasks task,
       hr_all_organization_units hr1
WHERE  ei.transaction_source = x_transaction_source AND
       ei.orig_transaction_reference = x_orig_transaction_reference AND
       ei.system_linkage_function = x_expenditure_type_class AND
       ei.expenditure_type = x_expenditure_type AND
       ei.expenditure_item_id = nvl(x_expenditure_item_id, ei.expenditure_item_id) AND
       ei.expenditure_item_date = x_expenditure_item_date AND
       NVL(per.employee_number,per.npw_number) = nvl(x_employee_number, nvl(per.employee_number,per.npw_number) ) AND /* FP.M / CWK Changes */
       ei.expenditure_item_date BETWEEN per.effective_start_date AND per.effective_end_date AND
       per.person_id = exp.incurred_by_person_id AND
       exp.expenditure_id = ei.expenditure_id AND
       hr1.name = nvl(x_expenditure_org_name,hr1.name) AND
       hr1.organization_id = exp.incurred_by_organization_id AND
       proj.segment1 = x_project_number AND
       task.project_id = proj.project_id AND
       task.task_number = x_task_number AND
       ei.task_id = task.task_id AND
       ei.quantity = x_quantity AND
       nvl(ei.raw_cost,'-99') = nvl(x_raw_cost,nvl(ei.raw_cost,'-99')) AND
       nvl(ei.attribute_category,'-99') = nvl(x_attribute_category,nvl(ei.attribute_category,'-99')) AND
       nvl(ei.attribute1,'-99') = nvl(x_attribute1, nvl(ei.attribute1,'-99')) AND
       nvl(ei.attribute2,'-99') = nvl(x_attribute2, nvl(ei.attribute2,'-99')) AND
       nvl(ei.attribute3,'-99') = nvl(x_attribute3, nvl(ei.attribute3,'-99')) AND
       nvl(ei.attribute4,'-99') = nvl(x_attribute4, nvl(ei.attribute4,'-99')) AND
       nvl(ei.attribute5,'-99') = nvl(x_attribute5, nvl(ei.attribute5,'-99')) AND
       nvl(ei.attribute6,'-99') = nvl(x_attribute6, nvl(ei.attribute6,'-99')) AND
       nvl(ei.attribute7,'-99') = nvl(x_attribute7, nvl(ei.attribute7,'-99')) AND
       nvl(ei.attribute8,'-99') = nvl(x_attribute8, nvl(ei.attribute8,'-99')) AND
       nvl(ei.attribute9,'-99') = nvl(x_attribute9, nvl(ei.attribute9,'-99')) AND
       nvl(ei.attribute10,'-99') = nvl(x_attribute10, nvl(ei.attribute10,'-99')) AND
       nvl(ei.org_id,'-99') = nvl(x_org_id,nvl(ei.org_id,'-99')) AND
       x_expenditure_type_class <> 'USG' AND
       x_expenditure_type_class <> 'VI'
UNION ALL
--The second part of the UNION handles Usages (expenditure_type_class='USG')
--when IN parameter x_employee_number is NOT NULL.  The additional join to
--hr_all_organization_units hr2 is required.
SELECT net_zero_adjustment_flag
FROM   pa_expenditure_items_all ei,
       pa_expenditures_all exp,
       per_all_people_f per,
       pa_projects_all proj,
       pa_tasks task,
       hr_all_organization_units hr1,
       hr_all_organization_units hr2
WHERE  ei.transaction_source = x_transaction_source AND
       ei.orig_transaction_reference = x_orig_transaction_reference AND
       ei.system_linkage_function = x_expenditure_type_class AND
       ei.expenditure_type = x_expenditure_type AND
       ei.expenditure_item_id = nvl(x_expenditure_item_id, ei.expenditure_item_id) AND
       ei.expenditure_item_date = x_expenditure_item_date AND
       nvl(per.employee_number,per.npw_number) = x_employee_number AND /* FP.M / CWK Changes */
       ei.expenditure_item_date BETWEEN per.effective_start_date AND per.effective_end_date AND
       per.person_id = exp.incurred_by_person_id AND
       exp.expenditure_id = ei.expenditure_id AND
       hr1.name = nvl(x_expenditure_org_name,hr1.name) AND
       hr1.organization_id = exp.incurred_by_organization_id AND
       proj.segment1 = x_project_number AND
       task.project_id = proj.project_id AND
       task.task_number = x_task_number AND
       ei.task_id = task.task_id AND
       nvl(ei.non_labor_resource,'-99') = nvl(x_non_labor_resource,nvl(ei.non_labor_resource,'-99')) AND
       hr2.name = nvl(x_non_labor_resource_org_name,hr2.name) AND
       hr2.organization_id = ei.organization_id AND
       ei.quantity = x_quantity AND
       nvl(ei.raw_cost,'-99') = nvl(x_raw_cost,nvl(ei.raw_cost,'-99')) AND
       nvl(ei.attribute_category,'-99') = nvl(x_attribute_category,nvl(ei.attribute_category,'-99')) AND
       nvl(ei.attribute1,'-99') = nvl(x_attribute1, nvl(ei.attribute1,'-99')) AND
       nvl(ei.attribute2,'-99') = nvl(x_attribute2, nvl(ei.attribute2,'-99')) AND
       nvl(ei.attribute3,'-99') = nvl(x_attribute3, nvl(ei.attribute3,'-99')) AND
       nvl(ei.attribute4,'-99') = nvl(x_attribute4, nvl(ei.attribute4,'-99')) AND
       nvl(ei.attribute5,'-99') = nvl(x_attribute5, nvl(ei.attribute5,'-99')) AND
       nvl(ei.attribute6,'-99') = nvl(x_attribute6, nvl(ei.attribute6,'-99')) AND
       nvl(ei.attribute7,'-99') = nvl(x_attribute7, nvl(ei.attribute7,'-99')) AND
       nvl(ei.attribute8,'-99') = nvl(x_attribute8, nvl(ei.attribute8,'-99')) AND
       nvl(ei.attribute9,'-99') = nvl(x_attribute9, nvl(ei.attribute9,'-99')) AND
       nvl(ei.attribute10,'-99') = nvl(x_attribute10, nvl(ei.attribute10,'-99')) AND
       nvl(ei.org_id,'-99') = nvl(x_org_id,nvl(ei.org_id,'-99')) AND
       x_expenditure_type_class = 'USG' AND
       x_employee_number IS NOT NULL
UNION ALL
--The third part of the UNION handles Usages (expenditure_type_class='USG')
--when IN PARAMETER x_exployee_number IS NULL.  The additional join to
--hr_all_organization_units hr2 is required and the join to per_all_people_f is not required.
SELECT net_zero_adjustment_flag
FROM   pa_expenditure_items_all ei,
       pa_expenditures_all exp,
       pa_projects_all proj,
       pa_tasks task,
       hr_all_organization_units hr1,
       hr_all_organization_units hr2
WHERE  ei.transaction_source = x_transaction_source AND
       ei.orig_transaction_reference = x_orig_transaction_reference AND
       ei.system_linkage_function = x_expenditure_type_class AND
       ei.expenditure_type = x_expenditure_type AND
       ei.expenditure_item_id = nvl(x_expenditure_item_id, ei.expenditure_item_id) AND
       ei.expenditure_item_date = x_expenditure_item_date AND
       exp.expenditure_id = ei.expenditure_id AND
       hr1.name = nvl(x_expenditure_org_name,hr1.name) AND
       hr1.organization_id = exp.incurred_by_organization_id AND
       proj.segment1 = x_project_number AND
       task.project_id = proj.project_id AND
       task.task_number = x_task_number AND
       ei.task_id = task.task_id AND
       nvl(ei.non_labor_resource,'-99') = nvl(x_non_labor_resource,nvl(ei.non_labor_resource,'-99')) AND
       hr2.name = nvl(x_non_labor_resource_org_name,hr2.name) AND
       hr2.organization_id = ei.organization_id AND
       ei.quantity = x_quantity AND
       nvl(ei.raw_cost,'-99') = nvl(x_raw_cost,nvl(ei.raw_cost,'-99')) AND
       nvl(ei.attribute_category,'-99') = nvl(x_attribute_category,nvl(ei.attribute_category,'-99')) AND
       nvl(ei.attribute1,'-99') = nvl(x_attribute1, nvl(ei.attribute1,'-99')) AND
       nvl(ei.attribute2,'-99') = nvl(x_attribute2, nvl(ei.attribute2,'-99')) AND
       nvl(ei.attribute3,'-99') = nvl(x_attribute3, nvl(ei.attribute3,'-99')) AND
       nvl(ei.attribute4,'-99') = nvl(x_attribute4, nvl(ei.attribute4,'-99')) AND
       nvl(ei.attribute5,'-99') = nvl(x_attribute5, nvl(ei.attribute5,'-99')) AND
       nvl(ei.attribute6,'-99') = nvl(x_attribute6, nvl(ei.attribute6,'-99')) AND
       nvl(ei.attribute7,'-99') = nvl(x_attribute7, nvl(ei.attribute7,'-99')) AND
       nvl(ei.attribute8,'-99') = nvl(x_attribute8, nvl(ei.attribute8,'-99')) AND
       nvl(ei.attribute9,'-99') = nvl(x_attribute9, nvl(ei.attribute9,'-99')) AND
       nvl(ei.attribute10,'-99') = nvl(x_attribute10, nvl(ei.attribute10,'-99')) AND
       nvl(ei.org_id,'-99') = nvl(x_org_id,nvl(ei.org_id,'-99')) AND
       x_expenditure_type_class = 'USG' AND
       x_employee_number IS NULL
UNION ALL
--The fourth part of the UNION handles Supplier Invoices (expenditure_type_class='VI').
--The join to per_all_people_f is not required as pa_expenditures_all.incurred_by_person_id
--is NULL for Supplier Invoices.
SELECT net_zero_adjustment_flag
FROM   pa_expenditure_items_all ei,
       pa_expenditures_all exp,
       pa_projects_all proj,
       pa_tasks task,
       hr_all_organization_units hr1
WHERE  ei.transaction_source = x_transaction_source AND
       ei.orig_transaction_reference = x_orig_transaction_reference AND
       ei.system_linkage_function = x_expenditure_type_class AND
       ei.expenditure_type = x_expenditure_type AND
       ei.expenditure_item_id = nvl(x_expenditure_item_id, ei.expenditure_item_id) AND
       ei.expenditure_item_date = x_expenditure_item_date AND
       exp.expenditure_id = ei.expenditure_id AND
       hr1.name = nvl(x_expenditure_org_name,hr1.name) AND
       hr1.organization_id = ei.override_to_organization_id AND
       proj.segment1 = x_project_number AND
       task.project_id = proj.project_id AND
       task.task_number = x_task_number AND
       ei.task_id = task.task_id AND
       ei.quantity = x_quantity AND
       nvl(ei.raw_cost,'-99') = nvl(x_raw_cost,nvl(ei.raw_cost,'-99')) AND
       nvl(ei.attribute_category,'-99') = nvl(x_attribute_category,nvl(ei.attribute_category,'-99')) AND
       nvl(ei.attribute1,'-99') = nvl(x_attribute1, nvl(ei.attribute1,'-99')) AND
       nvl(ei.attribute2,'-99') = nvl(x_attribute2, nvl(ei.attribute2,'-99')) AND
       nvl(ei.attribute3,'-99') = nvl(x_attribute3, nvl(ei.attribute3,'-99')) AND
       nvl(ei.attribute4,'-99') = nvl(x_attribute4, nvl(ei.attribute4,'-99')) AND
       nvl(ei.attribute5,'-99') = nvl(x_attribute5, nvl(ei.attribute5,'-99')) AND
       nvl(ei.attribute6,'-99') = nvl(x_attribute6, nvl(ei.attribute6,'-99')) AND
       nvl(ei.attribute7,'-99') = nvl(x_attribute7, nvl(ei.attribute7,'-99')) AND
       nvl(ei.attribute8,'-99') = nvl(x_attribute8, nvl(ei.attribute8,'-99')) AND
       nvl(ei.attribute9,'-99') = nvl(x_attribute9, nvl(ei.attribute9,'-99')) AND
       nvl(ei.attribute10,'-99') = nvl(x_attribute10, nvl(ei.attribute10,'-99')) AND
       nvl(ei.org_id,'-99') = nvl(x_org_id,nvl(ei.org_id,'-99')) AND
       x_expenditure_type_class = 'VI';

Line: 777


SELECT meaning
FROM   pa_lookups
WHERE  lookup_type = 'PA_ADJUSTMENT_STATUS'
AND    lookup_code = x_adjustment_status_code;