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

VIEW: APPS.PA_PROJ_APPR_REQ_DISTRIBUTIONS

Object Details
Object Name: PA_PROJ_APPR_REQ_DISTRIBUTIONS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_PROJ_APPR_REQ_DISTRIBUTIONS
Subobject Name:
Status: VALID

View Type

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


PA_PROJ_APPR_REQ_DISTRIBUTIONS is a view that shows all approved and unpurchased project related requisition distributions.


[View Source]

Columns
Name Datatype Length Mandatory Comments
REQ_NUMBER VARCHAR2 (20) Yes Refer to base table
DOCUMENT_TYPE VARCHAR2 (80) Yes Refer to base table
REQ_LINE NUMBER
Yes Refer to base table
ITEM_DESCRIPTION VARCHAR2 (240) Yes Refer to base table
NEED_BY_DATE DATE

Refer to base table
CREATION_DATE DATE

Standard Who Column
VENDOR_NAME VARCHAR2 (240)
Refer to base table
VENDOR_ID NUMBER

Refer to base table
REQUESTOR_PERSON_ID NUMBER (10) Yes Refer to base table
REQUESTOR_NAME VARCHAR2 (240)
Refer to base table
UNIT VARCHAR2 (25)
Refer to base table
UNIT_PRICE NUMBER

Refer to base table
QUANTITY NUMBER

Refer to base table
DENOM_CURRENCY_CODE VARCHAR2 (15)
Refer to base table
DENOM_AMOUNT NUMBER

Refer to base table
ACCT_CURRENCY_CODE VARCHAR2 (15) Yes Refer to base table
AMOUNT NUMBER

Refer to base table
ACCT_RATE_DATE DATE

Refer to base table
ACCT_RATE_TYPE VARCHAR2 (30)
Refer to base table
ACCT_EXCHANGE_RATE NUMBER

Refer to base table
PROJECT_NUMBER VARCHAR2 (25) Yes Refer to base table
PROJECT_NAME VARCHAR2 (30) Yes Refer to base table
TASK_NUMBER VARCHAR2 (25) Yes Refer to base table
TASK_NAME VARCHAR2 (20) Yes Refer to base table
EXPENDITURE_TYPE VARCHAR2 (30)
Refer to base table
EXPENDITURE_CATEGORY VARCHAR2 (30) Yes Refer to base table
REVENUE_CATEGORY VARCHAR2 (30) Yes Refer to base table
EXPENDITURE_ITEM_DATE DATE

Refer to base table
EXPENDITURE_ORGANIZATION VARCHAR2 (240) Yes Refer to base table
REQUISITION_HEADER_ID NUMBER
Yes Refer to base table
REQUISITION_LINE_ID NUMBER
Yes Refer to base table
REQ_DISTRIBUTION_ID NUMBER
Yes Refer to base table
PROJECT_ID NUMBER (15) Yes Refer to base table
TASK_ID NUMBER (15) Yes Refer to base table
EXPENDITURE_ORGANIZATION_ID NUMBER (15) Yes Refer to base table
Query Text

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


SELECT REQ_NUMBER
,      DOCUMENT_TYPE
,      REQ_LINE
,      ITEM_DESCRIPTION
,      NEED_BY_DATE
,      CREATION_DATE
,      VENDOR_NAME
,      VENDOR_ID
,      REQUESTOR_PERSON_ID
,      REQUESTOR_NAME
,      UNIT
,      UNIT_PRICE
,      QUANTITY
,      DENOM_CURRENCY_CODE
,      DENOM_AMOUNT
,      ACCT_CURRENCY_CODE
,      AMOUNT
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      PROJECT_NUMBER
,      PROJECT_NAME
,      TASK_NUMBER
,      TASK_NAME
,      EXPENDITURE_TYPE
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_ORGANIZATION
,      REQUISITION_HEADER_ID
,      REQUISITION_LINE_ID
,      REQ_DISTRIBUTION_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_ORGANIZATION_ID
FROM APPS.PA_PROJ_APPR_REQ_DISTRIBUTIONS;

Dependencies

[top of page]

APPS.PA_PROJ_APPR_REQ_DISTRIBUTIONS references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
PL/SQL PackagePA_MULTI_CURRENCY - show dependent code
ViewPA_PROJ_REQ_DISTRIBUTIONS
PL/SQL PackagePA_TASK_UTILS - show dependent code
PL/SQL PackagePA_UTILS4 - show dependent code
APPS.PA_PROJ_APPR_REQ_DISTRIBUTIONS is referenced by following:

SchemaAPPS
ViewPA_PROJ_COMMITMENT_BASE_VIEW