eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PA_PROJ_PO_DISTRIBUTIONS

Object Details

Object Name:	PA_PROJ_PO_DISTRIBUTIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PROJ_PO_DISTRIBUTIONS
Subobject Name:
Status:	VALID

View Type

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

View for project-related uninvoiced purchase order distributions. The non-recoverable tax is added to the amount outstanding invoice values.

[View Source]

Columns

Name	Datatype	Length	Comments
PO_NUMBER	VARCHAR2	(20)	Purchase Order number
PO_REVISION	NUMBER		Document revision number
RELEASE_NUMBER	NUMBER		Release number
RELEASE_REVISION	NUMBER		Release revision number
APPROVED_FLAG	VARCHAR2	(1)	Approved Flag
EVER_APPROVED_FLAG	VARCHAR2	(1)	Ever Approved Flag
DOCUMENT_TYPE	VARCHAR2	(80)	Document type name
CREATION_DATE	DATE		Standard Who Column
APPROVED_DATE	DATE		Approved Date
PRINTED_DATE	DATE		Printed Date
REQUESTOR_PERSON_ID	NUMBER	(10)	System generated unique identifier for the requestor
REQUESTOR_NAME	VARCHAR2	(240)	Requestor Name
BUYER_PERSON_ID	NUMBER	(10)	System generated unique identifier for the buyer
BUYER_NAME	VARCHAR2	(240)	Buyer Name
VENDOR_NAME	VARCHAR2	(240)	Supplier name
VENDOR_ID	NUMBER		Supplier unique identifier
PO_LINE	NUMBER		Purchase Order Line number
ITEM_DESCRIPTION	VARCHAR2	(240)	Item description
UNIT	VARCHAR2	(25)	Unit
UNIT_PRICE	NUMBER		Unit Price
QUANTITY_ORDERED	NUMBER		Quantity Ordered
AMOUNT_ORDERED	NUMBER		Amount Ordered
ORIGINAL_QUANTITY_ORDERED	NUMBER		Quantity ordered on the distribution
ORIGINAL_AMOUNT_ORDERED	NUMBER		Original Amount Ordered
QUANTITY_CANCELLED	NUMBER		Quantity cancelled for the distribution
AMOUNT_CANCELLED	NUMBER		Amount Cancelled
QUANTITY_DELIVERED	NUMBER		Quantity delivered against the distribution
DENOM_AMOUNT_DELIVERED	NUMBER		Transaction Amount Delivered
AMOUNT_DELIVERED	NUMBER		Amount Delivered
QUANTITY_INVOICED	NUMBER		Quantity invoiced by Oracle Payables against the distribution
AMOUNT_INVOICED	NUMBER		Amount invoiced by Oracle Payables against the distribution
QUANTITY_OUTSTANDING_DELIVERY	NUMBER		Outstanding Delivery Quantity
AMOUNT_OUTSTANDING_DELIVERY	NUMBER		Outstanding Delivery amount
QUANTITY_OUTSTANDING_INVOICE	NUMBER		Outstanding Invoice Quantity
DENOM_CURRENCY_CODE	VARCHAR2	(15)	Transaction currency code
DENOM_AMT_OUTSTANDING_INVOICE	NUMBER		Outstanding Invoice Transaction amount
ACCT_CURRENCY_CODE	VARCHAR2	(15)	Functional Currency code
AMOUNT_OUTSTANDING_INVOICE	NUMBER		Amount Outstanding Delivery
ACCT_RATE_DATE	DATE		Functional Rate Date
ACCT_RATE_TYPE	VARCHAR2	(30)	Functional Rate Type
ACCT_EXCHANGE_RATE	NUMBER		Functional Exchange Rate
QUANTITY_OVERBILLED	NUMBER		Quantity Overbilled
AMOUNT_OVERBILLED	NUMBER		Amount Overbilled
PROJECT_NUMBER	VARCHAR2	(25)	The project number that uniquely identifies the project
PROJECT_NAME	VARCHAR2	(30)	User-defined name that uniquely identifies the project
TASK_NUMBER	VARCHAR2	(25)	User-defined number that uniquely identifies the task within a project
TASK_NAME	VARCHAR2	(20)	User-defined short name of the task
EXPENDITURE_TYPE	VARCHAR2	(30)	Project accounting expenditure type
EXPENDITURE_CATEGORY	VARCHAR2	(30)	Expenditure Category
REVENUE_CATEGORY	VARCHAR2	(30)	Revenue Category
EXPENDITURE_ITEM_DATE	DATE		Project accounting expenditure item date
EXPENDITURE_ORGANIZATION	VARCHAR2	(240)	Expenditure Organization
PO_HEADER_ID	NUMBER		Document header unique identifier
PO_RELEASE_ID	NUMBER		Release unique identifier
PO_LINE_ID	NUMBER		Document line unique identifier
PO_LINE_LOCATION_ID	NUMBER		Document shipment schedule unique identifier
PO_DISTRIBUTION_ID	NUMBER		Document distribution unique identifier
PROJECT_ID	NUMBER	(15)	The system-generated number that uniquely identifies the project
TASK_ID	NUMBER	(15)	The system-generated number that uniquely identifies the task.
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)	Identifier of the expenditrue organization
PROMISED_DATE	DATE		Promised delivery date for commitment.
NEED_BY_DATE	DATE		Date that commitment is needed by.
CMT_QTY	NUMBER		Commitment Quantity
DENOM_RAW_COST	NUMBER		Transaction Raw Cost
ACCT_RAW_COST	NUMBER		Functional Raw Cost
RESOURCE_CLASS	VARCHAR2	(18)	Resource Class
ORG_ID	NUMBER		Operating unit identifier for multi-organization installations
AWARD_SET_ID	NUMBER	(15)	Award Distribution Identifer for Grants Accounting
CBS_ELEMENT_ID	NUMBER

