PA Transaction Sources

Description

Application: Projects
Source: IMP: Transaction Sources (XML)
Short Name: PAXTRTXS_XML
DB package: PA_PAXTRTXS_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

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