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

VIEW: APPS.PO_DISTRIBUTIONS_MERGE_V

Object Details
Object Name: PO_DISTRIBUTIONS_MERGE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_DISTRIBUTIONS_MERGE_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER_USER_ID NUMBER

The user_id of the user that created the draft changes.
OWNER_ROLE VARCHAR2 (10)
The role of the user that created the draft changes. It could be BUYER, SUPPLIER or ADMIN
STATUS VARCHAR2 (15)
Status of the draft change request.
DRAFT_ID NUMBER

The primary key of PO_DRAFTS table. It may be interpreted as a the version of the draft change.
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.
DESTINATION_CONTEXT VARCHAR2 (30)
Protected descriptive flexfield context column for destination details
DISTRIBUTION_NUM NUMBER

Distribution number
SOURCE_DISTRIBUTION_ID NUMBER

Unique identifier of the planned purchase order distribution that was referenced when creating this scheduled release distribution.
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.
TASK_ID NUMBER

Project accounting task unique identifier.
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.
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
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.
PREVENT_ENCUMBRANCE_FLAG VARCHAR2 (1)
Indicates whether distribution should be encumbered
USSGL_TRANSACTION_CODE VARCHAR2 (30)
United States standard general ledger transaction code.
GOVERNMENT_CONTEXT VARCHAR2 (30)
USSGL descriptive flexfield context column
PO_DISTRIBUTION_ID NUMBER

Document distribution unique identifier.
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).
PO_HEADER_ID NUMBER

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

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)
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.
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 (received but not yet billed).
ENCUMBERED_FLAG VARCHAR2 (1)
Distribution encumbered flag
ENCUMBERED_AMOUNT NUMBER

Indicates whether the distribution was accrued (received but not yet billed).
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
KANBAN_CARD_ID NUMBER

Primary key for the Kanban Card
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
Project Manufacturing end item unit number
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: Concatenated string 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

Nonrecoverable tax amoun
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 for service line types
AMOUNT_DELIVERED NUMBER

amount delivered for services
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

CHANGE_STATUS VARCHAR2 (30)
Change Status
UDA_TEMPLATE_ID NUMBER

PARTIAL_FUNDED_FLAG VARCHAR2 (1)
FUNDED_VALUE NUMBER

QUANTITY_FUNDED NUMBER

AMOUNT_FUNDED NUMBER

CLM_MISC_LOA VARCHAR2 (200)
CLM_DEFENCE_FUNDING VARCHAR2 (10)
CLM_FMS_CASE_NUMBER VARCHAR2 (200)
CLM_AGENCY_ACCT_IDENTIFIER VARCHAR2 (100)
CHANGE_IN_FUNDED_VALUE NUMBER

OLD_QUANTITY_ORDERED NUMBER

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

COMMENTS VARCHAR2 (2000)
CLM_PAYMENT_SEQUENCE_NUM NUMBER

PAR_DRAFT_ID NUMBER

For a Mod Dist, stores the PAR draft id from which request/fund came
PAR_DISTRIBUTION_ID NUMBER

For a Mod Dist, stores the PAR dist id from which request/fund came
AMOUNT_CHANGED_FLAG VARCHAR2 (1)
Query Text

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


SELECT OWNER_USER_ID
,      OWNER_ROLE
,      STATUS
,      DRAFT_ID
,      CHANGE_ACCEPTED_FLAG
,      DELETE_FLAG
,      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
,      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
,      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
,      KANBAN_CARD_ID
,      END_ITEM_UNIT_NUMBER
,      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
,      TAX_ATTRIBUTE_UPDATE_CODE
,      GROUP_LINE_ID
,      CHANGE_STATUS
,      UDA_TEMPLATE_ID
,      PARTIAL_FUNDED_FLAG
,      FUNDED_VALUE
,      QUANTITY_FUNDED
,      AMOUNT_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
,      COMMENTS
,      CLM_PAYMENT_SEQUENCE_NUM
,      PAR_DRAFT_ID
,      PAR_DISTRIBUTION_ID
,      AMOUNT_CHANGED_FLAG
FROM APPS.PO_DISTRIBUTIONS_MERGE_V;

Dependencies

[top of page]

APPS.PO_DISTRIBUTIONS_MERGE_V references the following:

SchemaAPPS
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_DISTRIBUTIONS_DRAFT_ALL
SynonymPO_DRAFTS
APPS.PO_DISTRIBUTIONS_MERGE_V is referenced by following:

SchemaAPPS
Package BodyPO_ACCOUNT_HELPER - show dependent code
Package BodyPO_AME_SETUP_PVT - show dependent code
Package BodyPO_AUTOCREATE_POSTPROC_PVT - show dependent code
Package BodyPO_AUTO_DIST_PROCESS_PVT - show dependent code
Package BodyPO_CORE_S - show dependent code
Package BodyPO_DATATEMPLATE_PKG - show dependent code
Package BodyPO_DOCUMENT_CHECKS_PVT - show dependent code
Package BodyPO_DOCUMENT_FUNDS_PVT - show dependent code
Package BodyPO_DOCUMENT_TOTALS_PVT - show dependent code
Package BodyPO_EDA_DATATEMPLATE_PKG - show dependent code
Package BodyPO_LINK_REQ_DIST_PVT - show dependent code
Package BodyPO_PARTIAL_FUNDING_PKG - show dependent code
Package BodyPO_POAPPROVAL_INIT1 - show dependent code
Package BodyPO_SGD_PKG - show dependent code
Package BodyPO_VALIDATION_HELPER - show dependent code
Package BodyPO_VAL_DISTRIBUTIONS - show dependent code