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

TABLE: PO.PO_DISTRIBUTIONS_INTERFACE

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


PO_DISTRIBUTIONS_INTERFACE is the interface table that holds
distribution information for the PDOI program to create standard
purchase order.
The PDOI program validates your data, derives or defaults additional
information and writes an error message for every validation that
fails into the PO_INTERFACE_ERRORS table.
Scope: public
Product: PO
Display Name: PO Distributions Interface
Category: BUSINESS_ENTITY PO_STANDARD_PURCHASE_ORDER


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_DISTRIBUTIONS_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_DISTRIBUTION_ID
PO_DISTRIBUTIONS_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_HEADER_ID
PO_DISTRIBUTIONS_INTERFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_LINE_ID
PO_DISTRIBUTIONS_INTERFACE_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_LINE_LOCATION_ID
PO_DISTRIBUTIONS_INTERFACE_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPROCESSING_ID
Columns
Name Datatype Length Mandatory Comments
INTERFACE_HEADER_ID NUMBER
Yes Interface header unique identifier
INTERFACE_LINE_ID NUMBER
Yes Interface line unique identifier
INTERFACE_DISTRIBUTION_ID NUMBER
Yes Interface distribution unique identifier
PO_HEADER_ID NUMBER

Document header unique identifier
PO_RELEASE_ID NUMBER

Release unique identifier
PO_LINE_ID NUMBER

Document line unique identifier
LINE_LOCATION_ID NUMBER

Document shipment unique identifier
PO_DISTRIBUTION_ID NUMBER

Document distribution unique identifier
DISTRIBUTION_NUM NUMBER

Document distribution number
SOURCE_DISTRIBUTION_ID NUMBER

Unique identifier of the planned purchase order distribution that was referenced when creating this scheduled release distribution
ORG_ID NUMBER

Organization identifier
QUANTITY_ORDERED NUMBER

Quantity ordered on the distribution
QUANTITY_DELIVERED NUMBER

Quantity delivered against the distribution
QUANTITY_BILLED NUMBER

Quantity invoiced by Oracle Payables against the distribution
QUANTITY_CANCELLED NUMBER

Quantity cancelled for the distribution
RATE_DATE DATE

Currency conversion date
RATE NUMBER

Currency conversion rate
DELIVER_TO_LOCATION VARCHAR2 (60)
Delivery location code
DELIVER_TO_LOCATION_ID NUMBER

Delivery location unique identifier
DELIVER_TO_PERSON_FULL_NAME VARCHAR2 (240)
Deliver-to person name
DELIVER_TO_PERSON_ID NUMBER

Deliver-to person unique identifier
DESTINATION_TYPE VARCHAR2 (25)
Final destination name of the purchased item
DESTINATION_TYPE_CODE VARCHAR2 (25)
Final destination code for the purchased item
DESTINATION_ORGANIZATION VARCHAR2 (60)
Final destination organization
DESTINATION_ORGANIZATION_ID NUMBER

Final destination organization unique identifier
DESTINATION_SUBINVENTORY VARCHAR2 (10)
Final destination subinventory for inventory purchases
DESTINATION_CONTEXT VARCHAR2 (30)
Destination details protected descriptive flexfield context column
SET_OF_BOOKS VARCHAR2 (30)
Set of Books
SET_OF_BOOKS_ID NUMBER

Set of Books unique identifier
CHARGE_ACCOUNT VARCHAR2 (2000)
General Ledger charge account
CHARGE_ACCOUNT_ID NUMBER

Unique identifier for the General Ledger charge account
BUDGET_ACCOUNT VARCHAR2 (2000)
General Ledger budget account
BUDGET_ACCOUNT_ID NUMBER

Unique identifier for the General Ledger budget account
ACCURAL_ACCOUNT VARCHAR2 (2000)
General Ledger accrual account
ACCRUAL_ACCOUNT_ID NUMBER

Unique identifier for the General Ledger accrual account
VARIANCE_ACCOUNT VARCHAR2 (2000)
General Ledger variance account
VARIANCE_ACCOUNT_ID NUMBER

Unique identifier for the General Ledger variance account
AMOUNT_BILLED NUMBER

Amount invoiced against distribution by Oracle Payables
ACCRUE_ON_RECEIPT_FLAG VARCHAR2 (1)
Indicates whether the items are accrued upon receipt
ACCRUED_FLAG VARCHAR2 (1)
Indicates whether distribution was accrued
PREVENT_ENCUMBRANCE_FLAG VARCHAR2 (1)
Indicates whether distribution should be encumbered
ENCUMBERED_FLAG VARCHAR2 (1)
Distribution encumbered flag
ENCUMBERED_AMOUNT NUMBER

Encumbered amount for distribution
UNENCUMBERED_QUANTITY NUMBER

Quantity unencumbered on the distribution
UNENCUMBERED_AMOUNT NUMBER

Amount unencumbered on the distribution
FAILED_FUNDS VARCHAR2 (25)
Type of budgetary control approval failure
FAILED_FUNDS_LOOKUP_CODE VARCHAR2 (25)
Type of budgetary control approval failure
GL_ENCUMBERED_DATE DATE

