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_V1

Object Details

Object Name:	PA_PROJ_PO_DISTRIBUTIONS_V1
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PO_NUMBER	VARCHAR2	(20)	Yes	The purchase order number
PO_REVISION	NUMBER			Purchase order Revision Number
RELEASE_NUMBER	NUMBER			Purchase order Release Number
RELEASE_REVISION	NUMBER			Purchase order release revision number
APPROVED_FLAG	VARCHAR2	(1)		Indicator if the purchase order is approved: "Y" for approved, "N" for not approved.
EVER_APPROVED_FLAG	VARCHAR2	(1)		Indicates either purchase order or purchase order release or related requisition were ever approved or not.
DOCUMENT_TYPE	VARCHAR2	(80)	Yes	Purchase order document type name
CREATION_DATE	DATE			Date on which purchase order was created.
APPROVED_DATE	DATE			Date on which purchase order was approved.
PRINTED_DATE	DATE			Date on which purchase order was printed.
REQUESTOR_PERSON_ID	NUMBER	(9)		Identifier of the Requestor
REQUESTOR_NAME	VARCHAR2	(240)		The full name of requestor.
BUYER_PERSON_ID	NUMBER	(9)	Yes	Identifier of the Buyer
BUYER_NAME	VARCHAR2	(240)		The full name of buyer.
VENDOR_NAME	VARCHAR2	(240)		Supplier Name.
VENDOR_ID	NUMBER			Identifier of the Supplier.
PO_LINE	NUMBER		Yes	The purchase order line number in which the distribution is included.
ITEM_DESCRIPTION	VARCHAR2	(240)		The description of purchase order line.
UNIT	VARCHAR2	(25)		The Unit Of Measure Code.
UNIT_PRICE	NUMBER			Cost per unit of the project-related commitment distribution.
QUANTITY_ORDERED	NUMBER			Distribution quantity ordered of the purchase order commitment.
AMOUNT_ORDERED	NUMBER			Distribution amount ordered of the purchase order commitment.
ORIGINAL_QUANTITY_ORDERED	NUMBER			Distribution original quantity ordered of the purchase order commitment.
ORIGINAL_AMOUNT_ORDERED	NUMBER			Distribution original amount ordered of the purchase order commitment.
QUANTITY_CANCELLED	NUMBER			Distribution quantity cancelled of the purchase order commitment.
AMOUNT_CANCELLED	NUMBER			Distribution amount cancelled of the purchase order commitment.
QUANTITY_DELIVERED	NUMBER			Distribution quantity delivered of the purchase order commitment.
DENOM_AMOUNT_DELIVERED	NUMBER			The transaction currency raw cost distribution amount delivered of the purchase order commitment.
AMOUNT_DELIVERED	NUMBER			Distribution amount delivered of the purchase order commitment.
QUANTITY_INVOICED	NUMBER			Distribution quantity invoiced of the purchase order commitment.
AMOUNT_INVOICED	NUMBER			Distribution amount invoiced of the purchase order commitment.
QUANTITY_OUTSTANDING_DELIVERY	NUMBER			Distribution quantity outstanding delivery of the purchase order commitment.
AMOUNT_OUTSTANDING_DELIVERY	NUMBER			Distribution amount outstanding delivery of the purchase order commitment.
QUANTITY_OUTSTANDING_INVOICE	NUMBER			Distribution quantity outstanding invoice of the purchase order commitment.
DENOM_CURRENCY_CODE	VARCHAR2	(15)		The transaction currency code.
DENOM_AMT_OUTSTANDING_INVOICE	NUMBER			The transaction currency raw cost amount outstanding invoice of the purchase order commitment.
ACCT_CURRENCY_CODE	VARCHAR2	(15)	Yes	The functional currency code.
AMOUNT_OUTSTANDING_INVOICE	NUMBER			Distribution amount outstanding invoice of the purchase order commitment.
ACCT_RATE_DATE	DATE			The functional currency rate date.
ACCT_RATE_TYPE	VARCHAR2	(30)		The functional currency rate type (such as Spot or Corporate).
ACCT_EXCHANGE_RATE	NUMBER			The functional currency exchange rate.
QUANTITY_OVERBILLED	NUMBER			Distribution quantity overbilled of the purchase order commitment.
AMOUNT_OVERBILLED	NUMBER			Distribution amount overbilled of the purchase order commitment.
PROJECT_NUMBER	VARCHAR2	(25)	Yes	The Project Number of the commitment.
PROJECT_NAME	VARCHAR2	(30)	Yes	The Project Name of the commitment.
TASK_NUMBER	VARCHAR2	(25)	Yes	The Task Number of the commitment.
TASK_NAME	VARCHAR2	(20)	Yes	The Task Name of the commitment.
EXPENDITURE_TYPE	VARCHAR2	(30)		Commitment expenditure type.
EXPENDITURE_CATEGORY	VARCHAR2	(30)	Yes	The expenditure category of the commitment.
REVENUE_CATEGORY	VARCHAR2	(30)	Yes	The revenue category of the commitment.
EXPENDITURE_ITEM_DATE	DATE			The expenditure item date on which you expect to incur the commitment costs.
PO_HEADER_ID	NUMBER		Yes	Identifier for purchase order header.
PO_RELEASE_ID	NUMBER			Identifier of the purchase order release.
PO_LINE_ID	NUMBER		Yes	Identifier of the purchase order line number in which the distribution is included.
PO_LINE_LOCATION_ID	NUMBER		Yes	Identifier of the purchase order line location.
PO_DISTRIBUTION_ID	NUMBER		Yes	The identifier of purchase order distribution
PROJECT_ID	NUMBER			Identifier of the project.
TASK_ID	NUMBER			Identifier of the lowest task
EXPENDITURE_ORGANIZATION_ID	NUMBER			Identifier of the expenditure organization incurring the commitment.
PROMISED_DATE	DATE			Promised delivery date for commitment.
NEED_BY_DATE	DATE			Date that commitment is needed by.
CMT_QTY	NUMBER			Outstanding quantity of the project-related commitment distribution.
DENOM_RAW_COST	NUMBER			The transaction currency raw cost amount of the project-related commitment distribution.
ACCT_RAW_COST	NUMBER			The functional currency raw cost amount of the project-related commitment distribution.
RESOURCE_CLASS	CHAR	(18)		Resource Class

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

Dependencies

[top of page]

APPS.PA_PROJ_PO_DISTRIBUTIONS_V1 references the following:

APPS: GL_SETS_OF_BOOKS; PA_CMT_UTILS - 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; PA_TASKS; PER_ALL_PEOPLE_F; PO_DISTRIBUTIONS_ALL; PO_DOCUMENT_TYPES; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_LINE_TYPES; PO_RELEASES_ALL; PO_VENDORS

APPS.PA_PROJ_PO_DISTRIBUTIONS_V1 is referenced by following:

APPS: PA_COMMITMENTS_V1