ZX Taiwanese Input VAT - draft

Description
Categories: BI Publisher, Financials
Application: E-Business Tax
Source: Taiwanese Input VAT Report (XML) - Not Supported: Reserved For Future Use
Short Name: ZXTWPVAT_XML
DB package: ZX_ZXAPJAJL_XMLP_PKG
SELECT
            CON.REP_CONTEXT_LVL_MNG               C_REP_CONTEXT_LVL_MNG,
            DET.LEDGER_ID        C_Ledger_ID,
            DET.LEDGER_NAME  C_Ledger_Name,
            CON.REP_CONTEXT_ENTITY_NAME C_Rep_Context_Entity_Name,
            DET.CHART_OF_ACCOUNTS_ID                        C_Chart_Of_Accounts_ID,
            DET.FUNCTIONAL_CURRENCY_CODE            C_Functional_Currency_Code,
            DET.CURRENCY_CODE_DESC              C_Func_Currency_Description,
            DET.BANK_ACCOUNT_NUM                C_Bank_Account_Num,
            CON.TAXPAYER_ID                 C_Taxpayer_ID,
            CON.ACTIVITY_CODE    C_Activity_Code,
            CON.REP_CONTEXT_ENTITY_NAME         C_Organization_Unit_Name,
                    CON.REP_CONTEXT_ENTITY_ADDRESS1         C_Rep_Context_Address1,
                CON.REP_CONTEXT_ENTITY_ADDRESS2         C_Rep_Context_Address2,
                CON.REP_CONTEXT_ENTITY_ADDRESS3         C_Rep_Context_Address3,
                DET.TERRITORY_SHORT_NAME            C_Territory_Short_Name,
                CON.REP_CONTEXT_ENTITY_COUNTRY          C_Rep_Context_Country,
                CON.REP_CONTEXT_ENTITY_CITY         C_Rep_Context_City,
                CON.REP_CONTEXT_ENTITY_POSTAL_CODE      C_Rep_Context_Postal_Code,
                CON.LEGAL_CONTACT_PARTY_NAME            C_Taxable_Person,
                    CON.LEGAL_CONTACT_TITLE             C_Designation,
                    CON.LEGAL_CONTACT_PRE_NAME_ADJUNCT              C_Title,
                    DET.BANK_BRANCH_ID              C_Branch_Code,
                DET.EXTRACT_SOURCE_LEDGER           C_Extract_Source_Legder,
                DET.TRX_ID                  C_Invoice_ID,
                DET.TRX_NUMBER                  C_Invoice_Number,
                DET.APPLIED_TO_TRX_NUMBER           C_Original_Number,
                    DET.APPLIED_TO_TRX_NUMBER           C_Applied_to_Trx_number,
                TO_CHAR(DET.TRX_DATE,'YYYY-MM-DD')                  C_Invoice_Date,
                DET.EVENT_CLASS_CODE                C_Invoice_Type,
                    DET.TRX_CURRENCY_CODE               C_Trx_Currency_Code,
                DET.BILLING_TP_NUMBER               C_Supplier_Number,
                DET.BILLING_TRADING_PARTNER_ID          C_Supplier_ID,
                DET.BILLING_TP_NAME             C_Supplier_Name,
                DET.BILLING_TP_SITE_NAME            C_Supplier_Site_Name,
                DET.BILLING_TP_TAXPAYER_ID                      C_Supplier_Taxpayer_ID,
                DET.BILLING_TP_TAX_REG_NUM              C_Supplier_Tax_Reg_Num,
                DET.BILLING_TP_ADDRESS1             C_Supplier_Address1,
                DET.BILLING_TP_ADDRESS2             C_Supplier_Address2,
                DET.BILLING_TP_ADDRESS3             C_Supplier_Address3,
                DET.BILLING_TP_PROVINCE             C_Supplier_Province,
                DET.BILLING_TP_CITY             C_Supplier_City,
                    DET.REGISTRATION_STATUS_CODE            C_Supplier_VAT_Reg_Status_Code,
                substrb(DET.DOCUMENT_SUB_TYPE,10,2)     C_GUI_Type,
                EXT.DOCUMENT_SUB_TYPE_MNG           C_GUI_Type_Description,
                EXT.TAX_STATUS_MNG              C_Government_Tax_Type,
                EXT.TRX_BUSINESS_CATEGORY_MNG           C_Deductible_Type,
                    DET.SUPPLIER_EXCHANGE_RATE          C_Supplier_Exchange_Rate,
                TO_CHAR(DET.TAX_INVOICE_DATE,'YYYY-MM-DD')  C_Custom_Doc_Date,
                DET.TAX_INVOICE_NUMBER              C_Custom_Doc_Number,
                DET.SUPPLIER_TAX_INVOICE_NUMBER         C_Supplier_Tax_Invoice_Number,
                    TO_CHAR(DET.SUPPLIER_TAX_INVOICE_DATE,'YYYY-MM-DD')         C_Supplier_Tax_Invoice_Date,
                EXT.ATTRIBUTE16                 C_CL_Order_by_Doc_Type,
                substrb(DET.DOCUMENT_SUB_TYPE,15)       C_CL_DOCUMENT_SUB_TYPE,
                EXT.DOCUMENT_SUB_TYPE_MNG           C_CL_DOC_TYPE_MEANING,
                DET.PRODUCT_DESCRIPTION             C_Item,
                to_number(det.trx_line_quantity)                                 C_Quantity,
                TO_CHAR(DET.CANCELLED_DATE,'YYYY-MM-DD''/' || SUBSTRB(fnd_date.date_to_canonical(det.trx_date),6,5) C_TW_INVOICE_DATE,
                CON.ORG_INFORMATION2                C_ORG_INFORMATION2,
            EXT.ATTRIBUTE28                C_SG_BANK_ID,
            EXT.ATTRIBUTE29                C_SG_BRANCH_CODE,
            EXT.ATTRIBUTE30                C_SG_ACCOUNT_NUM,
            DET.TRX_LINE_ID         C_TRANSACTION_LINE,
            DET.ADJUSTED_DOC_NUMBER    C_ADJUSTED_DOC_NUMBER,
            ZX_ZXAPJAJL_XMLP_PKG.CF_TAXABLE_ACC_AMTFormula(DET.TRX_ID, DET.TRX_LINE_ID) CF_TAXABLE_ACC_AMT,
            ZX_ZXAPJAJL_XMLP_PKG.CF_TAXABLE_AMTFormula(DET.TRX_ID, DET.TRX_LINE_ID) CF_TAXABLE_AMT,
            ZX_ZXAPJAJL_XMLP_PKG.CF_TOT_AMOUNT_P CF_TOT_AMOUNT,
            ZX_ZXAPJAJL_XMLP_PKG.CF_TOT_FUNC_AMT_P CF_TOT_FUNC_AMT,
            ZX_ZXAPJAJL_XMLP_PKG.CP_TRX_ID_P CP_TRX_ID,
            ZX_ZXAPJAJL_XMLP_PKG.CP_TRX_ID_ACC_P CP_TRX_ID_ACC,
            ZX_ZXAPJAJL_XMLP_PKG.CP_TRX_LINE_ID_P CP_TRX_LINE_ID,
            ZX_ZXAPJAJL_XMLP_PKG.CP_TRX_LINE_ID_ACC_P CP_TRX_LINE_ID_ACC
            FROM    ZX_REP_CONTEXT_T    CON,
                ZX_REP_TRX_DETAIL_T DET,
                ZX_REP_TRX_JX_EXT_T EXT,
                ZX_REP_ACTG_EXT_T       ACT
            WHERE   DET.REQUEST_ID = :P_CONC_REQUEST_ID
            AND         DET.REQUEST_ID = CON.REQUEST_ID
            AND         NVL(DET.REP_CONTEXT_ID,CON.REP_CONTEXT_ID) = CON.REP_CONTEXT_ID
            and  ACT.DETAIL_TAX_LINE_ID(+) = DET.DETAIL_TAX_LINE_ID
            AND         EXT.DETAIL_TAX_LINE_ID(+) = DET.DETAIL_TAX_LINE_ID
            ORDER BY DET.TRX_ID,DET.TRX_LINE_ID
Ask a question
Parameter Name SQL text Validation
P_INCLUDE_AP_INT_TRX_CLASS
 
LOV Oracle
P_INCLUDE_AP_EXP_TRX_CLASS
 
LOV Oracle
P_INCLUDE_AP_MIX_TRX_CLASS
 
LOV Oracle
P_INCLUDE_AP_PREP_TRX_CLASS
 
LOV Oracle
P_INCLUDE_AP_CM_TRX_CLASS
 
LOV Oracle
P_INCLUDE_AP_DM_TRX_CLASS
 
LOV Oracle
P_INCLUDE_AP_STD_TRX_CLASS
 
LOV Oracle
Accounting Status
 
LOV Oracle
P_PRODUCT
 
LOV Oracle
P_REGISTER_TYPE
 
LOV Oracle
Report Name
 
End Invoice Date
 
Date
Start Invoice Date
 
Date
End GL Date
 
Date
Start GL Date
 
Date
End Accounting Period
 
LOV Oracle
Start Accounting Period
 
LOV Oracle
Company Name
 
LOV Oracle
Reporting Context
 
LOV Oracle
Reporting Level
 
LOV Oracle