eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PO.PO_DISTRIBUTIONS_DRAFT_ALL

Object Details

Object Name:	PO_DISTRIBUTIONS_DRAFT_ALL
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.PO_DISTRIBUTIONS_DRAFT_ALL
Subobject Name:
Status:	VALID

PO_DISTRIBUTIONS_DRAFT_ALL stores draft changes to PO distribution that have not been accepted by buyer. A record in this table contains the proposed values for the corresponding record in the transaction table PO_DISTRIBUTIONS_ALL. When the draft changes are accepted, the record is moved to PO_DISTRIBUTIONS_ALL. Changes from buyer are automatically accepted.
PO_DISTRIBUTIONS_DRAFT_ALL contains all columns from PO_DISTRIBUTIONS_ALL, as well as the following additional columns:
1. DRAFT_ID: primary key of the table; foreign key to PO_DRAFTS;
2. CHANGE_ACCEPTED_FLAG: acceptance status of the draft record;
3. DELETE_FLAG: flag indicating whether the corresponding record in transaction table should be deleted when the draft change is accepted.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_DISTRIBUTIONS_DRAFT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PO_DISTRIBUTION_ID DRAFT_ID
PO_DISTRIBUTIONS_DRAFT_N0	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DRAFT_ID
PO_DISTRIBUTIONS_DRAFT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LINE_LOCATION_ID
PO_DISTRIBUTIONS_DRAFT_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_ACCOUNT_ID
PO_DISTRIBUTIONS_DRAFT_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_RELEASE_ID
PO_DISTRIBUTIONS_DRAFT_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_DISTRIBUTION_ID
PO_DISTRIBUTIONS_DRAFT_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE
PO_DISTRIBUTIONS_DRAFT_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KANBAN_CARD_ID
PO_DISTRIBUTIONS_DRAFT_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAR_DRAFT_ID
PO_DISTRIBUTIONS_DRAFT_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQ_DISTRIBUTION_ID
PO_DISTRIBUTIONS_DRAFT_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_HEADER_ID
PO_DISTRIBUTIONS_DRAFT_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_LINE_ID
PO_DISTRIBUTIONS_DRAFT_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQ_HEADER_REFERENCE_NUM REQ_LINE_REFERENCE_NUM
PO_DISTRIBUTIONS_DRAFT_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVER_TO_PERSON_ID
PO_DISTRIBUTIONS_DRAFT_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_ENCUMBERED_DATE
PO_DISTRIBUTIONS_DRAFT_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID WIP_OPERATION_SEQ_NUM WIP_RESOURCE_SEQ_NUM DESTINATION_ORGANIZATION_ID WIP_REPETITIVE_SCHEDULE_ID
PO_DISTRIBUTIONS_DRAFT_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID TASK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DRAFT_ID	NUMBER		Yes	Primary key of the table; Foreign key to PO_DRAFTS table.
CHANGE_ACCEPTED_FLAG	VARCHAR2	(1)		Acceptance status of the draft record.
DELETE_FLAG	VARCHAR2	(1)		Flag indicating whether the corresponding record in transaction table should be deleted when the draft change is accepted.
PO_DISTRIBUTION_ID	NUMBER		Yes	Document distribution unique identifier. Primary key for this table.
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. References PO_HEADERS_ALL.PO_HEADER_ID.
PO_LINE_ID	NUMBER			Document line unique identifier. References PO_LINES_ALL.PO_LINE_ID.
LINE_LOCATION_ID	NUMBER			Document shipment schedule unique identifier. References PO_LINES_LOCATIONS_ALL.LINE_LOCATION_ID.
SET_OF_BOOKS_ID	NUMBER		Yes	Set of Books unique identifier. References GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID.
CODE_COMBINATION_ID	NUMBER			Unique identifier for the General Ledger charge account. References GL_CODE_COMBINATIONS.CODE_COMBINATION_ID.
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. References PO_RELEASES_ALL.PO_RELEASE_ID.
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)		Identifies the requisition number of the corresponding paper requisition, if you do not autocreate the purchase order from online requisitions.
REQ_LINE_REFERENCE_NUM	VARCHAR2	(25)		Identifies the requisition line number of the corresponding paper requisition, if you do not autocreate the purchase order from online requisitions.
REQ_DISTRIBUTION_ID	NUMBER			Requisition distribution unique identifier. References PO_REQ_DISTRIBUTIONS_ALL.DISTRIBUTION_ID.
DELIVER_TO_LOCATION_ID	NUMBER			Unique identifier for the delivery location. References HR_LOCATIONS_ALL.LOCATION_ID.
DELIVER_TO_PERSON_ID	NUMBER	(9)		Unique identifier for the requester. References HR_EMPLOYEES.EMPLOYEE_ID.
RATE_DATE	DATE			Currency conversion date
RATE	NUMBER			Currency conversion rate. References GL_DAILY_CONVERSION_RATES_R10.CONVERSION_RATE.
AMOUNT_BILLED	NUMBER			Amount invoiced by Oracle Payables against the distribution
ACCRUED_FLAG	VARCHAR2	(1)		Indicates whether the distribution was accrued (received but not yet billed).
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_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. References HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID. Combined with DESTINATION_SUBINVENTORY, forms a foreign key to MTL_SECONDARY_INVENTORIES. Combined with WIP_ENTITY_ID, forms a foreign key to WIP_ENTITIES. Combined with WIP_LINE_ID, forms a foreign key to WIP_LINES. Combined with WIP_ENTITY_ID, WIP_OPERATION_SEQ_NUM, and WIP_REPETITIVE_SCHEDULE_ID, forms a foreign key to WIP_OPERATIONS. Combined with WIP_ENTITY_ID, WIP_OPERATION_SEQ_NUM, WIP_RESOURCE_SEQ_NUM, and WIP_REPETITIVE_SCHEDULE_ID, forms a foreign key to WIP_OPERATION_RESOURCES.
DESTINATION_SUBINVENTORY	VARCHAR2	(10)		Subinventory unique identifier for inventory purchases. Combined with DESTINATION_ORGANIZATION_ID, forms a foreign key to MTL_SECONDARY_INVENTORIES.
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. Combined with DESTINATION_ORGANIZATION_ID, forms a foreign key to WIP_ENTITIES. Combined with DESTINATION_ORGANIZATION_ID, WIP_OPERATION_SEQ_NUM, and WIP_REPETITIVE_SCHEDULE_ID, forms a foreign key to WIP_OPERATIONS. Combined with DESTINATION_ORGANIZATION_ID, WIP_OPERATION_SEQ_NUM, WIP_RESOURCE_SEQ_NUM, and WIP_REPETITIVE_SCHEDULE_ID, forms a foreign key to WIP_OPERATION_RESOURCES.
WIP_OPERATION_SEQ_NUM	NUMBER			WIP operation sequence number within a routing. Combined with WIP_ENTITY_ID, DESTINATION_ORGANIZATION_ID, WIP_REPETITIVE_SCHEDULE_ID, forms a foreign key to WIP_OPERATIONS. Combined with WIP_ENTITY_ID, DESTINATION_ORGANIZATION_ID, WIP_RESOURCE_SEQ_NUM, and WIP_REPETITIVE_SCHEDULE_ID, forms a foreign key to WIP_OPERATION_RESOURCES.
WIP_RESOURCE_SEQ_NUM	NUMBER			WIP resource sequence number. Combined with WIP_ENTITY_ID, DESTINATION_ORGANIZATION_ID, WIP_OPERATION_SEQ_NUM, and WIP_REPETITIVE_SCHEDULE_ID, forms a foreign key to WIP_OPERATION_RESOURCES.
WIP_REPETITIVE_SCHEDULE_ID	NUMBER			WIP repetitive schedule identifier. Combined with WIP_ENTITY_ID, DESTINATION_ORGANIZATION_ID, and WIP_OPERATION_SEQ_NUM, forms a foreign key to WIP_OPERATIONS. Combined with WIP_ENTITY_ID, DESTINATION_ORGANIZATION_ID, WIP_OPERATION_SEQ_NUM, and WIP_RESOURCE_SEQ_NUM, forms a foreign key to WIP_OPERATION_RESOURCES.
WIP_LINE_ID	NUMBER			WIP line identifier. Combined with DESTINATION_ORGANIZATION_ID, forms a foreign key to WIP_LINES.
BOM_RESOURCE_ID	NUMBER			BOM resource unique identifier. References BOM_RESOURCES.RESOURCE_ID.
BUDGET_ACCOUNT_ID	NUMBER			Unique identifier for the General Ledger budget account. References GL_CODE_COMBINATIONS.CODE_COMBINATION_ID.
ACCRUAL_ACCOUNT_ID	NUMBER			Unique identifier for the General Ledger accrual account. References GL_CODE_COMBINATIONS.CODE_COMBINATION_ID.
VARIANCE_ACCOUNT_ID	NUMBER			Unique identifier for the General Ledger variance account. References GL_CODE_COMBINATIONS.CODE_COMBINATION_ID.
PREVENT_ENCUMBRANCE_FLAG	VARCHAR2	(1)		Indicates whether distribution should be encumbered
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		United States standard general ledger transaction code. References GL_USSGL_TRANSACTION_CODES.USSGL_TRANSACTION_CODE.
GOVERNMENT_CONTEXT	VARCHAR2	(30)		USSGL descriptive flexfield context column
DESTINATION_CONTEXT	VARCHAR2	(30)		Protected descriptive flexfield context column for destination details
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. References PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_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).
PROJECT_ID	NUMBER			Project accounting project unique identifier. References PA_PROJECTS_ALL.PROJECT_ID.
TASK_ID	NUMBER			Project accounting task unique identifier. References PA_TASKS.TASK_ID.
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. References ORG_ORGANIXATION_DEFINITIONS.ORGANIZATION_ID.
GL_CLOSED_DATE	DATE			Date the distribution was final-closed
ACCRUE_ON_RECEIPT_FLAG	VARCHAR2	(1)		Indicates whether items are accrued upon receipt
EXPENDITURE_ITEM_DATE	DATE			Project accounting expenditure item date
ORG_ID	NUMBER			Organization identifier
KANBAN_CARD_ID	NUMBER			Primary key for the kanban card. References MTL_KANBAN_CARDS.KANBAN_CARD_ID.
AWARD_ID	NUMBER	(15)		Award identifier. References GMS_AWARD_DISTRIBUTIONS.AWARD_SET_ID.
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
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		Project Manufacturing end item unit number
TAX_RECOVERY_OVERRIDE_FLAG	VARCHAR2	(1)		Indicator of whether tax recovery should be used
RECOVERABLE_TAX	NUMBER			Recoverable tax amount
NONRECOVERABLE_TAX	NUMBER			Nonrecoverable tax amoun
RECOVERY_RATE	NUMBER			Percentage of tax that can be recovered
OKE_CONTRACT_LINE_ID	NUMBER			Line Id associated with a contract. References OKC_K_LINES_B.ID.
OKE_CONTRACT_DELIVERABLE_ID	NUMBER			Deliverable Id corresponding to contract. References OKE_K_DELIVERABLES_B.DELIVERABLE_ID.
AMOUNT_ORDERED	NUMBER			Amount ordered for service lines
AMOUNT_DELIVERED	NUMBER			Amount delivered for service lines
AMOUNT_CANCELLED	NUMBER			Amount cancelled for service lines
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
TAX_ATTRIBUTE_UPDATE_CODE	VARCHAR2	(15)		Keeps track of create/update actions on this entity
GROUP_LINE_ID	NUMBER			PO Line Id of the Informational SLIN against which Funding is provided
CHANGE_STATUS	VARCHAR2	(30)		Can have values NEW / UPDATE / NOCHANGE
UDA_TEMPLATE_ID	NUMBER			UDA Tempate Id
AMOUNT_FUNDED	NUMBER			Represents Funded Amount, for Amount Based lines
FUNDED_VALUE	NUMBER			Represents Funded value
PARTIAL_FUNDED_FLAG	VARCHAR2	(1)		Partial Funded Flag has values Y / N / null
QUANTITY_FUNDED	NUMBER			Represents Quantity Funded, for Quantity Based lines
CLM_MISC_LOA	VARCHAR2	(200)		CLM Misc LOA
CLM_DEFENCE_FUNDING	VARCHAR2	(10)		Has values DOD / NON_DOD / null
CLM_FMS_CASE_NUMBER	VARCHAR2	(200)		FMS Case Number
CLM_AGENCY_ACCT_IDENTIFIER	VARCHAR2	(100)		Agency ACCT Identifier
CHANGE_IN_FUNDED_VALUE	NUMBER			Represents change in funded value as part of Modification
OLD_QUANTITY_ORDERED	NUMBER			Original Quantity Ordered of the Base Document Distribution
ACRN	VARCHAR2	(2)		ACRNs begin with "AA" and will include starting A1-A9, B1-B9, etc.., after "ZZ". The letters 'I' and 'O' cannot be used.
OLD_AMOUNT_ORDERED	NUMBER
REVISION_NUM	NUMBER
CLM_PAYMENT_SEQUENCE_NUM	NUMBER
COMMENTS	VARCHAR2	(2000)
PAR_DISTRIBUTION_ID	NUMBER
PAR_DRAFT_ID	NUMBER
AMOUNT_CHANGED_FLAG	VARCHAR2	(1)

