PA Transaction Import

Description
Categories: BI Publisher, Financials
Application: Projects
Source: PRC: Transaction Import (XML)
Short Name: PAXTRTRX_XML
DB package: PA_PAXTRTRX_XMLP_PKG
SELECT 
               substr(ti.batch_name,1,20)  batch      
,               substr(ti.batch_name,1,20)  batch_name     
,               NVL(pa_utils3.GetEmpNum(ti.person_id),ti.employee_number) employee_number
,               substr(NVL(pa_utils.GetOrgName(ti.organization_id),ti.organization_name),1, 60) organization_name
,               ti.expenditure_item_date
,               ti.expenditure_type
,               NVL(pa_utils3.getcachedprojnum(ti.PROJECT_ID),ti.project_number) project_number
,               NVL(pa_utils3.getcachedtasknum(ti.TASK_ID),ti.task_number) task_number
,               ti.non_labor_resource
,               ti.transaction_rejection_code
,	DECODE(ti.transaction_status_code, 'PR', 1, 'R', 2, 3) sort_c
FROM
                pa_transaction_interface_all ti   
 WHERE
                ti.transaction_status_code IN ('R', 'PR', 'PO')
      AND  ti.transaction_rejection_code IS NOT NULL
      AND  ti.batch_name = NVL( :P_batch_name, ti.batch_name )      
      AND  ti.interface_id = :P_xface_id
     AND  ((mo_global.get_current_org_id IS NULL AND mo_global.check_access(ti.org_id) = 'Y')                   
               OR ( mo_global.get_current_org_id is NOT NULL and ti.org_id = mo_global.get_current_org_id ))    
GROUP BY
                ti.transaction_status_code
,               ti.batch_name
,               ti.batch_name
,               NVL(pa_utils3.GetEmpNum(ti.person_id),ti.employee_number)
,               NVL(pa_utils.GetOrgName(ti.organization_id),ti.organization_name)
,               ti.expenditure_item_date
,               ti.expenditure_type
,               NVL(pa_utils3.getcachedprojnum(ti.PROJECT_ID),ti.project_number)
,               NVL(pa_utils3.getcachedtasknum(ti.TASK_ID),ti.task_number)
,               ti.non_labor_resource
,               ti.transaction_rejection_code
,               ti.ROWID
ORDER BY sort_c
Parameter Name SQL text Validation
Batch Name
 
LOV Oracle
Transaction Source
 
LOV Oracle