Date the distribution was encumbered
GL_ENCUMBERED_PERIOD_NAME VARCHAR2 (15)
Period in which the distribution was encumbered
GL_CANCELLED_DATE DATE

Date the distribution was cancelled
GL_CLOSED_DATE DATE

Date the distribution was final-closed
REQ_HEADER_REFERENCE_NUM VARCHAR2 (25)
Requisition number of the requisition line placed on this distribution
REQ_LINE_REFERENCE_NUM VARCHAR2 (25)
Paper requisition line number
REQ_DISTRIBUTION_ID NUMBER

Requisition line number of the requisition line placed on this distribution
WIP_ENTITY VARCHAR2 (240)
WIP job or repetitive assembly
WIP_ENTITY_ID NUMBER

WIP job or repetitive assembly identifier
WIP_OPERATION_SEQ_NUM NUMBER

WIP operation sequence number within a routing
WIP_RESOURCE_SEQ_NUM NUMBER

WIP resource sequence number
WIP_REPETITIVE_SCHEDULE VARCHAR2 (240)
WIP repetitive schedule
WIP_REPETITIVE_SCHEDULE_ID NUMBER

WIP repetitive schedule identifier
WIP_LINE_CODE VARCHAR2 (10)
WIP line
WIP_LINE_ID NUMBER

WIP line identifier
BOM_RESOURCE_CODE VARCHAR2 (10)
BOM resource code
BOM_RESOURCE_ID NUMBER

BOM resource identifier
USSGL_TRANSACTION_CODE VARCHAR2 (30)
United States standard general ledger transaction code
GOVERNMENT_CONTEXT VARCHAR2 (30)
USSGL descriptive flexfield context column
PROJECT VARCHAR2 (30)
Project accounting project
PROJECT_ID NUMBER

Project accounting project identifier
TASK VARCHAR2 (20)
Project accounting task
TASK_ID NUMBER

Project accounting task identifier
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
Project Manufacturing end item unit number
EXPENDITURE VARCHAR2 (60)
Project accounting expenditure
EXPENDITURE_TYPE VARCHAR2 (30)
Project accounting expenditure type
PROJECT_ACCOUNTING_CONTEXT VARCHAR2 (30)
Project accounting descriptive flexfield context column
EXPENDITURE_ORGANIZATION VARCHAR2 (60)
Project accounting expenditure organization
EXPENDITURE_ORGANIZATION_ID NUMBER

Project accounting expenditure organization identifier
PROJECT_RELEATED_FLAG VARCHAR2 (1)
Project accounting project related
EXPENDITURE_ITEM_DATE DATE

Project accounting expenditure item date
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
LAST_UPDATE_DATE DATE

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

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

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

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

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
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).
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).
RECOVERABLE_TAX NUMBER

Recoverable tax amount
NONRECOVERABLE_TAX NUMBER

Nonrecoverable tax amount
RECOVERY_RATE NUMBER

Percentage of tax that can be recovered
TAX_RECOVERY_OVERRIDE_FLAG VARCHAR2 (1)
Indicator of whether tax recovery should be used
AWARD_ID NUMBER (15)
award id
CHARGE_ACCOUNT_SEGMENT1 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT2 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT3 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT4 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT5 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT6 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT7 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT8 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT9 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT10 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT11 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT12 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT13 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT14 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT15 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT16 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT17 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT18 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT19 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT20 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT21 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT22 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT23 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT24 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT25 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT26 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT27 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT28 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT29 VARCHAR2 (25)
Key Flexfield segment column
CHARGE_ACCOUNT_SEGMENT30 VARCHAR2 (25)
Key Flexfield segment column
OKE_CONTRACT_LINE_ID NUMBER

Oracle Project Contracts unique line identifier
OKE_CONTRACT_LINE_NUM VARCHAR2 (150)
Oracle Project Contracts line number
OKE_CONTRACT_DELIVERABLE_ID NUMBER

Oracle Project Contracts unique deliverable identifier
OKE_CONTRACT_DELIVERABLE_NUM VARCHAR2 (150)
Oracle Project Contracts deliverable number
AWARD_NUMBER VARCHAR2 (15)
Number input by user to identify the award
AMOUNT_ORDERED NUMBER

Amount ordered on the distributions for service line types
INVOICE_ADJUSTMENT_FLAG VARCHAR2 (1)
Flag to indicate invoice adjustment
DEST_CHARGE_ACCOUNT_ID NUMBER

Added in Shared Procurement Services Project (FPJ). This is the Charge Account of the Destination OU (DOU), when the DOU is different from the Purchasing OU (POU) and a Transaction Flow exists between the DOU and POU. It is a unique identifier for a General Ledger account and references GL_CODE_COMBINATIONS.code_combination_id.
DEST_VARIANCE_ACCOUNT_ID NUMBER

Added in Shared Procurement Services Project (FPJ). This is the Variance Account of the DOU, when the DOU is different from the POU and a Transaction Flow exists between the DOU and POU. It is a unique identifier for a General Ledger account and references GL_CODE_COMBINATIONS.code_combination_id.
INTERFACE_LINE_LOCATION_ID NUMBER

