Table: PO_DISTRIBUTIONS_ARCHIVE_ALL

Product:	PO - Purchasing
Description:	Archived distributions
Implementation/DBA Data:	PO.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

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