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

VIEW: APPS.POS_DISTRIBUTIONS_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


POS_DISTRIBUTIONS_V is the view used to select the detailed info for distributions


[View Source]

Columns
Name Datatype Length Mandatory Comments
PO_DISTRIBUTION_ID NUMBER
Yes PO distribution Identifier
LAST_UPDATE_DATE DATE
Yes Last Update Date
LAST_UPDATED_BY NUMBER
Yes Last Update By Person Name
PO_HEADER_ID NUMBER
Yes PO Header Identifier
PO_LINE_ID NUMBER

PO Line Identifier
LINE_LOCATION_ID NUMBER

Line Location Identifier
SET_OF_BOOKS_ID NUMBER
Yes Set of Books Identifier
CODE_COMBINATION_ID NUMBER

Code Combination Identifier
QUANTITY_ORDERED NUMBER

Quantity Ordered
LAST_UPDATE_LOGIN NUMBER

Last Update Login
CREATION_DATE DATE

Creation Date
CREATED_BY NUMBER

Created By Person Name
PO_RELEASE_ID NUMBER

PO Release Identifier
QUANTITY_DELIVERED NUMBER

Quantity Delivered
QUANTITY_BILLED NUMBER

Quantity Billed
QUANTITY_CANCELLED NUMBER

Quantity Cancelled
REQ_HEADER_REFERENCE_NUM VARCHAR2 (25)
Req Header Reference Number
REQ_LINE_REFERENCE_NUM VARCHAR2 (25)
Req Line Reference Number
REQ_DISTRIBUTION_ID NUMBER

Req Distribution Identifier
DELIVER_TO_LOCATION_ID NUMBER

Deliver To Location Identifier
DELIVER_TO_PERSON_ID NUMBER (9)
Deliver To Person Identifier
RATE_DATE DATE

Rate Date
RATE NUMBER

Rate
AMOUNT_BILLED NUMBER

Amount Billed
ACCRUED_FLAG VARCHAR2 (1)
Accrued Flag
ENCUMBERED_FLAG VARCHAR2 (1)
Encumbered Flag
ENCUMBERED_AMOUNT NUMBER

Encumbered Amount
UNENCUMBERED_QUANTITY NUMBER

unencumbered quantity
UNENCUMBERED_AMOUNT NUMBER

unencumbered amount
FAILED_FUNDS_LOOKUP_CODE VARCHAR2 (25)
Failed FUNDS LookUp Code
GL_ENCUMBERED_DATE DATE

GL Encumbered Date
GL_ENCUMBERED_PERIOD_NAME VARCHAR2 (15)
GL Encumbered Period Name
GL_CANCELLED_DATE DATE

GL Cancelled Date
DESTINATION_TYPE_CODE VARCHAR2 (25)
Destination type Code
DESTINATION_ORGANIZATION_ID NUMBER

Destination Organization Identifier
DESTINATION_SUBINVENTORY VARCHAR2 (10)
Destination SubInventoy
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute category
ATTRIBUTE1 VARCHAR2 (150)
flexfield 1
ATTRIBUTE2 VARCHAR2 (150)
flexfield 2
ATTRIBUTE3 VARCHAR2 (150)
flexfield 3
ATTRIBUTE4 VARCHAR2 (150)
flexfield 4
ATTRIBUTE5 VARCHAR2 (150)
flexfield 5
ATTRIBUTE6 VARCHAR2 (150)
flexfield 6
ATTRIBUTE7 VARCHAR2 (150)
flexfield 7
ATTRIBUTE8 VARCHAR2 (150)
flexfield 8
ATTRIBUTE9 VARCHAR2 (150)
flexfield 9
ATTRIBUTE10 VARCHAR2 (150)
flexfield 10
ATTRIBUTE11 VARCHAR2 (150)
flexfield 11
ATTRIBUTE12 VARCHAR2 (150)
flexfield 12
ATTRIBUTE13 VARCHAR2 (150)
flexfield 13
ATTRIBUTE14 VARCHAR2 (150)
flexfield 14
ATTRIBUTE15 VARCHAR2 (150)
flexfield 15
WIP_ENTITY_ID NUMBER

Work In Process Id
WIP_OPERATION_SEQ_NUM NUMBER

Work In Process Operation Sequence Number
WIP_RESOURCE_SEQ_NUM NUMBER

Work In Process Resource Sequence Number
WIP_REPETITIVE_SCHEDULE_ID NUMBER

Work In Process Repetitive Schedule Identifier
WIP_LINE_ID NUMBER

Work In Process Line Identifier
BOM_RESOURCE_ID NUMBER

Bill Of Materials Resource Identifier
ORIGINAL_CHARGE_ACCOUNT_ID NUMBER

Original Charge Account Identifier
BUDGET_ACCOUNT_ID NUMBER

Budget Account Identifier
ACCRUAL_ACCOUNT_ID NUMBER

Accrual Account Identifier
VARIANCE_ACCOUNT_ID NUMBER

Variance Account Identifier
DESTINATION_CONTEXT VARCHAR2 (30)
Destination Context
SOURCE_DISTRIBUTION_ID NUMBER

Source Distribution Identifier
DISTRIBUTION_NUM NUMBER
Yes Distribution Number
REQUEST_ID NUMBER

Request Identifier
PROGRAM_APPLICATION_ID NUMBER

Progarm Application Identifier
PROGRAM_ID NUMBER

Program Identifier
PROGRAM_UPDATE_DATE DATE

Program Update Date
GOVERNMENT_CONTEXT VARCHAR2 (30)
Government Context
REVERSE_ENCUMBRANCE_FLAG VARCHAR2 (1)
Reverse Encumbrance Flag
USSGL_TRANSACTION_CODE VARCHAR2 (30)
USSGL Transaction Code
PROJECT_ID NUMBER

Project Identifier
TASK_ID NUMBER

Task Identifier
EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure Type
PROJECT_ACCOUNTING_CONTEXT VARCHAR2 (30)
Project Accounting Context
EXPENDITURE_ORGANIZATION_ID NUMBER

Expenditure Organization Identifier
EXPENDITURE_ITEM_DATE DATE

Expenditure Item Date
ACCRUE_ON_RECEIPT_FLAG VARCHAR2 (1)
Accrue on Receipt Flag
AWARD_ID NUMBER (15)
Award Identifier
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
FROM APPS.POS_DISTRIBUTIONS_V;

Dependencies

[top of page]

APPS.POS_DISTRIBUTIONS_V references the following:

SchemaAPPS
SynonymPO_DISTRIBUTIONS_ALL

APPS.POS_DISTRIBUTIONS_V is not referenced by any database object