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_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Comments
PO_NUMBER	VARCHAR2	(20)
PO_REVISION	NUMBER
RELEASE_NUMBER	NUMBER
RELEASE_REVISION	NUMBER
APPROVED_FLAG	VARCHAR2	(1)
EVER_APPROVED_FLAG	VARCHAR2	(1)
DOCUMENT_TYPE	VARCHAR2	(80)
CREATION_DATE	DATE
APPROVED_DATE	DATE
PRINTED_DATE	DATE
REQUESTOR_PERSON_ID	NUMBER	(9)
REQUESTOR_NAME	VARCHAR2	(240)
BUYER_PERSON_ID	NUMBER	(9)
BUYER_NAME	VARCHAR2	(240)
VENDOR_NAME	VARCHAR2	(240)
VENDOR_ID	NUMBER
PO_LINE	NUMBER
ITEM_DESCRIPTION	VARCHAR2	(240)
UNIT	VARCHAR2	(25)
UNIT_PRICE	NUMBER
QUANTITY_ORDERED	NUMBER
AMOUNT_ORDERED	NUMBER
ORIGINAL_QUANTITY_ORDERED	NUMBER
ORIGINAL_AMOUNT_ORDERED	NUMBER
QUANTITY_CANCELLED	NUMBER
AMOUNT_CANCELLED	NUMBER
QUANTITY_DELIVERED	NUMBER
DENOM_AMOUNT_DELIVERED	NUMBER
AMOUNT_DELIVERED	NUMBER
QUANTITY_INVOICED	NUMBER
AMOUNT_INVOICED	NUMBER
QUANTITY_OUTSTANDING_DELIVERY	NUMBER
AMOUNT_OUTSTANDING_DELIVERY	NUMBER
QUANTITY_OUTSTANDING_INVOICE	NUMBER
DENOM_CURRENCY_CODE	VARCHAR2	(15)
DENOM_AMT_OUTSTANDING_INVOICE	NUMBER
ACCT_CURRENCY_CODE	VARCHAR2	(15)
AMOUNT_OUTSTANDING_INVOICE	NUMBER
ACCT_RATE_DATE	DATE
ACCT_RATE_TYPE	VARCHAR2	(30)
ACCT_EXCHANGE_RATE	NUMBER
QUANTITY_OVERBILLED	NUMBER
AMOUNT_OVERBILLED	NUMBER
PROJECT_NUMBER	VARCHAR2	(25)
PROJECT_NAME	VARCHAR2	(30)
TASK_NUMBER	VARCHAR2	(25)
TASK_NAME	VARCHAR2	(20)
EXPENDITURE_TYPE	VARCHAR2	(30)
EXPENDITURE_CATEGORY	VARCHAR2	(30)
REVENUE_CATEGORY	VARCHAR2	(30)
EXPENDITURE_ITEM_DATE	DATE
PO_HEADER_ID	NUMBER
PO_RELEASE_ID	NUMBER		Identifier of the purchase order release.
PO_LINE_ID	NUMBER		Identifier of the purchase order line number in which the distribution is included.
PO_LINE_LOCATION_ID	NUMBER		Identifier of the purchase order line location.
PO_DISTRIBUTION_ID	NUMBER		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)

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_V;

Dependencies

[top of page]

APPS.PA_PROJ_PO_DISTRIBUTIONS_V 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_V is referenced by following:

APPS: PA_COMMITMENTS_V