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.PJM_BORROW_PAYBACK_SUMMARY_V

Object Details

Object Name:	PJM_BORROW_PAYBACK_SUMMARY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PJM.PJM_BORROW_PAYBACK_SUMMARY_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory
ORGANIZATION_ID	NUMBER		Yes
INVENTORY_ITEM_ID	NUMBER		Yes
REVISION	VARCHAR2	(3)
BORROW_PROJECT_ID	NUMBER		Yes
BORROW_PROJECT_NUMBER	VARCHAR2	(4000)
BORROW_PROJECT_NAME	VARCHAR2	(4000)
BORROW_TASK_ID	NUMBER
BORROW_TASK_NUMBER	VARCHAR2	(4000)
BORROW_TASK_NAME	VARCHAR2	(4000)
BORROW_COST_GROUP_ID	NUMBER		Yes
BORROW_COST_GROUP	VARCHAR2	(10)	Yes
LENDING_PROJECT_ID	NUMBER		Yes
LENDING_PROJECT_NUMBER	VARCHAR2	(4000)
LENDING_PROJECT_NAME	VARCHAR2	(4000)
LENDING_TASK_ID	NUMBER
LENDING_TASK_NUMBER	VARCHAR2	(4000)
LENDING_TASK_NAME	VARCHAR2	(4000)
LENDING_COST_GROUP_ID	NUMBER		Yes
LENDING_COST_GROUP	VARCHAR2	(10)	Yes
OUTSTANDING_QUANTITY	NUMBER
AGING_BUCKET1	NUMBER
AGING_BUCKET2	NUMBER
AGING_BUCKET3	NUMBER
AGING_BUCKET4	NUMBER

Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      REVISION
,      BORROW_PROJECT_ID
,      BORROW_PROJECT_NUMBER
,      BORROW_PROJECT_NAME
,      BORROW_TASK_ID
,      BORROW_TASK_NUMBER
,      BORROW_TASK_NAME
,      BORROW_COST_GROUP_ID
,      BORROW_COST_GROUP
,      LENDING_PROJECT_ID
,      LENDING_PROJECT_NUMBER
,      LENDING_PROJECT_NAME
,      LENDING_TASK_ID
,      LENDING_TASK_NUMBER
,      LENDING_TASK_NAME
,      LENDING_COST_GROUP_ID
,      LENDING_COST_GROUP
,      OUTSTANDING_QUANTITY
,      AGING_BUCKET1
,      AGING_BUCKET2
,      AGING_BUCKET3
,      AGING_BUCKET4
FROM APPS.PJM_BORROW_PAYBACK_SUMMARY_V;

Dependencies

[top of page]

APPS.PJM_BORROW_PAYBACK_SUMMARY_V references the following:

APPS: CST_COST_GROUPS; PJM_BORROW_PAYBACK - show dependent code; PJM_BORROW_TRANSACTIONS; PJM_PROJECT - show dependent code; PJM_PROJECT_PARAMETERS

APPS.PJM_BORROW_PAYBACK_SUMMARY_V is not referenced by any database object