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 |