Reference to line location interface
PROCESSING_ID NUMBER

Identifier for records to be processed by a certain PDOI run
PROCESS_CODE VARCHAR2 (25)
Processing status
INTERFACE_DISTRIBUTION_REF VARCHAR2 (240)
Interface Distribution Reference
Query Text

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


SELECT INTERFACE_HEADER_ID
,      INTERFACE_LINE_ID
,      INTERFACE_DISTRIBUTION_ID
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      DISTRIBUTION_NUM
,      SOURCE_DISTRIBUTION_ID
,      ORG_ID
,      QUANTITY_ORDERED
,      QUANTITY_DELIVERED
,      QUANTITY_BILLED
,      QUANTITY_CANCELLED
,      RATE_DATE
,      RATE
,      DELIVER_TO_LOCATION
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_PERSON_FULL_NAME
,      DELIVER_TO_PERSON_ID
,      DESTINATION_TYPE
,      DESTINATION_TYPE_CODE
,      DESTINATION_ORGANIZATION
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_SUBINVENTORY
,      DESTINATION_CONTEXT
,      SET_OF_BOOKS
,      SET_OF_BOOKS_ID
,      CHARGE_ACCOUNT
,      CHARGE_ACCOUNT_ID
,      BUDGET_ACCOUNT
,      BUDGET_ACCOUNT_ID
,      ACCURAL_ACCOUNT
,      ACCRUAL_ACCOUNT_ID
,      VARIANCE_ACCOUNT
,      VARIANCE_ACCOUNT_ID
,      AMOUNT_BILLED
,      ACCRUE_ON_RECEIPT_FLAG
,      ACCRUED_FLAG
,      PREVENT_ENCUMBRANCE_FLAG
,      ENCUMBERED_FLAG
,      ENCUMBERED_AMOUNT
,      UNENCUMBERED_QUANTITY
,      UNENCUMBERED_AMOUNT
,      FAILED_FUNDS
,      FAILED_FUNDS_LOOKUP_CODE
,      GL_ENCUMBERED_DATE
,      GL_ENCUMBERED_PERIOD_NAME
,      GL_CANCELLED_DATE
,      GL_CLOSED_DATE
,      REQ_HEADER_REFERENCE_NUM
,      REQ_LINE_REFERENCE_NUM
,      REQ_DISTRIBUTION_ID
,      WIP_ENTITY
,      WIP_ENTITY_ID
,      WIP_OPERATION_SEQ_NUM
,      WIP_RESOURCE_SEQ_NUM
,      WIP_REPETITIVE_SCHEDULE
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_LINE_CODE
,      WIP_LINE_ID
,      BOM_RESOURCE_CODE
,      BOM_RESOURCE_ID
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      PROJECT
,      PROJECT_ID
,      TASK
,      TASK_ID
,      END_ITEM_UNIT_NUMBER
,      EXPENDITURE
,      EXPENDITURE_TYPE
,      PROJECT_ACCOUNTING_CONTEXT
,      EXPENDITURE_ORGANIZATION
,      EXPENDITURE_ORGANIZATION_ID
,      PROJECT_RELEATED_FLAG
,      EXPENDITURE_ITEM_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RECOVERABLE_TAX
,      NONRECOVERABLE_TAX
,      RECOVERY_RATE
,      TAX_RECOVERY_OVERRIDE_FLAG
,      AWARD_ID
,      CHARGE_ACCOUNT_SEGMENT1
,      CHARGE_ACCOUNT_SEGMENT2
,      CHARGE_ACCOUNT_SEGMENT3
,      CHARGE_ACCOUNT_SEGMENT4
,      CHARGE_ACCOUNT_SEGMENT5
,      CHARGE_ACCOUNT_SEGMENT6
,      CHARGE_ACCOUNT_SEGMENT7
,      CHARGE_ACCOUNT_SEGMENT8
,      CHARGE_ACCOUNT_SEGMENT9
,      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_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_SEGMENT30
,      OKE_CONTRACT_LINE_ID
,      OKE_CONTRACT_LINE_NUM
,      OKE_CONTRACT_DELIVERABLE_ID
,      OKE_CONTRACT_DELIVERABLE_NUM
,      AWARD_NUMBER
,      AMOUNT_ORDERED
,      INVOICE_ADJUSTMENT_FLAG
,      DEST_CHARGE_ACCOUNT_ID
,      DEST_VARIANCE_ACCOUNT_ID
,      INTERFACE_LINE_LOCATION_ID
,      PROCESSING_ID
,      PROCESS_CODE
,      INTERFACE_DISTRIBUTION_REF
FROM PO.PO_DISTRIBUTIONS_INTERFACE;

Dependencies

[top of page]

PO.PO_DISTRIBUTIONS_INTERFACE does not reference any database object

PO.PO_DISTRIBUTIONS_INTERFACE is referenced by following:

SchemaAPPS
SynonymPO_DISTRIBUTIONS_INTERFACE