[Home] [Help] [Dependency Information]
Object Name: | PA_PROJ_APPR_PO_DISTRIBUTIONS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_PROJ_APPR_PO_DISTRIBUTIONS |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PO_NUMBER | VARCHAR2 | (20) | 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) | 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) | 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 | 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) | 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) | Refer to base table | |
PROJECT_NAME | VARCHAR2 | (30) | Refer to base table | |
TASK_NUMBER | VARCHAR2 | (25) | Refer to base table | |
TASK_NAME | VARCHAR2 | (20) | Refer to base table | |
EXPENDITURE_TYPE | VARCHAR2 | (30) | Refer to base table | |
EXPENDITURE_CATEGORY | VARCHAR2 | (30) | Refer to base table | |
REVENUE_CATEGORY | VARCHAR2 | (30) | Refer to base table | |
EXPENDITURE_ITEM_DATE | DATE | Refer to base table | ||
EXPENDITURE_ORGANIZATION | VARCHAR2 | (240) | Refer to base table | |
PO_HEADER_ID | NUMBER | Refer to base table | ||
PO_RELEASE_ID | NUMBER | Refer to base table | ||
PO_LINE_ID | NUMBER | Refer to base table | ||
PO_LINE_LOCATION_ID | NUMBER | Refer to base table | ||
PO_DISTRIBUTION_ID | NUMBER | Refer to base table | ||
PROJECT_ID | NUMBER | (15) | Refer to base table | |
TASK_ID | NUMBER | (15) | Refer to base table | |
EXPENDITURE_ORGANIZATION_ID | NUMBER | (15) | Refer to base table |
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;
|
|
|