PA Transaction Import

➜ Back to Library
Description
Categories: BI Publisher
Application: Projects
Source: PRC: Transaction Import (XML)
Short Name: PAXTRTRX_XML
DB package: PA_PAXTRTRX_XMLP_PKG
Run PA Transaction Import and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Transaction Source 
 
 LOV Oracle
Batch Name 
 
 LOV Oracle
Download
Related Blitz Reports
ECC Receivables, Outstanding Receivables (14) ECC Receivables, Outstanding Receivables (2) ECC Receivables, Outstanding Receivables (1) ECC Projects, Projects Costing: Transactions, SQL1 GL SLA Drillback Diagnostic ECC Receivables, Payment History, SQL1 ECC Receivables, Outstanding Receivables (16) ECC Receivables, Outstanding Receivables (7) ECC Receivables, Outstanding Receivables (18) ECC Receivables, Billing Process, SQL1
Blitz Report™

Blitz Report™ provides multiple benefits: