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

VIEW: APPS.PA_PROJ_APPR_PO_DISTRIBUTIONS

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

View Type

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


PA_PROJ_APPR_PO_DISTRIBUTIONS is a view that shows all approved and uninvoiced project related purchase order distributions.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PO_NUMBER VARCHAR2 (20) Yes Refer to base table
PO_REVISION NUMBER

Refer to base table
RELEASE_NUMBER NUMBER

Refer to base table
RELEASE_REVISION NUMBER

Refer to base table
DOCUMENT_TYPE VARCHAR2 (80) Yes Refer to base table
CREATION_DATE DATE

Standard Who Column
APPROVED_DATE DATE

Refer to base table
PRINTED_DATE DATE

Refer to base table
REQUESTOR_PERSON_ID NUMBER (10)
Refer to base table
REQUESTOR_NAME VARCHAR2 (240)
Refer to base table
BUYER_PERSON_ID NUMBER (10) Yes Refer to base table
BUYER_NAME VARCHAR2 (240)
Refer to base table
VENDOR_NAME VARCHAR2 (240)
Refer to base table
VENDOR_ID NUMBER

Refer to base table
PO_LINE NUMBER
Yes Refer to base table
ITEM_DESCRIPTION VARCHAR2 (240)
Refer to base table
UNIT VARCHAR2 (25)
Refer to base table
UNIT_PRICE NUMBER

Refer to base table
QUANTITY_ORDERED NUMBER

Refer to base table
AMOUNT_ORDERED NUMBER

Refer to base table
ORIGINAL_QUANTITY_ORDERED NUMBER

Refer to base table
ORIGINAL_AMOUNT_ORDERED NUMBER

Refer to base table
QUANTITY_CANCELLED NUMBER

Refer to base table
AMOUNT_CANCELLED NUMBER

Refer to base table
QUANTITY_DELIVERED NUMBER

Refer to base table
AMOUNT_DELIVERED NUMBER

Refer to base table
QUANTITY_INVOICED NUMBER

Refer to base table
AMOUNT_INVOICED NUMBER

Refer to base table
QUANTITY_OUTSTANDING_DELIVERY NUMBER

Refer to base table
AMOUNT_OUTSTANDING_DELIVERY NUMBER

Refer to base table
QUANTITY_OUTSTANDING_INVOICE NUMBER

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

Refer to base table
ACCT_CURRENCY_CODE VARCHAR2 (15) Yes Refer to base table
AMOUNT_OUTSTANDING_INVOICE 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
QUANTITY_OVERBILLED NUMBER

Refer to base table
AMOUNT_OVERBILLED 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
PO_HEADER_ID NUMBER
Yes Refer to base table
PO_RELEASE_ID NUMBER

Refer to base table
PO_LINE_ID NUMBER
Yes Refer to base table
PO_LINE_LOCATION_ID NUMBER
Yes Refer to base table
PO_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 PO_NUMBER
,      PO_REVISION
,      RELEASE_NUMBER
,      RELEASE_REVISION
,      DOCUMENT_TYPE
,      CREATION_DATE
,      APPROVED_DATE
,      PRINTED_DATE
,      REQUESTOR_PERSON_ID
,      REQUESTOR_NAME
,      BUYER_PERSON_ID
,      BUYER_NAME
,      VENDOR_NAME
,      VENDOR_ID
,      PO_LINE
,      ITEM_DESCRIPTION
,      UNIT
,      UNIT_PRICE
,      QUANTITY_ORDERED
,      AMOUNT_ORDERED
,      ORIGINAL_QUANTITY_ORDERED
,      ORIGINAL_AMOUNT_ORDERED
,      QUANTITY_CANCELLED
,      AMOUNT_CANCELLED
,      QUANTITY_DELIVERED
,      AMOUNT_DELIVERED
,      QUANTITY_INVOICED
,      AMOUNT_INVOICED
,      QUANTITY_OUTSTANDING_DELIVERY
,      AMOUNT_OUTSTANDING_DELIVERY
,      QUANTITY_OUTSTANDING_INVOICE
,      DENOM_CURRENCY_CODE
,      DENOM_AMT_OUTSTANDING_INVOICE
,      ACCT_CURRENCY_CODE
,      AMOUNT_OUTSTANDING_INVOICE
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      QUANTITY_OVERBILLED
,      AMOUNT_OVERBILLED
,      PROJECT_NUMBER
,      PROJECT_NAME
,      TASK_NUMBER
,      TASK_NAME
,      EXPENDITURE_TYPE
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_ORGANIZATION
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_ORGANIZATION_ID
FROM APPS.PA_PROJ_APPR_PO_DISTRIBUTIONS;

Dependencies

[top of page]

APPS.PA_PROJ_APPR_PO_DISTRIBUTIONS references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
PL/SQL PackagePA_CMT_UTILS - show dependent code
PL/SQL PackagePA_CURRENCY - show dependent code
PL/SQL PackagePA_MULTI_CURRENCY - show dependent code
PL/SQL PackagePA_PJC_CWK_UTILS - show dependent code
ViewPA_PROJ_PO_DISTRIBUTIONS
APPS.PA_PROJ_APPR_PO_DISTRIBUTIONS is referenced by following:

SchemaAPPS
ViewPA_PROJ_COMMITMENT_BASE_VIEW