1. Tables and Views for SCM
  2. DOS_LINE_SUPP_DISTRB_DTLS_V

DOS_LINE_SUPP_DISTRB_DTLS_V

Details

  • Schema: FUSION

  • Object owner: DOS

  • Object type: VIEW

Columns

Name

LINE_ID

TRACKING_LN_SUPLM_INFRMTN_ID

TRACKING_LINE_ID

DETAIL_TYPE

DISTRB_PRIMARY_LEDGER_ID

DISTRB_CHARGE_ACCOUNT_ID

DISTRIBUTION_QUANTITY

DISTRIBUTION_NUMBER

DISTRB_PERCENT

DISTRB_REQUESTING_BU_ID

DISTRB_AMOUNT

DISTRB_CURRENCY_AMOUNT

DISTRB_PROJECT_ID

DISTRB_TASK_ID

DISTRB_EXPENDITURE_TYPE_ID

DISTRB_EXPENDITURE_DATE

DISTRB_EXPENDITURE_ORG_ID

DISTRIBUTION_ID

DISTRB_REQUISITION_LINE_ID

DISTRB_RECOVERABLE_TAX

DISTRB_NONRECOVERABLE_TAX

DISTRB_RECOVERABLE_CRNCY_TAX

DISTRB_NONRCVRBL_CRNCY_TAX

DISTRB_FUNDS_STATUS

DISTRB_BUDGET_DATE

DISTRB_BILLABLE_FLAG

DISTRB_PJC_CAPITALIZABLE_FLAG

DISTRB_PJC_WORK_TYPE_ID

DISTRB_PJC_CONTRACT_ID

DISTRB_PJC_CONTRACT_LINE_ID

DISTRB_PJC_FNDING_ALLCTN_ID

DISTRB_PJC_CONTEXT_CATEGORY

DISTRB_PJC_RSRVD_ATTRIBUTE1

DISTRB_PJC_RSRVD_ATTRIBUTE2

DISTRB_PJC_RSRVD_ATTRIBUTE3

DISTRB_PJC_RSRVD_ATTRIBUTE4

DISTRB_PJC_RSRVD_ATTRIBUTE5

DISTRB_PJC_RSRVD_ATTRIBUTE6

DISTRB_PJC_RSRVD_ATTRIBUTE7

DISTRB_PJC_RSRVD_ATTRIBUTE8

DISTRB_PJC_RSRVD_ATTRIBUTE9

DISTRB_PJC_RSRVD_ATTRIBUTE10

DISTRB_PJC_USR_DEF_ATTRIBUTE1

DISTRB_PJC_USR_DEF_ATTRIBUTE2

DISTRB_PJC_USR_DEF_ATTRIBUTE3

DISTRB_PJC_USR_DEF_ATTRIBUTE4

DISTRB_PJC_USR_DEF_ATTRIBUTE5

DISTRB_PJC_USR_DEF_ATTRIBUTE6

DISTRB_PJC_USR_DEF_ATTRIBUTE7

DISTRB_PJC_USR_DEF_ATTRIBUTE8

DISTRB_PJC_USR_DEF_ATTRIBUTE9

DISTRB_PJC_USR_DEF_ATTRIBUTE10

PJC_PROJECT_NUMBER

PJC_TASK_NUMBER

BUY_ATTRIBUTE_CATEGORY

BUY_ATTRIBUTE_CHAR1

BUY_ATTRIBUTE_CHAR2

BUY_ATTRIBUTE_CHAR3

BUY_ATTRIBUTE_CHAR4

BUY_ATTRIBUTE_CHAR5

BUY_ATTRIBUTE_CHAR6

BUY_ATTRIBUTE_CHAR7

BUY_ATTRIBUTE_CHAR8

BUY_ATTRIBUTE_CHAR9

BUY_ATTRIBUTE_CHAR10

BUY_ATTRIBUTE_CHAR11

BUY_ATTRIBUTE_CHAR12

BUY_ATTRIBUTE_CHAR13

BUY_ATTRIBUTE_CHAR14

BUY_ATTRIBUTE_CHAR15

BUY_ATTRIBUTE_CHAR16

BUY_ATTRIBUTE_CHAR17

BUY_ATTRIBUTE_CHAR18

BUY_ATTRIBUTE_CHAR19

BUY_ATTRIBUTE_CHAR20

BUY_ATTRIBUTE_NUMBER1

BUY_ATTRIBUTE_NUMBER2

BUY_ATTRIBUTE_NUMBER3

BUY_ATTRIBUTE_NUMBER4

BUY_ATTRIBUTE_NUMBER5

BUY_ATTRIBUTE_NUMBER6

BUY_ATTRIBUTE_NUMBER7

BUY_ATTRIBUTE_NUMBER8

BUY_ATTRIBUTE_NUMBER9