Query Text

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


SELECT PO_NUMBER
,      PO_REVISION
,      RELEASE_NUMBER
,      RELEASE_REVISION
,      APPROVED_FLAG
,      EVER_APPROVED_FLAG
,      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
,      DENOM_AMOUNT_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
,      PROMISED_DATE
,      NEED_BY_DATE
,      CMT_QTY
,      DENOM_RAW_COST
,      ACCT_RAW_COST
,      RESOURCE_CLASS
,      ORG_ID
,      AWARD_SET_ID
,      CBS_ELEMENT_ID
FROM APPS.PA_PROJ_PO_DISTRIBUTIONS;

Dependencies

[top of page]

APPS.PA_PROJ_PO_DISTRIBUTIONS references the following:

APPS: FND_PROFILE - show dependent code; GL_LEDGERS; HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code; PA_CMT_UTILS - show dependent code; PA_CURRENCY - show dependent code; PA_EXPENDITURE_TYPES; PA_FUNDS_CONTROL_UTILS - show dependent code; PA_MULTI_CURRENCY - show dependent code; PA_PJC_CWK_UTILS - show dependent code; PA_PROJECTS_ALL; PA_TASKS; PA_TASKS_EXPEND_V; PA_TASK_UTILS - show dependent code; PA_UTILS4 - show dependent code; PER_ALL_PEOPLE_F; PO_DISTRIBUTIONS_ALL; PO_DOCUMENT_TYPES_ALL_TL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_LINE_TYPES; PO_RELEASES_ALL; PO_VENDORS

APPS.PA_PROJ_PO_DISTRIBUTIONS is referenced by following:

APPS: GMS_COMMITMENTS_OVERRIDE_V; GMS_PA_API3 - show dependent code; PA_COMMITMENT_TXNS_V; PA_PO_INTEGRATION_UTILS - show dependent code; PA_PROJ_APPR_PO_DISTRIBUTIONS; PA_PROJ_PEND_PO_DISTRIBUTIONS