View: JAI_AP_STDIST_AEL_V

Product:	JA - Asia/Pacific Localizations
Description:	Base view of service tax distribution UI
Implementation/DBA Data:	APPS.JAI_AP_STDIST_AEL_V

View Text

SELECT 7000 APPLICATION_ID
, 'SERVICE TAX DISTRIBUTION' EVENT_TYPE
, 'JAI AP STDIST' TRX_CLASS
, 'JAI AP STAX DISTRIBUTION' TRX_CLASS_NAME
, JRDSH.TRANSFER_ID TRX_HDR_ID
, 'JAI_RGM_TRX_RECORDS' TRX_HDR_TABLE
, GJH.LEDGER_ID SET_OF_BOOKS_ID
, GJH.JE_CATEGORY JE_CATEGORY
, GJC.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, GJH.JE_SOURCE JE_SOURCE
, GJS.USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME
, GJL.JE_HEADER_ID JE_HEADER_ID
, GJL.JE_LINE_NUM JE_LINE_NUM
, GJH.CURRENCY_CODE ENTERED_CURRENCY
, GJL.ENTERED_DR ENTERED_DR
, GJL.ENTERED_CR ENTERED_CR
, GJL.ACCOUNTED_DR ACCOUNTED_DR
, GJL.ACCOUNTED_CR ACCOUNTED_CR
, GJH.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, GJH.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, GJH.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, GJL.CODE_COMBINATION_ID ACCOUNT_ID
, GJL.EFFECTIVE_DATE ACCOUNTING_DATE
, JRDSH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JRDSH.LAST_UPDATED_BY LAST_UPDATED_BY
, JRDSH.CREATION_DATE CREATION_DATE
, JRDSH.CREATED_BY CREATED_BY
, JRDSH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, JAI_DRILLDOWN_UTILS_PKG.GET_TRANSFER_NUMBER( JRDSH.TRANSFER_ID
, TO_NUMBER(GJR.REFERENCE_7)
, ABS(NVL(GJL.ENTERED_DR
, 0)-NVL(GJL.ENTERED_CR
, 0))) TO_DIST_NUM
, JAI_DRILLDOWN_UTILS_PKG.GET_DES_ORG_TYPE( JRDSH.TRANSFER_ID
, TO_NUMBER(GJR.REFERENCE_7)
, ABS(NVL(GJL.ENTERED_DR
, 0)-NVL(GJL.ENTERED_CR
, 0))) TO_ORG_TYPE
, JAI_DRILLDOWN_UTILS_PKG.GET_DES_ORG_NAME( JRDSH.TRANSFER_ID
, TO_NUMBER(GJR.REFERENCE_7)
, ABS(NVL(GJL.ENTERED_DR
, 0)-NVL(GJL.ENTERED_CR
, 0))) TO_ORG_NAME
, JAI_DRILLDOWN_UTILS_PKG.GET_DES_LOC_NAME( JRDSH.TRANSFER_ID
, TO_NUMBER(GJR.REFERENCE_7)
, ABS(NVL(GJL.ENTERED_DR
, 0)-NVL(GJL.ENTERED_CR
, 0))) TO_LOCATION
, JRDSH.TRANSFER_NUMBER FROM_DIST_NUM
, JAL1.MEANING FROM_ORG_TYPE
, OOD1.ORGANIZATION_NAME FROM_ORG_NAME
, HR1.DESCRIPTION FROM_LOCATION
, DECODE(JRDSH.TRANSFER_TYPE
, 'S-S'
, 'SERVICE-SERVICE'
, 'E-S'
, 'EXCISE-SERVICE'
, 'S-E'
, 'SERVICE-EXCISE'
, NULL) TRANSFER_TYPE
, JAL2.MEANING SERVICE_TYPE
, TRUNC(JRDSH.TRANSACTION_DATE) DATE_OF_TRANSFER
FROM HR_LOCATIONS HR1
, ORG_ORGANIZATION_DEFINITIONS OOD1
, JA_LOOKUPS JAL1
, JA_LOOKUPS JAL2
, JAI_RGM_DIS_SRC_HDRS JRDSH
, GL_DAILY_CONVERSION_TYPES GLCT
, GL_JE_CATEGORIES GJC
, GL_JE_SOURCES GJS
, GL_IMPORT_REFERENCES GJR
, GL_JE_HEADERS GJH
, GL_JE_LINES GJL
WHERE GJH.JE_CATEGORY = GJC.JE_CATEGORY_NAME
AND GJH.JE_SOURCE = GJS.JE_SOURCE_NAME
AND GJH.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE
AND JAL1.LOOKUP_TYPE = 'JAI_ORGANIZATION_TYPES'
AND JAL1.LOOKUP_CODE(+) = JRDSH.PARTY_TYPE
AND OOD1.ORGANIZATION_ID(+) = JRDSH.PARTY_ID
AND HR1.LOCATION_ID(+) = JRDSH.LOCATION_ID
AND JAL2.LOOKUP_TYPE(+) = 'JAI_SERVICE_TYPE'
AND JAL2.LOOKUP_CODE(+) = JRDSH.SERVICE_TYPE_CODE
AND GJL.JE_HEADER_ID = GJH.JE_HEADER_ID
AND GJR.JE_HEADER_ID = GJL.JE_HEADER_ID
AND GJR.JE_LINE_NUM = GJL.JE_LINE_NUM
AND GJR.JE_BATCH_ID = GJH.JE_BATCH_ID
AND GJR.REFERENCE_2 = 'INDIA LOCALIZATION ENTRY'
AND GJR.REFERENCE_3 = 'DISTRIBUTION'
AND GJR.REFERENCE_4 = 'JAI_RGM_DIS_DES_TAXS'
AND GJR.REFERENCE_5 = TO_CHAR(JRDSH.TRANSFER_ID)
AND GJR.REFERENCE_6 = 'JAI_RGM_TRX_RECORDS'
AND GJS.JE_SOURCE_NAME = 'SERVICE TAX INDIA'
AND GJC.JE_CATEGORY_NAME = 'REGISTER INDIA'

Columns