BUY_ATTRIBUTE_NUMBER10

BUY_ATTRIBUTE_DATE1

BUY_ATTRIBUTE_DATE2

BUY_ATTRIBUTE_DATE3

BUY_ATTRIBUTE_DATE4

BUY_ATTRIBUTE_DATE5

BUY_ATTRIBUTE_DATE6

BUY_ATTRIBUTE_DATE7

BUY_ATTRIBUTE_DATE8

BUY_ATTRIBUTE_DATE9

BUY_ATTRIBUTE_DATE10

BUY_ATTRIBUTE_TIMESTAMP1

BUY_ATTRIBUTE_TIMESTAMP2

BUY_ATTRIBUTE_TIMESTAMP3

BUY_ATTRIBUTE_TIMESTAMP4

BUY_ATTRIBUTE_TIMESTAMP5

BUY_ATTRIBUTE_TIMESTAMP6

BUY_ATTRIBUTE_TIMESTAMP7

BUY_ATTRIBUTE_TIMESTAMP8

BUY_ATTRIBUTE_TIMESTAMP9

BUY_ATTRIBUTE_TIMESTAMP10

PJC_FROM_PROJECT_ID

PJC_FROM_TASK_ID

Query

SQL_Statement

select LINE_ID,TRACKING_LN_SUPLM_INFRMTN_ID,TRACKING_LINE_ID,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DetailType')) DETAIL_TYPE,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPrimaryLedgerId'))DISTRB_PRIMARY_LEDGER_ID,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbChargeAccountId'))DISTRB_CHARGE_ACCOUNT_ID,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbQuantity')) DISTRIBUTION_QUANTITY,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistributionNumber')) DISTRIBUTION_NUMBER,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPercent'))DISTRB_PERCENT,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbRequestingBUId'))DISTRB_REQUESTING_BU_ID,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbAmount'))DISTRB_AMOUNT,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbCurrencyAmount')) DISTRB_CURRENCY_AMOUNT,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbProjectId')) DISTRB_PROJECT_ID,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbTaskId'))DISTRB_TASK_ID,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbExpenditureTypeId'))DISTRB_EXPENDITURE_TYPE_ID,

to_timestamp(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbExpenditureDate'),'YYYY-MM-DD HH24:MI:SS.FF "UTC"') DISTRB_EXPENDITURE_DATE,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbExpenditureOrgId')) DISTRB_EXPENDITURE_ORG_ID,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistributionId')) DISTRIBUTION_ID,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbRequisitionLineId'))DISTRB_REQUISITION_LINE_ID,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbRecoverableTax'))DISTRB_RECOVERABLE_TAX,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbNonrecoverableTax'))DISTRB_NONRECOVERABLE_TAX,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbRecoverableCurrencyTax')) DISTRB_RECOVERABLE_CRNCY_TAX,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbNonrecoverableCurrencyTax')) DISTRB_NONRCVRBL_CRNCY_TAX,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbFundStatus'))DISTRB_FUNDS_STATUS,

to_timestamp(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbBudgetDate'), 'YYYY-MM-DD HH24:MI:SS.FF "UTC"') DISTRB_BUDGET_DATE,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbBillableFlag'))DISTRB_BILLABLE_FLAG,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcCaptializableFlag')) DISTRB_PJC_CAPITALIZABLE_FLAG,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcWorkTypeId')) DISTRB_PJC_WORK_TYPE_ID,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcContractId'))DISTRB_PJC_CONTRACT_ID,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcContractLineId'))DISTRB_PJC_CONTRACT_LINE_ID,

to_number(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcFndingAllctnId'))DISTRB_PJC_FNDING_ALLCTN_ID,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcContextCategory'))DISTRB_PJC_CONTEXT_CATEGORY,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcRsrvdAttribute1'))DISTRB_PJC_RSRVD_ATTRIBUTE1,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcRsrvdAttribute2'))DISTRB_PJC_RSRVD_ATTRIBUTE2,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcRsrvdAttribute3'))DISTRB_PJC_RSRVD_ATTRIBUTE3,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcRsrvdAttribute4'))DISTRB_PJC_RSRVD_ATTRIBUTE4,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcRsrvdAttribute5'))DISTRB_PJC_RSRVD_ATTRIBUTE5,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcRsrvdAttribute6'))DISTRB_PJC_RSRVD_ATTRIBUTE6,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcRsrvdAttribute7'))DISTRB_PJC_RSRVD_ATTRIBUTE7,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcRsrvdAttribute8'))DISTRB_PJC_RSRVD_ATTRIBUTE8,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcRsrvdAttribute9'))DISTRB_PJC_RSRVD_ATTRIBUTE9,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcRsrvdAttribute10'))DISTRB_PJC_RSRVD_ATTRIBUTE10,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcUsrDefAttribute1'))DISTRB_PJC_USR_DEF_ATTRIBUTE1,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcUsrDefAttribute2'))DISTRB_PJC_USR_DEF_ATTRIBUTE2,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcUsrDefAttribute3'))DISTRB_PJC_USR_DEF_ATTRIBUTE3,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcUsrDefAttribute4'))DISTRB_PJC_USR_DEF_ATTRIBUTE4,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcUsrDefAttribute5'))DISTRB_PJC_USR_DEF_ATTRIBUTE5,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcUsrDefAttribute6'))DISTRB_PJC_USR_DEF_ATTRIBUTE6,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcUsrDefAttribute7'))DISTRB_PJC_USR_DEF_ATTRIBUTE7,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcUsrDefAttribute8'))DISTRB_PJC_USR_DEF_ATTRIBUTE8,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcUsrDefAttribute9'))DISTRB_PJC_USR_DEF_ATTRIBUTE9,

