DOS_SUPPLY_TRANSFER_TAX_DTLS_V
Details
-
Schema: FUSION
-
Object owner: DOS
-
Object type: VIEW
Columns
Name |
---|
LINE_ID OBJECT_VERSION_NUMBER TRACKING_LN_SUPLM_INFRMTN_ID TRACKING_LINE_ID BUY_ASSESSABLE_VALUE BUY_DEFAULT_TAX_COUNTRY BUY_DOCUMENT_SUB_TYPE BUY_FINAL_DISCHARGE_LOC_ID BUY_FIRST_PTY_REG_ID BUY_INTEND_USE_CLASSIF_ID BUY_PRODUCT_CATEGORY BUY_PRODUCT_FISC_CLASSIF BUY_PRODUCT_TYPE BUY_TAX_CLASSIF_CODE BUY_THIRDPTY_REGID BUY_TRX_BUSINESS_CATEGORY BUY_USR_DEFINED_FISC_CLASS SELL_ASSESSABLE_VALUE SELL_DEFAULT_TAX_COUNTRY SELL_DOCUMENT_SUB_TYPE SELL_FINAL_DISCHARGE_LOC_ID SELL_FIRST_PTY_REG_ID SELL_INTEND_USE_CLASSIF_ID SELL_PRODUCT_CATEGORY SELL_PRODUCT_FISC_CLASSIF SELL_PRODUCT_TYPE SELL_TAX_CLASSIF_CODE SELL_THIRDPTY_REGID SELL_TRX_BUSINESS_CATEGORY SELL_USR_DEFINED_FISC_CLASS INCL_NONRECOVERABLE_TAX INCL_RECOVERABLE_TAX NONINCL_NONRECOVERABLE_TAX NONINCL_RECOVERABLE_TAX CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN |
Query
SQL_Statement |
---|
SELECT LINE_ID, OBJECT_VERSION_NUMBER, TRACKING_LN_SUPLM_INFRMTN_ID, TRACKING_LINE_ID, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/BuyAssessableValue') Buy_Assessable_Value, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/BuyDefaultTaxCountry') Buy_Default_Tax_Country, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/BuyDocumentSubType') Buy_Document_Sub_Type, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/BuyFinalDischargeLocId') Buy_Final_Discharge_Loc_Id, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/BuyFirstPtyRegId') Buy_First_Pty_Reg_Id, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/BuyIntendUseClassifId') Buy_Intend_Use_Classif_Id, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/BuyProductCategory') Buy_Product_Category, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/BuyProductFiscClassif') Buy_Product_Fisc_Classif, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/BuyProductType') Buy_Product_Type, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/BuyTaxClassifCode') Buy_Tax_Classif_Code, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/BuyThirdPtyRegId') Buy_ThirdPty_RegId, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/BuyTrxBusinessCategory') Buy_Trx_Business_Category, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/BuyUsrDefinedFiscClass') Buy_Usr_Defined_Fisc_Class, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/SellAssessableValue') Sell_Assessable_Value, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/SellDefaultTaxCountry') Sell_Default_Tax_Country, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/SellDocumentSubType') Sell_Document_Sub_Type, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/SellFinalDischargeLocId') Sell_Final_Discharge_Loc_Id, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/SellFirstPtyRegId') Sell_First_Pty_Reg_Id, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/SellIntendUseClassifId') Sell_Intend_Use_Classif_Id, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/SellProductCategory') Sell_Product_Category, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/SellProductFiscClassif') Sell_Product_Fisc_Classif, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/SellProductType') Sell_Product_Type, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/SellTaxClassifCode') Sell_Tax_Classif_Code, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/SellThirdPtyRegId') Sell_ThirdPty_RegId, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/SellTrxBusinessCategory') Sell_Trx_Business_Category, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/SellUsrDefinedFiscClass') Sell_Usr_Defined_Fisc_Class, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/InclNonrecoverableTax') Incl_Nonrecoverable_Tax, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/InclRecoverableTax') Incl_Recoverable_Tax, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/NoninclNonrecoverableTax') Nonincl_Nonrecoverable_Tax, extractValue(CONTENT, '/DosLineSupplTransferTaxDtlVORow/NoninclRecoverableTax') Nonincl_Recoverable_Tax, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM DOS_LINE_SUPPLEMENTAL_INFO WHERE DETAIL_TYPE='TRANSFERTAXDTL' |