[Home] [Help]
[Dependency Information]
Object Name: | PO_DISTRIBUTIONS_ARCHIVE_ALL |
---|---|
Object Type: | TABLE |
Owner: | PO |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
PO_DISTRIBUTIONS_ARCHIVE_ALL contains archived distribution
information. Oracle Purchasing only archives distributions for the
following documents:
.
{{"bul:1"}}Standard purchase orders
.
{{"bul:1"}}Planned purchase orders
.
{{"bul:1"}}Planned purchase order releases
.
{{"bul:1"}}Blanket purchase order releases
.
{{"bodytext"}}When you modify a distribution, Oracle Purchasing will
archive it after you (re)approve the purchase order or after you
print it (this depends on the purchasing system options). You can
retrieve revisions of the distributions using this table.
.
The latest archived revision will have LATEST_EXTERNAL_FLAG set to 'Y'.
.
You need one row for each distribution archive. Each row contains the
same information as the PO_DISTRIBUTIONS_ALL table. Oracle Purchasing
uses this information to ensure you keep copies of your legal
documents.
.
Tablespace: | ![]() |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PO_DISTRIBUTIONS_ARCHIVE_U1 | NORMAL | UNIQUE |
![]() |
![]() ![]() |
PO_DISTRIBUTIONS_ARCHIVE_N1 | NORMAL | NONUNIQUE |
![]() |
![]() |
PO_DISTRIBUTIONS_ARCHIVE_N2 | NORMAL | NONUNIQUE |
![]() |
![]() |
PO_DISTRIBUTIONS_ARCHIVE_N3 | NORMAL | NONUNIQUE |
![]() |
![]() |
PO_DISTRIBUTIONS_ARCHIVE_N4 | NORMAL | NONUNIQUE |
![]() |
![]() |
PO_DISTRIBUTIONS_ARCHIVE_N5 | NORMAL | NONUNIQUE |
![]() |
![]() |
PO_DISTRIBUTIONS_ARCHIVE_N6 | NORMAL | NONUNIQUE |
![]() |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PO_DISTRIBUTION_ID | NUMBER | Yes | Document distribution unique identifier | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
PO_HEADER_ID | NUMBER | Yes | Document header unique identifier | |
PO_LINE_ID | NUMBER | Document line unique identifier | ||
LINE_LOCATION_ID | NUMBER | Document shipment schedule unique identifier | ||
SET_OF_BOOKS_ID | NUMBER | Yes | Set of Books unique identifier | |
CODE_COMBINATION_ID | NUMBER | Unique identifier for the General Ledger charge account | ||
QUANTITY_ORDERED | NUMBER | Quantity ordered on the distribution | ||
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). | ||
PO_RELEASE_ID | NUMBER | Release unique identifier | ||
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 | ||
REQ_HEADER_REFERENCE_NUM | VARCHAR2 | (25) | Requisition number of the requisition line placed on this distribution | |
REQ_LINE_REFERENCE_NUM | VARCHAR2 | (25) | Line number of the requisition line placed on the distribution | |
REQ_DISTRIBUTION_ID | NUMBER | Requisition distribution unique identifier | ||
DELIVER_TO_LOCATION_ID | NUMBER | Unique identifier for the delivery location | ||
DELIVER_TO_PERSON_ID | NUMBER | (9) | Unique identifier for the requester | |
RATE_DATE | DATE | Currency conversion date | ||
RATE | NUMBER | Currency conversion rate | ||
AMOUNT_BILLED | NUMBER | Amount invoiced by Oracle Payables against the distribution | ||
ACCRUED_FLAG | VARCHAR2 | (1) | Indicates whether the distribution was accrued or not | |
ENCUMBERED_FLAG | VARCHAR2 | (1) | Indicator of whether the distribution was encumbered | |
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_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 | ||
DESTINATION_TYPE_CODE | VARCHAR2 | (25) | Final destination of the purchased items | |
DESTINATION_ORGANIZATION_ID | NUMBER | Final destination organization unique identifier | ||
DESTINATION_SUBINVENTORY | VARCHAR2 | (10) | Subinventory unique identifier for inventory purchases | |
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 | |
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_ID | NUMBER | WIP repetitive schedule identifier | ||
WIP_LINE_ID | NUMBER | WIP line identifier | ||
BOM_RESOURCE_ID | NUMBER | BOM resource unique identifier | ||
BUDGET_ACCOUNT_ID | NUMBER | Unique identifier for the General Ledger budget account | ||
ACCRUAL_ACCOUNT_ID | NUMBER | Unique identifier for the General Ledger accrual account | ||
VARIANCE_ACCOUNT_ID | NUMBER | Unique identifier for the General Ledger variance account | ||
DESTINATION_CONTEXT | VARCHAR2 | (30) | Destination details protected descriptive flexfield context column | |
DISTRIBUTION_NUM | NUMBER | Yes | Distribution number | |
SOURCE_DISTRIBUTION_ID | NUMBER | Unique identifier of the planned purchase order distribution that was referenced when creating this scheduled release distribution | ||
REVISION_NUM | NUMBER | Document revision number | ||
LATEST_EXTERNAL_FLAG | VARCHAR2 | (1) | Indicates whether this is the latest archived revision | |
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). | ||
GOVERNMENT_CONTEXT | VARCHAR2 | (30) | USSGL descriptive flexfield context column | |
PREVENT_ENCUMBRANCE_FLAG | VARCHAR2 | (1) | Indicates whether distribution should be encumbered | |
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | United States standard general ledger transaction code | |
PROJECT_ID | NUMBER | Project accounting project unique identifier | ||
TASK_ID | NUMBER | Project accounting task unique identifier | ||
END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | Project Manufacturing end item unit number | |
EXPENDITURE_TYPE | VARCHAR2 | (30) | Project accounting expenditure type | |
PROJECT_ACCOUNTING_CONTEXT | VARCHAR2 | (30) | Project accounting descriptive flexfield context column | |
EXPENDITURE_ORGANIZATION_ID | NUMBER | Project accounting expenditure organization unique identifier | ||
ACCRUE_ON_RECEIPT_FLAG | VARCHAR2 | (1) | Indicates whether items are accrued on receipt | |
GL_CLOSED_DATE | DATE | Date the distribution was final-closed | ||
EXPENDITURE_ITEM_DATE | DATE | Project accounting expenditure item date | ||
ORG_ID | NUMBER | Organization identifier | ||
KANBAN_CARD_ID | NUMBER | Primary key for the kanban card | ||
AWARD_ID | NUMBER | (15) | Award identifier | |
MRC_RATE_DATE | VARCHAR2 | (2000) | Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID and currency conversion date pairs | |
MRC_RATE | VARCHAR2 | (2000) | Multiple Reporting Currencies only: Concatenatedstring of reporting Set of Books ID and currency conversion rate pairs | |
MRC_ENCUMBERED_AMOUNT | VARCHAR2 | (2000) | Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID and encumbered amount for distribution pairs | |
MRC_UNENCUMBERED_AMOUNT | VARCHAR2 | (2000) | Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID and amount unencumbered on the distribution pairs | |
RECOVERABLE_TAX | NUMBER | Recoverable tax amount | ||
NONRECOVERABLE_TAX | NUMBER | Non recoverable 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 | |
OKE_CONTRACT_LINE_ID | NUMBER | Line Id associated with a contract | ||
OKE_CONTRACT_DELIVERABLE_ID | NUMBER | Deliverable Id corresponding to contract | ||
AMOUNT_ORDERED | NUMBER | Amount Ordered | ||
AMOUNT_DELIVERED | NUMBER | Amount Delivered | ||
AMOUNT_CANCELLED | NUMBER | amount Cancelled | ||
DISTRIBUTION_TYPE | VARCHAR2 | (25) | -- FPJ Encumbrance Rewrite project | |
AMOUNT_TO_ENCUMBER | NUMBER | -- FPJ Encumbrance Rewrite Project | ||
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. | ||
QUANTITY_FINANCED | NUMBER | For Financing Distributions, the number of units which have been pre-paid | ||
AMOUNT_FINANCED | NUMBER | For Advance or Financing Distributions, the amount which has been pre-paid | ||
QUANTITY_RECOUPED | NUMBER | For Financing Distributions, the number of units for which prepayments have been liquidated | ||
AMOUNT_RECOUPED | NUMBER | For Advance or Financing Distributions, the amount of the prepayments which has been liquidated | ||
RETAINAGE_WITHHELD_AMOUNT | NUMBER | The total amount withheld as Retainage against this Distribution | ||
RETAINAGE_RELEASED_AMOUNT | NUMBER | The amount of Retainage released for this Distribution |
Cut, paste (and edit) the following text to query this object:
SELECT PO_DISTRIBUTION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, PO_HEADER_ID
, PO_LINE_ID
, LINE_LOCATION_ID
, SET_OF_BOOKS_ID
, CODE_COMBINATION_ID
, QUANTITY_ORDERED
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, PO_RELEASE_ID
, QUANTITY_DELIVERED
, QUANTITY_BILLED
, QUANTITY_CANCELLED
, REQ_HEADER_REFERENCE_NUM
, REQ_LINE_REFERENCE_NUM
, REQ_DISTRIBUTION_ID
, DELIVER_TO_LOCATION_ID
, DELIVER_TO_PERSON_ID
, RATE_DATE
, RATE
, AMOUNT_BILLED
, ACCRUED_FLAG
, ENCUMBERED_FLAG
, ENCUMBERED_AMOUNT
, UNENCUMBERED_QUANTITY
, UNENCUMBERED_AMOUNT
, FAILED_FUNDS_LOOKUP_CODE
, GL_ENCUMBERED_DATE
, GL_ENCUMBERED_PERIOD_NAME
, GL_CANCELLED_DATE
, DESTINATION_TYPE_CODE
, DESTINATION_ORGANIZATION_ID
, DESTINATION_SUBINVENTORY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, WIP_ENTITY_ID
, WIP_OPERATION_SEQ_NUM
, WIP_RESOURCE_SEQ_NUM
, WIP_REPETITIVE_SCHEDULE_ID
, WIP_LINE_ID
, BOM_RESOURCE_ID
, BUDGET_ACCOUNT_ID
, ACCRUAL_ACCOUNT_ID
, VARIANCE_ACCOUNT_ID
, DESTINATION_CONTEXT
, DISTRIBUTION_NUM
, SOURCE_DISTRIBUTION_ID
, REVISION_NUM
, LATEST_EXTERNAL_FLAG
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, GOVERNMENT_CONTEXT
, PREVENT_ENCUMBRANCE_FLAG
, USSGL_TRANSACTION_CODE
, PROJECT_ID
, TASK_ID
, END_ITEM_UNIT_NUMBER
, EXPENDITURE_TYPE
, PROJECT_ACCOUNTING_CONTEXT
, EXPENDITURE_ORGANIZATION_ID
, ACCRUE_ON_RECEIPT_FLAG
, GL_CLOSED_DATE
, EXPENDITURE_ITEM_DATE
, ORG_ID
, KANBAN_CARD_ID
, AWARD_ID
, MRC_RATE_DATE
, MRC_RATE
, MRC_ENCUMBERED_AMOUNT
, MRC_UNENCUMBERED_AMOUNT
, RECOVERABLE_TAX
, NONRECOVERABLE_TAX
, RECOVERY_RATE
, TAX_RECOVERY_OVERRIDE_FLAG
, OKE_CONTRACT_LINE_ID
, OKE_CONTRACT_DELIVERABLE_ID
, AMOUNT_ORDERED
, AMOUNT_DELIVERED
, AMOUNT_CANCELLED
, DISTRIBUTION_TYPE
, AMOUNT_TO_ENCUMBER
, INVOICE_ADJUSTMENT_FLAG
, DEST_CHARGE_ACCOUNT_ID
, DEST_VARIANCE_ACCOUNT_ID
, QUANTITY_FINANCED
, AMOUNT_FINANCED
, QUANTITY_RECOUPED
, AMOUNT_RECOUPED
, RETAINAGE_WITHHELD_AMOUNT
, RETAINAGE_RELEASED_AMOUNT
FROM PO.PO_DISTRIBUTIONS_ARCHIVE_ALL;
PO.PO_DISTRIBUTIONS_ARCHIVE_ALL does not reference any database object
PO.PO_DISTRIBUTIONS_ARCHIVE_ALL is referenced by following:
|
|
|