to_char(extractvalue(CONTENT,'/DosLineSupplDistrbDtlVORow/DistrbPjcUsrDefAttribute10'))DISTRB_PJC_USR_DEF_ATTRIBUTE10,null PJC_PROJECT_NUMBER,null PJC_TASK_NUMBER,

null BUY_ATTRIBUTE_CATEGORY,null BUY_ATTRIBUTE_CHAR1,null BUY_ATTRIBUTE_CHAR2 ,null BUY_ATTRIBUTE_CHAR3,null BUY_ATTRIBUTE_CHAR4 ,null BUY_ATTRIBUTE_CHAR5,null BUY_ATTRIBUTE_CHAR6,

null BUY_ATTRIBUTE_CHAR7,null BUY_ATTRIBUTE_CHAR8,null BUY_ATTRIBUTE_CHAR9,

null BUY_ATTRIBUTE_CHAR10 ,null BUY_ATTRIBUTE_CHAR11,null BUY_ATTRIBUTE_CHAR12,null BUY_ATTRIBUTE_CHAR13,null BUY_ATTRIBUTE_CHAR14,

null BUY_ATTRIBUTE_CHAR15,null BUY_ATTRIBUTE_CHAR16, null BUY_ATTRIBUTE_CHAR17,null BUY_ATTRIBUTE_CHAR18, null BUY_ATTRIBUTE_CHAR19,null BUY_ATTRIBUTE_CHAR20, null BUY_ATTRIBUTE_NUMBER1,

null BUY_ATTRIBUTE_NUMBER2,null BUY_ATTRIBUTE_NUMBER3,null BUY_ATTRIBUTE_NUMBER4,null BUY_ATTRIBUTE_NUMBER5, null BUY_ATTRIBUTE_NUMBER6, null BUY_ATTRIBUTE_NUMBER7, null BUY_ATTRIBUTE_NUMBER8,

null BUY_ATTRIBUTE_NUMBER9,

null BUY_ATTRIBUTE_NUMBER10, null BUY_ATTRIBUTE_DATE1,null BUY_ATTRIBUTE_DATE2,null BUY_ATTRIBUTE_DATE3, null BUY_ATTRIBUTE_DATE4, null BUY_ATTRIBUTE_DATE5,null BUY_ATTRIBUTE_DATE6,null BUY_ATTRIBUTE_DATE7,

null BUY_ATTRIBUTE_DATE8,

null BUY_ATTRIBUTE_DATE9,null BUY_ATTRIBUTE_DATE10,null BUY_ATTRIBUTE_TIMESTAMP1,null BUY_ATTRIBUTE_TIMESTAMP2,null BUY_ATTRIBUTE_TIMESTAMP3, null BUY_ATTRIBUTE_TIMESTAMP4,null BUY_ATTRIBUTE_TIMESTAMP5,

null BUY_ATTRIBUTE_TIMESTAMP6 ,

null BUY_ATTRIBUTE_TIMESTAMP7,null BUY_ATTRIBUTE_TIMESTAMP8, null BUY_ATTRIBUTE_TIMESTAMP9, null BUY_ATTRIBUTE_TIMESTAMP10,null PJC_FROM_PROJECT_ID , null PJC_FROM_TASK_ID

from DOS_LINE_SUPPLEMENTAL_INFO where 1 = 2 and DETAIL_TYPE ='DISTRIBUTION'

UNION

select LINE_ID,DISTRIBUTION_DETAILS_ID,TRACKING_LINE_ID, DETAIL_TYPE,DISTRB_PRIMARY_LEDGER_ID,DISTRB_CHARGE_ACCOUNT_ID,

DISTRB_QUANTITY,DISTRIBUTION_NUMBER,DISTRB_PERCENT,DISTRB_REQUESTING_BU_ID,DISTRB_AMOUNT,DISTRB_CURRENCY_AMOUNT,

