1. Tables and Views for SCM
  2. DOS_LINE_SUPP_TRANSFER_INFO_V

DOS_LINE_SUPP_TRANSFER_INFO_V

Details

  • Schema: FUSION

  • Object owner: DOS

  • Object type: VIEW

Columns

Name

LINE_ID

TRACKING_LN_SUPLM_INFRMTN_ID

TRACKING_LINE_ID

OBJECT_VERSION_NUMBER

DETAIL_TYPE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

BATCHNUMBER

PROCESSSTATUS

DETAILTYPE

DISTRIBUTIONNUMBER

DISTRBPRIMARYLEDGERID

DISTRBCHARGEACCOUNTID

DISTRBQUANTITY

DISTRBPERCENT

DISTRBAMOUNT

DISTRBCURRENCYAMOUNT

DISTRBDELIVEREDQUANTITY

DISTRBREQBUID

DISTRBPROJECTID

DISTRBTASKID

DISTRBEXPENDITURETYPEID

DISTRBEXPENDITUREDATE

DISTRBEXPENDITUREORGID

DISTRBPROPCHRGACCNTID

DISTRBPROPOSEDQUANTITY

DISTRBPROPOSEDAMOUNT

DISTRBPROPOSEDPERCENT

DISTRBPROPPROJECTID

DISTRBPROPTASKID

Query

SQL_Statement

select LINE_ID,TRACKING_LN_SUPLM_INFRMTN_ID,TRACKING_LINE_ID,OBJECT_VERSION_NUMBER,DETAIL_TYPE,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/BatchNumber')BatchNumber,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/ProcessStatus')ProcessStatus,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DetailType')DetailType,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistributionNumber')DistributionNumber,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbPrimaryLedgerId')DistrbPrimaryLedgerId,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbChargeAccountId')DistrbChargeAccountId,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbQuantity')DistrbQuantity,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbPercent')DistrbPercent,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbAmount')DistrbAmount,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbCurrencyAmount')DistrbCurrencyAmount,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbDeliveredQuantity')DistrbDeliveredQuantity,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbReqBuId')DistrbReqBuId,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbProjectId')DistrbProjectId,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbTaskId')DistrbTaskId,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbExpenditureTypeId')DistrbExpenditureTypeId,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbExpenditureDate')DistrbExpenditureDate,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbExpenditureOrgId')DistrbExpenditureOrgId,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbPropChrgAccntId')DistrbPropChrgAccntId,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbProposedQuantity')DistrbProposedQuantity,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbProposedAmount')DistrbProposedAmount,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbProposedPercent')DistrbProposedPercent,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbPropProjectId')DistrbPropProjectId,

extractvalue(CONTENT,'/DosProcessSupplyTransferOrdersTransferDetailsTRVORow/DistrbPropTaskId')DistrbPropTaskId

from DOS_LINE_SUPPLEMENTAL_INFO where DETAIL_TYPE ='TRANSFER'