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

TABLE: PO.PO_REQ_DIST_INTERFACE_ALL

Object Details
Object Name: PO_REQ_DIST_INTERFACE_ALL
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_REQ_DIST_INTERFACE_ALL
Subobject Name:
Status: VALID


PO_REQ_DIST_INTERFACE_ALL is the interface table that creates multiple
distributions using Requisition Import.
Scope: public
Product: PO
Display Name: PO Requisition Distribution Interface
Category: BUSINESS_ENTITY PO_PURCHASE_REQUISITION
Category: BUSINESS_ENTITY PO_INTERNAL_REQUISITION


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ACCRUAL_ACCOUNT_ID NUMBER

Unique identifier for the General Ledger accrual account
ALLOCATION_TYPE VARCHAR2 (25)
Specifies the method of allocation across distributions. Can be PERCENT.
ALLOCATION_VALUE NUMBER

Allocation split value
BATCH_ID NUMBER

Import batch identifier
BUDGET_ACCOUNT_ID NUMBER

Unique identifier for the General Ledger budget account
CHARGE_ACCOUNT_ID NUMBER

Unique identifier for the General Ledger charge account
CHARGE_ACCOUNT_SEGMENT1 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT10 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT11 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT12 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT13 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT14 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT15 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT16 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT17 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT18 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT19 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT2 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT20 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT21 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT22 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT23 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT24 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT25 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT26 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT27 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT28 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT29 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT3 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT30 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT4 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT5 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT6 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT7 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT8 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT9 VARCHAR2 (25)
Key flexfield segment
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
DESTINATION_ORGANIZATION_ID NUMBER

Destination organization unique identifier
DESTINATION_SUBINVENTORY VARCHAR2 (10)
Destination subinventory
DESTINATION_TYPE_CODE VARCHAR2 (25)
Requisition destination type
DISTRIBUTION_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_NUMBER NUMBER

Distribution number
DIST_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
DIST_SEQUENCE_ID NUMBER

Distribution Sequence unique identifier
EXPENDITURE_ITEM_DATE DATE

Project accounting Expenditure Item date
EXPENDITURE_ORGANIZATION_ID NUMBER

Project accounting expenditure organization unique identifier
EXPENDITURE_TYPE VARCHAR2 (30)
Project accounting expenditure type
GL_DATE DATE

Date the distribution should be encumbered
GOVERNMENT_CONTEXT VARCHAR2 (30)
USSGL descriptive flexfield context column
GROUP_CODE VARCHAR2 (30)
Import grouping code
INTERFACE_SOURCE_CODE VARCHAR2 (25) Yes Interface transaction source
INTERFACE_SOURCE_LINE_ID NUMBER

Interface transaction reference column
ITEM_ID NUMBER

Item unique identifier
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ORG_ID NUMBER

Organization identifier
PREVENT_ENCUMBRANCE_FLAG VARCHAR2 (1)
Indicates whether distribution should be encumbered
PROCESS_FLAG VARCHAR2 (30)
Transaction processing state
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
PROJECT_ACCOUNTING_CONTEXT VARCHAR2 (30)
Project accounting descriptive flexfield context column
PROJECT_ID NUMBER

Project accounting unique identifier for the project
PROJECT_NUM VARCHAR2 (25)
Project accounting project number
QUANTITY NUMBER

Quantity ordered
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
REQUISITION_HEADER_ID NUMBER

Requisition header unique identifier
REQ_NUMBER_SEGMENT1 VARCHAR2 (20)
Requisition number
REQUISITION_LINE_ID NUMBER

Requisition line unique identifier
REQ_DISTRIBUTION_ID NUMBER

Requisition distribution unique identifier
TASK_ID NUMBER

Project accounting task unique identifier
TRANSACTION_ID NUMBER

Project accounting transaction unique identifier
UPDATE_ENABLED_FLAG VARCHAR2 (1)
Unused since release 7.0
USSGL_TRANSACTION_CODE VARCHAR2 (30)
United States standard general ledger transaction code
VARIANCE_ACCOUNT_ID NUMBER

GL variance account unique identifier
OKE_CONTRACT_LINE_ID NUMBER

Unique identifier for the project contracts line
OKE_CONTRACT_LINE_NUM VARCHAR2 (150)
Project contracts line number
OKE_CONTRACT_DELIVERABLE_ID NUMBER

Unique identifier for the project contracts deleverable
OKE_CONTRACT_DELIVERABLE_NUM VARCHAR2 (150)
Prject contracts deliverable number
AMOUNT NUMBER

Amount for fixed price service requisition lines
CURRENCY_AMOUNT NUMBER

Amount for fixed price service requisition lines in foreign currency
FUNDED_VALUE NUMBER

Stores the funded vlue on the distribution.
PARTIAL_FUNDED_FLAG VARCHAR2 (1)
Flag to indicate partial funding.
TASK_NUM#1 VARCHAR2 (250)
Project accounting task number
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
,      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
,      TASK_NUM#1
FROM PO.PO_REQ_DIST_INTERFACE_ALL;

Dependencies

[top of page]

PO.PO_REQ_DIST_INTERFACE_ALL does not reference any database object

PO.PO_REQ_DIST_INTERFACE_ALL is referenced by following:

SchemaPO
ViewPO_REQ_DIST_INTERFACE_ALL#