PJC_PROJECT_ID,PJC_TASK_ID,PJC_EXPENDITURE_TYPE_ID,PJC_EXPENDITURE_ITEM_DATE,PJC_ORGANIZATION_ID,

DISTRIBUTION_ID,DISTRB_REQUISITION_LINE_ID,DISTRB_RECOVERABLE_TAX,DISTRB_NONRECOVERABLE_TAX,DISTRB_RECOVERABLE_CRNCY_TAX,

DISTRB_NONRCVRBL_CRNCY_TAX,DISTRB_FUNDS_STATUS,DISTRB_BUDGET_DATE,PJC_BILLABLE_FLAG,PJC_CAPITALIZABLE_FLAG,PJC_WORK_TYPE_ID,

PJC_CONTRACT_ID,PJC_CONTRACT_LINE_ID,PJC_FUNDING_ALLOCATION_ID,PJC_CONTEXT_CATEGORY,

PJC_RESERVED_ATTRIBUTE1,PJC_RESERVED_ATTRIBUTE2,PJC_RESERVED_ATTRIBUTE3,PJC_RESERVED_ATTRIBUTE4,PJC_RESERVED_ATTRIBUTE5,PJC_RESERVED_ATTRIBUTE6,

PJC_RESERVED_ATTRIBUTE7,PJC_RESERVED_ATTRIBUTE8,PJC_RESERVED_ATTRIBUTE9,PJC_RESERVED_ATTRIBUTE10,

PJC_USER_DEF_ATTRIBUTE1,PJC_USER_DEF_ATTRIBUTE2,PJC_USER_DEF_ATTRIBUTE3,PJC_USER_DEF_ATTRIBUTE4,PJC_USER_DEF_ATTRIBUTE5,PJC_USER_DEF_ATTRIBUTE6,

PJC_USER_DEF_ATTRIBUTE7,PJC_USER_DEF_ATTRIBUTE8,PJC_USER_DEF_ATTRIBUTE9,PJC_USER_DEF_ATTRIBUTE10,PJC_PROJECT_NUMBER,PJC_TASK_NUMBER,BUY_ATTRIBUTE_CATEGORY,BUY_ATTRIBUTE_CHAR1, BUY_ATTRIBUTE_CHAR2 ,BUY_ATTRIBUTE_CHAR3,BUY_ATTRIBUTE_CHAR4 ,BUY_ATTRIBUTE_CHAR5,BUY_ATTRIBUTE_CHAR6,BUY_ATTRIBUTE_CHAR7,BUY_ATTRIBUTE_CHAR8,BUY_ATTRIBUTE_CHAR9,

BUY_ATTRIBUTE_CHAR10 ,BUY_ATTRIBUTE_CHAR11, BUY_ATTRIBUTE_CHAR12,BUY_ATTRIBUTE_CHAR13,BUY_ATTRIBUTE_CHAR14,

BUY_ATTRIBUTE_CHAR15, BUY_ATTRIBUTE_CHAR16, BUY_ATTRIBUTE_CHAR17,BUY_ATTRIBUTE_CHAR18, BUY_ATTRIBUTE_CHAR19, BUY_ATTRIBUTE_CHAR20,BUY_ATTRIBUTE_NUMBER1,

BUY_ATTRIBUTE_NUMBER2, BUY_ATTRIBUTE_NUMBER3,BUY_ATTRIBUTE_NUMBER4,BUY_ATTRIBUTE_NUMBER5,BUY_ATTRIBUTE_NUMBER6, BUY_ATTRIBUTE_NUMBER7, BUY_ATTRIBUTE_NUMBER8,BUY_ATTRIBUTE_NUMBER9,

BUY_ATTRIBUTE_NUMBER10, BUY_ATTRIBUTE_DATE1, BUY_ATTRIBUTE_DATE2,BUY_ATTRIBUTE_DATE3, BUY_ATTRIBUTE_DATE4, BUY_ATTRIBUTE_DATE5, BUY_ATTRIBUTE_DATE6, BUY_ATTRIBUTE_DATE7, BUY_ATTRIBUTE_DATE8,

BUY_ATTRIBUTE_DATE9, BUY_ATTRIBUTE_DATE10, BUY_ATTRIBUTE_TIMESTAMP1, BUY_ATTRIBUTE_TIMESTAMP2, BUY_ATTRIBUTE_TIMESTAMP3, BUY_ATTRIBUTE_TIMESTAMP4, BUY_ATTRIBUTE_TIMESTAMP5, BUY_ATTRIBUTE_TIMESTAMP6 , BUY_ATTRIBUTE_TIMESTAMP7, BUY_ATTRIBUTE_TIMESTAMP8, BUY_ATTRIBUTE_TIMESTAMP9, BUY_ATTRIBUTE_TIMESTAMP10 , PJC_FROM_PROJECT_ID , PJC_FROM_TASK_ID

FROM DOS_DISTRIBUTION_DETAILS