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	Mandatory	Comments
PO_NUMBER	VARCHAR2	(20)	Yes	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)	Yes	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)	Yes	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		Yes	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)	Yes	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)	Yes	The project number that uniquely identifies the project
PROJECT_NAME	VARCHAR2	(30)	Yes	User-defined name that uniquely identifies the project
TASK_NUMBER	VARCHAR2	(25)	Yes	User-defined number that uniquely identifies the task within a project
TASK_NAME	VARCHAR2	(20)	Yes	User-defined short name of the task
EXPENDITURE_TYPE	VARCHAR2	(30)		Project accounting expenditure type
EXPENDITURE_CATEGORY	VARCHAR2	(30)	Yes	Expenditure Category
REVENUE_CATEGORY	VARCHAR2	(30)	Yes	Revenue Category
EXPENDITURE_ITEM_DATE	DATE			Project accounting expenditure item date
EXPENDITURE_ORGANIZATION	VARCHAR2	(240)	Yes	Expenditure Organization
PO_HEADER_ID	NUMBER		Yes	Document header unique identifier
PO_RELEASE_ID	NUMBER			Release unique identifier
PO_LINE_ID	NUMBER		Yes	Document line unique identifier
PO_LINE_LOCATION_ID	NUMBER		Yes	Document shipment schedule unique identifier
PO_DISTRIBUTION_ID	NUMBER		Yes	Document distribution unique identifier
PROJECT_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the project
TASK_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the task.
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)	Yes	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

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
FROM APPS.PA_PROJ_PO_DISTRIBUTIONS;

Dependencies

[top of page]

APPS.PA_PROJ_PO_DISTRIBUTIONS references the following:

APPS: 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_MULTI_CURRENCY - show dependent code; PA_PJC_CWK_UTILS - show dependent code; PA_PROJECTS_ALL; PA_TASKS; 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_COMMITMENTS_V; PA_COMMITMENT_TXNS_V; PA_PROJ_APPR_PO_DISTRIBUTIONS; PA_PROJ_PEND_PO_DISTRIBUTIONS