Oracle EBS GST-Third Party

Oracle EBS GST-Third Party
Configuration:Third Party,
Responsibility:Oracle Financials For India,
Navigation:Party Registration->Define Third Party Registration

Tables:-
JAI_PARTY_REGS_V
JAI_PARTY_REG_LINES
JAI_REGIMES
JAI_PARTY_REG_LINES_V
jai_reporting_associations

SQL Example:-

SELECT DISTINCT 
hou.NAME  "Opearting Unit"
,jprv.PARTY_CLASS_NAME "Party Type"
 ,jprv.PARTY_NAME "Party Name"
,jprv.PARTY_NUMBER "Party Number"
,jprv.PARTY_SITE_NAME  "Party Site Name"
,jprv.ITEM_CATEGORY_LIST_DESC  "Item Category"
,jprv.INVOICE_TAX_CATEGORY_NAME  "DTC for Standalone Invoice"
,jprv.PARTY_SITE_ADDRESS "Address"
,jr.REGIME_NAME "Regime Code"
,jprlv.REGISTRATION_TYPE_NAME "Primary Registration Name"
,jprl.REGISTRATION_NUMBER  "Primary Registration Number"
,jprlv.SEC_REGISTRATION_TYPE_NAME "Secondary Registration Name"
,jprl.SECONDARY_REGISTRATION_NUMBER  "Secondary Registration Number"
,jprlv.ASSESSABLE_PRICE_LIST_NAME "Assessable Price List"
,jprlv.DEFAULT_SECTION_NAME  "Default Section"
,jprl.EFFECTIVE_FROM  "Start Date"
,jprl.EFFECTIVE_TO  "End Date"
,(select REGIME_CODE from JAI_PARTY_EXEMPTION_LINES_V where PARTY_REG_ID=jprv.PARTY_REG_ID and LINE_CONTEXT='EXEMPTION') "E-Regime Code"
,(select REGISTRATION_NUMBER from JAI_PARTY_EXEMPTION_LINES_V where PARTY_REG_ID=jprv.PARTY_REG_ID and LINE_CONTEXT='EXEMPTION') "Registration Number"
,(select EXEMPTION_TYPE_DSP from JAI_PARTY_EXEMPTION_LINES_V where PARTY_REG_ID=jprv.PARTY_REG_ID and LINE_CONTEXT='EXEMPTION') "Exemption Type"
,(select TRACKING_NUM from JAI_PARTY_EXEMPTION_LINES_V where PARTY_REG_ID=jprv.PARTY_REG_ID and LINE_CONTEXT='EXEMPTION') "Tracking Number"
,(select EFFECTIVE_FROM from JAI_PARTY_EXEMPTION_LINES_V where PARTY_REG_ID=jprv.PARTY_REG_ID and LINE_CONTEXT='EXEMPTION') "E-Start Date"
,(select EFFECTIVE_TO from JAI_PARTY_EXEMPTION_LINES_V where PARTY_REG_ID=jprv.PARTY_REG_ID and LINE_CONTEXT='EXEMPTION') "E-End Date"
,(select REGIME_CODE from JAI_REGIMES where REGIME_ID=jra.REGIME_ID) "RC-Regime Code"
,jra.REPORTING_TYPE_NAME  "Reporting Type Name"
,jra.REPORTING_CODE "Reporting Code"
,jra.REPORTING_CODE_DESCRIPTION "Reporting Code Description"
,jra.EFFECTIVE_FROM "Reporting Start Date"
,jra.EFFECTIVE_TO "Reporting End Date"
FROM
APPS.JAI_PARTY_REGS_V  jprv,
APPS.hr_organization_units hou,
APPS.JAI_PARTY_REG_LINES jprl,
APPS.JAI_REGIMES jr,
APPS.JAI_PARTY_REG_LINES_V jprlv,
APPS.jai_reporting_associations  jra
WHERE 1=1
AND jprv.ORG_ID=hou.ORGANIZATION_ID
AND jprv.PARTY_REG_ID=jprl.PARTY_REG_ID
AND jprl.REGIME_ID=jr.REGIME_ID
AND jr.REGIME_TYPE='T'
AND jprl.PARTY_REG_ID=jprlv.PARTY_REG_ID
AND jprl.PARTY_REG_LINE_ID=jprlv.PARTY_REG_LINE_ID
AND jprv.PARTY_REG_ID=jra.ENTITY_ID
AND hou.name= '&&';