eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.JAI_AP_STDIST_AEL_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'