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

VIEW: APPS.AP_PO_DISTRIBUTIONS_AP2_V

Object Details
Object Name: AP_PO_DISTRIBUTIONS_AP2_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLAP.AP_PO_DISTRIBUTIONS_AP2_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
ROW_ID ROWID (10)
ACCRUAL_ACCOUNT_ID NUMBER

ACCRUED_FLAG VARCHAR2 (1)
ACCRUE_ON_RECEIPT_FLAG VARCHAR2 (1)
AMOUNT_BILLED NUMBER

ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
BOM_RESOURCE_ID NUMBER

BUDGET_ACCOUNT_ID NUMBER

CODE_COMBINATION_ID NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

DELIVER_TO_LOCATION_ID NUMBER

DELIVER_TO_PERSON_ID NUMBER (9)
DESTINATION_CONTEXT VARCHAR2 (30)
DESTINATION_ORGANIZATION_ID NUMBER

DESTINATION_SUBINVENTORY VARCHAR2 (10)
DESTINATION_TYPE_CODE VARCHAR2 (25)
DISTRIBUTION_NUM NUMBER
Yes
ENCUMBERED_AMOUNT NUMBER

ENCUMBERED_FLAG VARCHAR2 (1)
EXPENDITURE_ITEM_DATE DATE

EXPENDITURE_ORGANIZATION_ID NUMBER

EXPENDITURE_ORGANIZATION VARCHAR2 (240)
EXPENDITURE_TYPE VARCHAR2 (30)
FAILED_FUNDS_LOOKUP_CODE VARCHAR2 (25)
GL_CANCELLED_DATE DATE

GL_CLOSED_DATE DATE

GL_ENCUMBERED_DATE DATE

GL_ENCUMBERED_PERIOD_NAME VARCHAR2 (15)
GOVERNMENT_CONTEXT VARCHAR2 (30)
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

LINE_LOCATION_ID NUMBER

ORG_ID NUMBER

PO_DISTRIBUTION_ID NUMBER
Yes
PO_HEADER_ID NUMBER
Yes
PO_LINE_ID NUMBER

PO_RELEASE_ID NUMBER

PREVENT_ENCUMBRANCE_FLAG VARCHAR2 (1)
PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

PROJECT_ACCOUNTING_CONTEXT VARCHAR2 (30)
PROJECT_ID NUMBER

PROJECT_NAME VARCHAR2 (25)
QUANTITY_BILLED NUMBER

QUANTITY_CANCELLED NUMBER

QUANTITY_DELIVERED NUMBER

QUANTITY_ORDERED NUMBER

RATE NUMBER

RATE_DATE DATE

REQUEST_ID NUMBER

REQ_DISTRIBUTION_ID NUMBER

REQ_HEADER_REFERENCE_NUM VARCHAR2 (25)
REQ_LINE_REFERENCE_NUM VARCHAR2 (25)
SET_OF_BOOKS_ID NUMBER
Yes
SOURCE_DISTRIBUTION_ID NUMBER

TASK_ID NUMBER

TASK_NUMBER VARCHAR2 (278)
TASK_NAME VARCHAR2 (263)
UNENCUMBERED_AMOUNT NUMBER

UNENCUMBERED_QUANTITY NUMBER

VARIANCE_ACCOUNT_ID NUMBER

WIP_ENTITY_ID NUMBER

WIP_LINE_ID NUMBER

WIP_OPERATION_SEQ_NUM NUMBER

WIP_REPETITIVE_SCHEDULE_ID NUMBER

WIP_RESOURCE_SEQ_NUM NUMBER

REQUESTOR VARCHAR2 (240)
AMOUNT_ORDERED NUMBER

AMOUNT_DELIVERED NUMBER

AMOUNT_CANCELLED NUMBER

AMOUNT_FINANCED NUMBER

AMOUNT_RECOUPED NUMBER

QUANTITY_FINANCED NUMBER

QUANTITY_RECOUPED NUMBER

RETAINAGE_WITHHELD_AMOUNT NUMBER

RETAINAGE_RELEASED_AMOUNT NUMBER

DISTRIBUTION_TYPE VARCHAR2 (25)
Query Text

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


SELECT ROW_ID
,      ACCRUAL_ACCOUNT_ID
,      ACCRUED_FLAG
,      ACCRUE_ON_RECEIPT_FLAG
,      AMOUNT_BILLED
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
,      BOM_RESOURCE_ID
,      BUDGET_ACCOUNT_ID
,      CODE_COMBINATION_ID
,      CREATED_BY
,      CREATION_DATE
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_PERSON_ID
,      DESTINATION_CONTEXT
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_SUBINVENTORY
,      DESTINATION_TYPE_CODE
,      DISTRIBUTION_NUM
,      ENCUMBERED_AMOUNT
,      ENCUMBERED_FLAG
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORGANIZATION
,      EXPENDITURE_TYPE
,      FAILED_FUNDS_LOOKUP_CODE
,      GL_CANCELLED_DATE
,      GL_CLOSED_DATE
,      GL_ENCUMBERED_DATE
,      GL_ENCUMBERED_PERIOD_NAME
,      GOVERNMENT_CONTEXT
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LINE_LOCATION_ID
,      ORG_ID
,      PO_DISTRIBUTION_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_RELEASE_ID
,      PREVENT_ENCUMBRANCE_FLAG
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROJECT_ACCOUNTING_CONTEXT
,      PROJECT_ID
,      PROJECT_NAME
,      QUANTITY_BILLED
,      QUANTITY_CANCELLED
,      QUANTITY_DELIVERED
,      QUANTITY_ORDERED
,      RATE
,      RATE_DATE
,      REQUEST_ID
,      REQ_DISTRIBUTION_ID
,      REQ_HEADER_REFERENCE_NUM
,      REQ_LINE_REFERENCE_NUM
,      SET_OF_BOOKS_ID
,      SOURCE_DISTRIBUTION_ID
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      UNENCUMBERED_AMOUNT
,      UNENCUMBERED_QUANTITY
,      VARIANCE_ACCOUNT_ID
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      WIP_OPERATION_SEQ_NUM
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_RESOURCE_SEQ_NUM
,      REQUESTOR
,      AMOUNT_ORDERED
,      AMOUNT_DELIVERED
,      AMOUNT_CANCELLED
,      AMOUNT_FINANCED
,      AMOUNT_RECOUPED
,      QUANTITY_FINANCED
,      QUANTITY_RECOUPED
,      RETAINAGE_WITHHELD_AMOUNT
,      RETAINAGE_RELEASED_AMOUNT
,      DISTRIBUTION_TYPE
FROM APPS.AP_PO_DISTRIBUTIONS_AP2_V;

Dependencies

[top of page]

APPS.AP_PO_DISTRIBUTIONS_AP2_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORG_UNITS_NO_JOIN
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPA_PROJECTS_ALL
ViewPA_TASKS_EXPEND_V
PL/SQL PackagePA_TASK_UTILS - show dependent code
PL/SQL PackagePA_UTILS4 - show dependent code
ViewPER_PEOPLE_F
SynonymPO_DISTRIBUTIONS

APPS.AP_PO_DISTRIBUTIONS_AP2_V is not referenced by any database object