PA Transaction Sources

➜ Back to Library
Description
Categories: BI Publisher
Application: Projects
Source: IMP: Transaction Sources (XML)
Short Name: PAXTRTXS_XML
DB package: PA_PAXTRTXS_XMLP_PKG
Run PA Transaction Sources and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT
                ts.transaction_source
,               sl.meaning   meaning
,               ts.description
,               l.meaning  meaning1
,               l2.meaning meaning2
,               ts.start_date_active
,               ts.end_date_active
  FROM
                pa_transaction_sources ts
,               pa_system_linkages sl
,               fnd_lookups l
,               fnd_lookups l2
 WHERE
                 ts.system_linkage_function = sl.function
       AND  l.lookup_type = 'YES_NO'
       AND  l2.lookup_type = 'YES_NO'
       AND  l.lookup_code = ts.costed_flag
       AND  l2.lookup_code = ts.purgeable_flag
ORDER BY 
                 ts.transaction_source
Download
 
Related Blitz Reports
PA Project Subledger: Detail by Expenditure Type PA Project Subledger: Detail by Project PA Project Subledger Summary Yanmar - Discount on order lines check PA Expenditure Types PA AUD: Expenditure Batch Status PPF_WP3_OM_DETAILS ONT Orders and Lines GL Account Analysis
Blitz Report™

Blitz Report™ provides multiple benefits: