Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: PO.PO_REQ_DIST_INTERFACE_ALL#

Object Details
Object Name: PO_REQ_DIST_INTERFACE_ALL#
Object Type: VIEW
Owner: PO
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACCRUAL_ACCOUNT_ID NUMBER

ALLOCATION_TYPE VARCHAR2 (25)
ALLOCATION_VALUE NUMBER

BATCH_ID NUMBER

BUDGET_ACCOUNT_ID NUMBER

CHARGE_ACCOUNT_ID NUMBER

CHARGE_ACCOUNT_SEGMENT1 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT10 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT11 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT12 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT13 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT14 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT15 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT16 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT17 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT18 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT19 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT2 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT20 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT21 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT22 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT23 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT24 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT25 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT26 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT27 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT28 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT29 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT3 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT30 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT4 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT5 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT6 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT7 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT8 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT9 VARCHAR2 (25)
CREATED_BY NUMBER

CREATION_DATE DATE

DESTINATION_ORGANIZATION_ID NUMBER

DESTINATION_SUBINVENTORY VARCHAR2 (10)
DESTINATION_TYPE_CODE VARCHAR2 (25)
DISTRIBUTION_ATTRIBUTE1 VARCHAR2 (150)
DISTRIBUTION_ATTRIBUTE10 VARCHAR2 (150)
DISTRIBUTION_ATTRIBUTE11 VARCHAR2 (150)
DISTRIBUTION_ATTRIBUTE12 VARCHAR2 (150)
DISTRIBUTION_ATTRIBUTE13 VARCHAR2 (150)
DISTRIBUTION_ATTRIBUTE14 VARCHAR2 (150)
DISTRIBUTION_ATTRIBUTE15 VARCHAR2 (150)
DISTRIBUTION_ATTRIBUTE2 VARCHAR2 (150)
DISTRIBUTION_ATTRIBUTE3 VARCHAR2 (150)
DISTRIBUTION_ATTRIBUTE4 VARCHAR2 (150)
DISTRIBUTION_ATTRIBUTE5 VARCHAR2 (150)
DISTRIBUTION_ATTRIBUTE6 VARCHAR2 (150)
DISTRIBUTION_ATTRIBUTE7 VARCHAR2 (150)
DISTRIBUTION_ATTRIBUTE8 VARCHAR2 (150)
DISTRIBUTION_ATTRIBUTE9 VARCHAR2 (150)
DISTRIBUTION_NUMBER NUMBER

DIST_ATTRIBUTE_CATEGORY VARCHAR2 (30)
DIST_SEQUENCE_ID NUMBER

EXPENDITURE_ITEM_DATE DATE

EXPENDITURE_ORGANIZATION_ID NUMBER

EXPENDITURE_TYPE VARCHAR2 (30)
GL_DATE DATE

GOVERNMENT_CONTEXT VARCHAR2 (30)
GROUP_CODE VARCHAR2 (30)
INTERFACE_SOURCE_CODE VARCHAR2 (25) Yes
INTERFACE_SOURCE_LINE_ID NUMBER

ITEM_ID NUMBER

LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

ORG_ID NUMBER

PREVENT_ENCUMBRANCE_FLAG VARCHAR2 (1)
PROCESS_FLAG VARCHAR2 (30)
PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

PROJECT_ACCOUNTING_CONTEXT VARCHAR2 (30)
PROJECT_ID NUMBER

PROJECT_NUM VARCHAR2 (25)
QUANTITY NUMBER

REQUEST_ID NUMBER

REQUISITION_HEADER_ID NUMBER

REQ_NUMBER_SEGMENT1 VARCHAR2 (20)
REQUISITION_LINE_ID NUMBER

REQ_DISTRIBUTION_ID NUMBER

TASK_ID NUMBER

TASK_NUM VARCHAR2 (250)
TRANSACTION_ID NUMBER

UPDATE_ENABLED_FLAG VARCHAR2 (1)
USSGL_TRANSACTION_CODE VARCHAR2 (30)
VARIANCE_ACCOUNT_ID NUMBER

OKE_CONTRACT_LINE_ID NUMBER

OKE_CONTRACT_LINE_NUM VARCHAR2 (150)
OKE_CONTRACT_DELIVERABLE_ID NUMBER

OKE_CONTRACT_DELIVERABLE_NUM VARCHAR2 (150)
AMOUNT NUMBER

CURRENCY_AMOUNT NUMBER

FUNDED_VALUE NUMBER

PARTIAL_FUNDED_FLAG VARCHAR2 (1)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACCRUAL_ACCOUNT_ID
,      ALLOCATION_TYPE
,      ALLOCATION_VALUE
,      BATCH_ID
,      BUDGET_ACCOUNT_ID
,      CHARGE_ACCOUNT_ID
,      CHARGE_ACCOUNT_SEGMENT1
,      CHARGE_ACCOUNT_SEGMENT10
,      CHARGE_ACCOUNT_SEGMENT11
,      CHARGE_ACCOUNT_SEGMENT12
,      CHARGE_ACCOUNT_SEGMENT13
,      CHARGE_ACCOUNT_SEGMENT14
,      CHARGE_ACCOUNT_SEGMENT15
,      CHARGE_ACCOUNT_SEGMENT16
,      CHARGE_ACCOUNT_SEGMENT17
,      CHARGE_ACCOUNT_SEGMENT18
,      CHARGE_ACCOUNT_SEGMENT19
,      CHARGE_ACCOUNT_SEGMENT2
,      CHARGE_ACCOUNT_SEGMENT20
,      CHARGE_ACCOUNT_SEGMENT21
,      CHARGE_ACCOUNT_SEGMENT22
,      CHARGE_ACCOUNT_SEGMENT23
,      CHARGE_ACCOUNT_SEGMENT24
,      CHARGE_ACCOUNT_SEGMENT25
,      CHARGE_ACCOUNT_SEGMENT26
,      CHARGE_ACCOUNT_SEGMENT27
,      CHARGE_ACCOUNT_SEGMENT28
,      CHARGE_ACCOUNT_SEGMENT29
,      CHARGE_ACCOUNT_SEGMENT3
,      CHARGE_ACCOUNT_SEGMENT30
,      CHARGE_ACCOUNT_SEGMENT4
,      CHARGE_ACCOUNT_SEGMENT5
,      CHARGE_ACCOUNT_SEGMENT6
,      CHARGE_ACCOUNT_SEGMENT7
,      CHARGE_ACCOUNT_SEGMENT8
,      CHARGE_ACCOUNT_SEGMENT9
,      CREATED_BY
,      CREATION_DATE
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_SUBINVENTORY
,      DESTINATION_TYPE_CODE
,      DISTRIBUTION_ATTRIBUTE1
,      DISTRIBUTION_ATTRIBUTE10
,      DISTRIBUTION_ATTRIBUTE11
,      DISTRIBUTION_ATTRIBUTE12
,      DISTRIBUTION_ATTRIBUTE13
,      DISTRIBUTION_ATTRIBUTE14
,      DISTRIBUTION_ATTRIBUTE15
,      DISTRIBUTION_ATTRIBUTE2
,      DISTRIBUTION_ATTRIBUTE3
,      DISTRIBUTION_ATTRIBUTE4
,      DISTRIBUTION_ATTRIBUTE5
,      DISTRIBUTION_ATTRIBUTE6
,      DISTRIBUTION_ATTRIBUTE7
,      DISTRIBUTION_ATTRIBUTE8
,      DISTRIBUTION_ATTRIBUTE9
,      DISTRIBUTION_NUMBER
,      DIST_ATTRIBUTE_CATEGORY
,      DIST_SEQUENCE_ID
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      GL_DATE
,      GOVERNMENT_CONTEXT
,      GROUP_CODE
,      INTERFACE_SOURCE_CODE
,      INTERFACE_SOURCE_LINE_ID
,      ITEM_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      PREVENT_ENCUMBRANCE_FLAG
,      PROCESS_FLAG
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROJECT_ACCOUNTING_CONTEXT
,      PROJECT_ID
,      PROJECT_NUM
,      QUANTITY
,      REQUEST_ID
,      REQUISITION_HEADER_ID
,      REQ_NUMBER_SEGMENT1
,      REQUISITION_LINE_ID
,      REQ_DISTRIBUTION_ID
,      TASK_ID
,      TASK_NUM
,      TRANSACTION_ID
,      UPDATE_ENABLED_FLAG
,      USSGL_TRANSACTION_CODE
,      VARIANCE_ACCOUNT_ID
,      OKE_CONTRACT_LINE_ID
,      OKE_CONTRACT_LINE_NUM
,      OKE_CONTRACT_DELIVERABLE_ID
,      OKE_CONTRACT_DELIVERABLE_NUM
,      AMOUNT
,      CURRENCY_AMOUNT
,      FUNDED_VALUE
,      PARTIAL_FUNDED_FLAG
FROM PO.PO_REQ_DIST_INTERFACE_ALL#;

Dependencies

[top of page]

PO.PO_REQ_DIST_INTERFACE_ALL# references the following:

SchemaPO
TablePO_REQ_DIST_INTERFACE_ALL
PO.PO_REQ_DIST_INTERFACE_ALL# is referenced by following:

SchemaAPPS
SynonymPO_REQ_DIST_INTERFACE
SynonymPO_REQ_DIST_INTERFACE_ALL