DOS_LINE_SUPP_TRANSFER_COST_V

Details

• Schema: FUSION

• Object owner: DOS

• Object type: VIEW

Columns

Name
LINE_ID TRACKING_LN_SUPLM_INFRMTN_ID TRACKING_LINE_ID DETAIL_TYPE TRANSFER_COST_TYPE_NAME TRANSFER_COST_AMOUNT TRANSFER_COST_CURRENCY_CODE TRANSFER_COST_OPERATION

Query

SQL_Statement

select LINE_ID,TRACKING_LN_SUPLM_INFRMTN_ID,TRACKING_LINE_ID, extractvalue(CONTENT,'/DosLineSupplTransferCostDtlVORow/DetailType')DETAIL_TYPE, extractvalue(CONTENT,'/DosLineSupplTransferCostDtlVORow/TransferCostType')TRANSFER_COST_TYPE_NAME, extractvalue(CONTENT,'/DosLineSupplTransferCostDtlVORow/TransferCostAmount')TRANSFER_COST_AMOUNT, extractvalue(CONTENT,'/DosLineSupplTransferCostDtlVORow/TransferCostCurrencyCode') TRANSFER_COST_CURRENCY_CODE, extractvalue(CONTENT,'/DosLineSupplTransferCostDtlVORow/TransferCostOperation') TRANSFER_COST_OPERATION from DOS_LINE_SUPPLEMENTAL_INFO where DETAIL_TYPE ='TRANSFERCOST'