Oracle EBS Latam Tax-Source and Type Relationship

Oracle EBS Latam Tax-Source and Type Relationship

Tables:-
JG_ZZ_AR_SRC_TRX_TY_ALL

SQL Example:-
SELECT
hou.name  "OU NAME"
,(SELECT name
    FROM apps.RA_CUST_TRX_TYPES_ALL rct
      WHERE rct.cust_trx_type_id = jt.cust_trx_type_id) "Transaction Type Name"
,(SELECT name
    FROM apps.RA_BATCH_SOURCES_ALL rbs
      WHERE rbs.batch_source_id =jt.batch_source_id)  "Transaction Source Name"
,jt.Invoice_class "Invoice Class"
FROM
JG_ZZ_AR_SRC_TRX_TY_ALL jt
,hr_operating_units hou
WHERE 1=1
AND jt.org_id = hou.organization_id 
AND hou.short_code= '&&';