[Home] [Help]
[Dependency Information]
Object Name: | PO_DISTRIBUTIONS_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | PO |
FND Design Data: | ![]() |
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
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PO_DISTRIBUTIONS_INTERFACE_U1 | NORMAL | UNIQUE |
![]() |
![]() |
PO_DISTRIBUTIONS_INTERFACE_N1 | NORMAL | NONUNIQUE |
![]() |
![]() |
PO_DISTRIBUTIONS_INTERFACE_N2 | NORMAL | NONUNIQUE |
![]() |
![]() |
PO_DISTRIBUTIONS_INTERFACE_N3 | NORMAL | NONUNIQUE |
![]() |
![]() |
PO_DISTRIBUTIONS_INTERFACE_N4 | NORMAL | NONUNIQUE |
![]() |
![]() |
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_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 | |
GROUP_LINE_ID | NUMBER | PO Line Id of the Informational SLIN against which Funding is provided | ||
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 | ||
AMOUNT_FUNDED | NUMBER | Represents Funded Amount, for Amount 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 | |
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. | |
TASK#2 | VARCHAR2 | (250) | ||
CLM_PAYMENT_SEQUENCE_NUM | NUMBER |
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_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
, GROUP_LINE_ID
, FUNDED_VALUE
, PARTIAL_FUNDED_FLAG
, QUANTITY_FUNDED
, AMOUNT_FUNDED
, CLM_MISC_LOA
, CLM_DEFENCE_FUNDING
, CLM_FMS_CASE_NUMBER
, CLM_AGENCY_ACCT_IDENTIFIER
, ACRN
, TASK#2
, CLM_PAYMENT_SEQUENCE_NUM
FROM PO.PO_DISTRIBUTIONS_INTERFACE;
PO.PO_DISTRIBUTIONS_INTERFACE does not reference any database object
PO.PO_DISTRIBUTIONS_INTERFACE is referenced by following:
|
|
|