VIEW: APPS.JAI_PROJECT_INV_AEL_V

Source

View Text - Preformatted

SELECT 7000 application_id, decode(gjs.je_source_name, 'Projects India', 'Release Project Draft Invoice - Excise', 'Release Project Draft Invoice - VAT') event_type, 'JAI PB INVOICE' trx_class, 'JAI PB INVOICE' trx_class_name, jpdi.draft_invoice_id trx_hdr_id, 'JAI_PA_DRAFT_INVOICES' 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, jpdi.last_update_date LAST_UPDATE_DATE, jpdi.last_updated_by LAST_UPDATED_BY, jpdi.creation_date CREATION_DATE, jpdi.created_by CREATED_BY, jpdi.last_update_login LAST_UPDATE_LOGIN, jpdi.draft_invoice_num invoice_number, pc.customer_name party_name, pc.customer_number party_number, jpdi.excise_invoice_no excise_invoice_no, jpdi.excise_invoice_date excise_invoice_date, jpdi.vat_invoice_no vat_invoice_no, jpdi.vat_invoice_date vat_invoice_date, jpdi.excise_register_type excise_register, p.name project_name, p.segment1 project_number FROM pa_customers_v pc, pa_projects_all p, pa_draft_invoices_all pdi, jai_pa_draft_invoices jpdi, 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 pdi.customer_id = pc.customer_id AND jpdi.project_id = p.project_id AND jpdi.project_id = pdi.project_id AND jpdi.draft_invoice_num = pdi.draft_invoice_num 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 IN ('jai_pa_billing_pkg.process_vat', 'jai_pa_billing_pkg.process_excise') AND gjr.reference_4 = 'JAI_PA_DRAFT_INVOICES' AND gjr.reference_5 = to_char(jpdi.draft_invoice_id) AND ( gjr.reference_6 = 'JAI_RGM_TRX_RECORDS' OR gjr.reference_6 LIKE 'PROJECT_ID%') AND gjr.reference_7 = to_char(jpdi.organization_id) AND gjs.je_source_name IN ('Projects India', 'VAT India') AND gjc.je_category_name = 'Register India'

View Text - HTML Formatted

SELECT 7000 APPLICATION_ID
, DECODE(GJS.JE_SOURCE_NAME
, 'PROJECTS INDIA'
, 'RELEASE PROJECT DRAFT INVOICE - EXCISE'
, 'RELEASE PROJECT DRAFT INVOICE - VAT') EVENT_TYPE
, 'JAI PB INVOICE' TRX_CLASS
, 'JAI PB INVOICE' TRX_CLASS_NAME
, JPDI.DRAFT_INVOICE_ID TRX_HDR_ID
, 'JAI_PA_DRAFT_INVOICES' 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
, JPDI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JPDI.LAST_UPDATED_BY LAST_UPDATED_BY
, JPDI.CREATION_DATE CREATION_DATE
, JPDI.CREATED_BY CREATED_BY
, JPDI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, JPDI.DRAFT_INVOICE_NUM INVOICE_NUMBER
, PC.CUSTOMER_NAME PARTY_NAME
, PC.CUSTOMER_NUMBER PARTY_NUMBER
, JPDI.EXCISE_INVOICE_NO EXCISE_INVOICE_NO
, JPDI.EXCISE_INVOICE_DATE EXCISE_INVOICE_DATE
, JPDI.VAT_INVOICE_NO VAT_INVOICE_NO
, JPDI.VAT_INVOICE_DATE VAT_INVOICE_DATE
, JPDI.EXCISE_REGISTER_TYPE EXCISE_REGISTER
, P.NAME PROJECT_NAME
, P.SEGMENT1 PROJECT_NUMBER
FROM PA_CUSTOMERS_V PC
, PA_PROJECTS_ALL P
, PA_DRAFT_INVOICES_ALL PDI
, JAI_PA_DRAFT_INVOICES JPDI
, 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 PDI.CUSTOMER_ID = PC.CUSTOMER_ID
AND JPDI.PROJECT_ID = P.PROJECT_ID
AND JPDI.PROJECT_ID = PDI.PROJECT_ID
AND JPDI.DRAFT_INVOICE_NUM = PDI.DRAFT_INVOICE_NUM
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 IN ('JAI_PA_BILLING_PKG.PROCESS_VAT'
, 'JAI_PA_BILLING_PKG.PROCESS_EXCISE')
AND GJR.REFERENCE_4 = 'JAI_PA_DRAFT_INVOICES'
AND GJR.REFERENCE_5 = TO_CHAR(JPDI.DRAFT_INVOICE_ID)
AND ( GJR.REFERENCE_6 = 'JAI_RGM_TRX_RECORDS' OR GJR.REFERENCE_6 LIKE 'PROJECT_ID%')
AND GJR.REFERENCE_7 = TO_CHAR(JPDI.ORGANIZATION_ID)
AND GJS.JE_SOURCE_NAME IN ('PROJECTS INDIA'
, 'VAT INDIA')
AND GJC.JE_CATEGORY_NAME = 'REGISTER INDIA'