1. Tables and Views for Procurement
  2. POR_PJC_DISTR_DFF_V

POR_PJC_DISTR_DFF_V

Details

  • Schema: FUSION

  • Object owner: POR

  • Object type: VIEW

Columns

Name

SOURCE_HEADER_ID_1

SOURCE_HEADER_ID_2

SOURCE_LINE_ID_1

SOURCE_LINE_ID_2

SOURCE_LINE_ID_3

SOURCE_LINE_ID_4

SOURCE_LINE_ID_5

SOURCE_LINE_ID_6

PJC_BILLABLE_FLAG

PJC_CAPITALIZABLE_FLAG

PJC_CONTEXT_CATEGORY

PJC_CONTRACT_ID

PJC_CONTRACT_LINE_ID

PJC_EXPENDITURE_ITEM_DATE

PJC_EXPENDITURE_TYPE_ID

PJC_FUNDING_ALLOCATION_ID

PJC_ORGANIZATION_ID

PJC_PROJECT_ID

PJC_TASK_ID

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_WORK_TYPE_ID

FUNDS_STATUS

LIQUIDATION_BASE_AMOUNT

LIQUIDATION_AMOUNT

Query

SQL_Statement

SELECT

PRH.REQUISITION_HEADER_ID SOURCE_HEADER_ID_1,

' ' SOURCE_HEADER_ID_2,

PRD.REQUISITION_LINE_ID SOURCE_LINE_ID_1,

PRD.DISTRIBUTION_ID SOURCE_LINE_ID_2,

' ' SOURCE_LINE_ID_3,

' ' SOURCE_LINE_ID_4,

' ' SOURCE_LINE_ID_5,

' ' SOURCE_LINE_ID_6,

NVL(PRD.PJC_BILLABLE_FLAG,'N') AS PJC_BILLABLE_FLAG,

NVL(PRD.PJC_CAPITALIZABLE_FLAG, 'N') AS PJC_CAPITALIZABLE_FLAG,

PRD.PJC_CONTEXT_CATEGORY,

PRD.PJC_CONTRACT_ID,

PRD.PJC_CONTRACT_LINE_ID,

PRD.PJC_EXPENDITURE_ITEM_DATE,

PRD.PJC_EXPENDITURE_TYPE_ID,

PRD.PJC_FUNDING_ALLOCATION_ID,

PRD.PJC_ORGANIZATION_ID,

PRD.PJC_PROJECT_ID,

PRD.PJC_TASK_ID,

PRD.PJC_RESERVED_ATTRIBUTE1,

PRD.PJC_RESERVED_ATTRIBUTE2,

PRD.PJC_RESERVED_ATTRIBUTE3,

PRD.PJC_RESERVED_ATTRIBUTE4,

PRD.PJC_RESERVED_ATTRIBUTE5,

PRD.PJC_RESERVED_ATTRIBUTE6,

PRD.PJC_RESERVED_ATTRIBUTE7,

PRD.PJC_RESERVED_ATTRIBUTE8,

PRD.PJC_RESERVED_ATTRIBUTE9,

PRD.PJC_RESERVED_ATTRIBUTE10,

PRD.PJC_USER_DEF_ATTRIBUTE1,

PRD.PJC_USER_DEF_ATTRIBUTE2,

PRD.PJC_USER_DEF_ATTRIBUTE3,

PRD.PJC_USER_DEF_ATTRIBUTE4,

PRD.PJC_USER_DEF_ATTRIBUTE5,

PRD.PJC_USER_DEF_ATTRIBUTE6,

PRD.PJC_USER_DEF_ATTRIBUTE7,

PRD.PJC_USER_DEF_ATTRIBUTE8,

PRD.PJC_USER_DEF_ATTRIBUTE9,

PRD.PJC_USER_DEF_ATTRIBUTE10,

PRD.PJC_WORK_TYPE_ID,

PRD.FUNDS_STATUS,

TO_NUMBER(NULL) LIQUIDATION_BASE_AMOUNT,

TO_NUMBER(NULL) LIQUIDATION_AMOUNT

FROM

POR_REQ_DISTRIBUTIONS_ALL PRD,

POR_REQUISITION_LINES_ALL PRL,

POR_REQUISITION_HEADERS_ALL PRH

WHERE

PRD.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID

AND PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID