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

VIEW: APPS.PO_DISTRIBUTIONS_AP_V

Object Details
Object Name: PO_DISTRIBUTIONS_AP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_DISTRIBUTIONS_AP_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
PO_DISTRIBUTION_ID NUMBER
Yes Document distribution unique identifier
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
PO_LINE_ID NUMBER

Document line unique identifier
LINE_LOCATION_ID NUMBER

Document shipment schedule unique identifier
SET_OF_BOOKS_ID NUMBER
Yes Set of Books unique identifier
CODE_COMBINATION_ID NUMBER

GL charge account unique identifier
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)
Requisition number of the requisition line placed on this distribution
REQ_LINE_REFERENCE_NUM VARCHAR2 (25)
Line number of the requisition line placed on the distribution
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 requestor
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 or not
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)
Describes the 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
ORIGINAL_CHARGE_ACCOUNT_ID NUMBER

GL charge account unique identifier
BUDGET_ACCOUNT_ID NUMBER

GL budget account unique identifier
ACCRUAL_ACCOUNT_ID NUMBER

GL accrual account unique identifier
VARIANCE_ACCOUNT_ID NUMBER

GL variance account unique identifier
DESTINATION_CONTEXT VARCHAR2 (30)
Destination details protected descriptive flexfield context column
SOURCE_DISTRIBUTION_ID NUMBER

Unique identifier of the planned purchase order distribution that was referenced when creating this scheduled release distribution
DISTRIBUTION_NUM NUMBER
Yes Distribution number
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).
GOVERNMENT_CONTEXT VARCHAR2 (30)
USSGL descriptive flexfield context column
REVERSE_ENCUMBRANCE_FLAG VARCHAR2 (1)
Indicates whether distribution should be encumbered
USSGL_TRANSACTION_CODE VARCHAR2 (30)
United States standard general ledger transaction code
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
EXPENDITURE_ITEM_DATE DATE

Project Accounting expenditure item date
ACCRUE_ON_RECEIPT_FLAG VARCHAR2 (1)
Indicates whether items are accrued on receipt
AWARD_ID NUMBER (15)
AMOUNT_ORDERED NUMBER

Amount ordered on distributions
AMOUNT_DELIVERED NUMBER

amount delivered on distributions
AMOUNT_CANCELLED NUMBER

Amount Cancelled on distributions
INVOICE_ADJUSTMENT_FLAG VARCHAR2 (1)
Flag to indicate invoice adjustment
RECOVERY_RATE NUMBER

ORG_ID NUMBER

Organization identifier
DISTRIBUTION_TYPE VARCHAR2 (25)
Identifies the type of distribution
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
Query Text

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


SELECT 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
,      ORIGINAL_CHARGE_ACCOUNT_ID
,      BUDGET_ACCOUNT_ID
,      ACCRUAL_ACCOUNT_ID
,      VARIANCE_ACCOUNT_ID
,      DESTINATION_CONTEXT
,      SOURCE_DISTRIBUTION_ID
,      DISTRIBUTION_NUM
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      GOVERNMENT_CONTEXT
,      REVERSE_ENCUMBRANCE_FLAG
,      USSGL_TRANSACTION_CODE
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      PROJECT_ACCOUNTING_CONTEXT
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ITEM_DATE
,      ACCRUE_ON_RECEIPT_FLAG
,      AWARD_ID
,      AMOUNT_ORDERED
,      AMOUNT_DELIVERED
,      AMOUNT_CANCELLED
,      INVOICE_ADJUSTMENT_FLAG
,      RECOVERY_RATE
,      ORG_ID
,      DISTRIBUTION_TYPE
,      QUANTITY_FINANCED
,      AMOUNT_FINANCED
,      QUANTITY_RECOUPED
,      AMOUNT_RECOUPED
,      RETAINAGE_WITHHELD_AMOUNT
,      RETAINAGE_RELEASED_AMOUNT
FROM APPS.PO_DISTRIBUTIONS_AP_V;

Dependencies

[top of page]

APPS.PO_DISTRIBUTIONS_AP_V references the following:

SchemaAPPS
SynonymPO_DISTRIBUTIONS
APPS.PO_DISTRIBUTIONS_AP_V is referenced by following:

SchemaAPPS
Package BodyAP_APPROVAL_MATCHED_PKG - show dependent code
Package BodyAP_AUTO_DM_CREATION_PKG - show dependent code
Package BodyAP_CANCEL_PKG - show dependent code
Package BodyAP_IMPORT_UTILITIES_PKG - show dependent code
Package BodyAP_MATCHING_PKG - show dependent code
Package BodyAP_MATCHING_UTILS_PKG - show dependent code
Package BodyAP_PO_AMT_MATCH_PKG - show dependent code
Package BodyAP_PPA_PKG - show dependent code
Package BodyAP_RCT_AMT_MATCH_PKG - show dependent code
Package BodyAP_RECT_MATCH_PKG - show dependent code
Package BodyAP_RECURRING_INVOICES_PKG - show dependent code
Package BodyICX_AP_INVOICES_PKG - show dependent code
ViewICX_AP_INVOICES_V
Package BodyPO_INVOICES_SV2 - show dependent code