Query Text

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


SELECT DRAFT_ID
,      CHANGE_ACCEPTED_FLAG
,      DELETE_FLAG
,      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
,      PREVENT_ENCUMBRANCE_FLAG
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      DESTINATION_CONTEXT
,      DISTRIBUTION_NUM
,      SOURCE_DISTRIBUTION_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      PROJECT_ACCOUNTING_CONTEXT
,      EXPENDITURE_ORGANIZATION_ID
,      GL_CLOSED_DATE
,      ACCRUE_ON_RECEIPT_FLAG
,      EXPENDITURE_ITEM_DATE
,      ORG_ID
,      KANBAN_CARD_ID
,      AWARD_ID
,      MRC_RATE_DATE
,      MRC_RATE
,      MRC_ENCUMBERED_AMOUNT
,      MRC_UNENCUMBERED_AMOUNT
,      END_ITEM_UNIT_NUMBER
,      TAX_RECOVERY_OVERRIDE_FLAG
,      RECOVERABLE_TAX
,      NONRECOVERABLE_TAX
,      RECOVERY_RATE
,      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
,      TAX_ATTRIBUTE_UPDATE_CODE
,      GROUP_LINE_ID
,      CHANGE_STATUS
,      UDA_TEMPLATE_ID
,      AMOUNT_FUNDED
,      FUNDED_VALUE
,      PARTIAL_FUNDED_FLAG
,      QUANTITY_FUNDED
,      CLM_MISC_LOA
,      CLM_DEFENCE_FUNDING
,      CLM_FMS_CASE_NUMBER
,      CLM_AGENCY_ACCT_IDENTIFIER
,      CHANGE_IN_FUNDED_VALUE
,      OLD_QUANTITY_ORDERED
,      ACRN
,      OLD_AMOUNT_ORDERED
,      REVISION_NUM
,      CLM_PAYMENT_SEQUENCE_NUM
,      COMMENTS
,      PAR_DISTRIBUTION_ID
,      PAR_DRAFT_ID
,      AMOUNT_CHANGED_FLAG
FROM PO.PO_DISTRIBUTIONS_DRAFT_ALL;

Dependencies

[top of page]

PO.PO_DISTRIBUTIONS_DRAFT_ALL does not reference any database object

PO.PO_DISTRIBUTIONS_DRAFT_ALL is referenced by following:

PO: PO_DISTRIBUTIONS_DRAFT_ALL#