1. Tables and Views for SCM
  2. DOS_SUPPLY_TRANSFER_TAX_DTLS_V

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'