EBS:PO_DISTRIBUTIONS_ARCHIVE_ALL

描述：存档的分布

Primary Key: PO_DISTRIBUTIONS_ARCHIVE_PK

1. PO_DISTRIBUTION_ID
2. REVISION_NUM

Primary Key: PO_DISTRIBUTIONS_ARCHIVE_UK1

1. LINE_LOCATION_ID
2. DISTRIBUTION_NUM
3. REVISION_NUM

Foreign Keys from this table:

Foreign Key Column	Foreign Table
PO_DISTRIBUTIONS_ARCHIVE_ALL.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
PO_DISTRIBUTIONS_ARCHIVE_ALL.DESTINATION_SUBINVENTORY PO_DISTRIBUTIONS_ARCHIVE_ALL.DESTINATION_ORGANIZATION_ID	MTL_SECONDARY_INVENTORIES
PO_DISTRIBUTIONS_ARCHIVE_ALL.BOM_RESOURCE_ID	BOM_RESOURCES
PO_DISTRIBUTIONS_ARCHIVE_ALL.PO_HEADER_ID	PO_HEADERS_ALL
PO_DISTRIBUTIONS_ARCHIVE_ALL.BUDGET_ACCOUNT_ID	GL_CODE_COMBINATIONS
PO_DISTRIBUTIONS_ARCHIVE_ALL.ACCRUAL_ACCOUNT_ID	GL_CODE_COMBINATIONS
PO_DISTRIBUTIONS_ARCHIVE_ALL.VARIANCE_ACCOUNT_ID	GL_CODE_COMBINATIONS
PO_DISTRIBUTIONS_ARCHIVE_ALL.SOURCE_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
PO_DISTRIBUTIONS_ARCHIVE_ALL.PO_LINE_ID	PO_LINES_ALL
PO_DISTRIBUTIONS_ARCHIVE_ALL.LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
PO_DISTRIBUTIONS_ARCHIVE_ALL.SET_OF_BOOKS_ID	GL_SETS_OF_BOOKS
PO_DISTRIBUTIONS_ARCHIVE_ALL.CODE_COMBINATION_ID	GL_CODE_COMBINATIONS
PO_DISTRIBUTIONS_ARCHIVE_ALL.PO_RELEASE_ID	PO_RELEASES_ALL
PO_DISTRIBUTIONS_ARCHIVE_ALL.REQ_DISTRIBUTION_ID	PO_REQ_DISTRIBUTIONS_ALL

Foreign Keys to this table:

Foreign Key Column	Foreign Table
ICX_PO_REVISIONS_TEMP.DISTRIBUTION_ID ICX_PO_REVISIONS_TEMP.REVISION_NUM	PO_DISTRIBUTIONS_ARCHIVE_ALL

Comments:

PO_DISTRIBUTIONS_ARCHIVE_ALL包含归档的分发信息。Oracle Purchasing仅对以下文档的发行版本进行归档:Standard purchase orders、Planned purchase orders、Planned purchase order releases、Blanket purchase order releases。当您修改发行版时，Oracle Purchasing将在您(重新)批准采购订单或打印订单(这取决于采购系统选项)之后对其进行归档。您可以使用该表检索发行版的修订。

最新的存档版本将LATEST_EXTERNAL_FLAG设置为'Y'。

每个发布存档需要一行。每行包含与PO_DISTRIBUTIONS_ALL表相同的信息。Oracle采购使用这些信息来确保您保留法律文件的副本