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

VIEW: APPS.PJM_BORROW_PAYBACK_DETAIL_V

Object Details
Object Name: PJM_BORROW_PAYBACK_DETAIL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPJM.PJM_BORROW_PAYBACK_DETAIL_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 Comments
ORGANIZATION_ID NUMBER

INVENTORY_ITEM_ID NUMBER

REVISION VARCHAR2 (3)
BORROW_PROJECT_ID NUMBER

BORROW_TASK_ID NUMBER

LENDING_PROJECT_ID NUMBER

LENDING_TASK_ID NUMBER

TRANSACTION_ID NUMBER

BORROW_TRANSACTION_ID NUMBER

TRANSACTION_DATE DATE

TRANSACTION_TYPE_ID NUMBER

TRANSACTION_TYPE_NAME VARCHAR2 (80)
TRANSACTION_TYPE_DISP VARCHAR2 (83)
LOAN_QUANTITY NUMBER

OUTSTANDING_QUANTITY NUMBER

PAYBACK_QUANTITY NUMBER

SCHEDULED_PAYBACK_DATE DATE

AGING_DAYS 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_TASK_ID
,      LENDING_PROJECT_ID
,      LENDING_TASK_ID
,      TRANSACTION_ID
,      BORROW_TRANSACTION_ID
,      TRANSACTION_DATE
,      TRANSACTION_TYPE_ID
,      TRANSACTION_TYPE_NAME
,      TRANSACTION_TYPE_DISP
,      LOAN_QUANTITY
,      OUTSTANDING_QUANTITY
,      PAYBACK_QUANTITY
,      SCHEDULED_PAYBACK_DATE
,      AGING_DAYS
FROM APPS.PJM_BORROW_PAYBACK_DETAIL_V;

Dependencies

[top of page]

APPS.PJM_BORROW_PAYBACK_DETAIL_V references the following:

SchemaAPPS
SynonymMTL_MATERIAL_TRANSACTIONS
SynonymMTL_TRANSACTION_TYPES
SynonymPJM_BORROW_PAYBACKS
SynonymPJM_BORROW_TRANSACTIONS

APPS.PJM_BORROW_PAYBACK_DETAIL_V is not referenced by any database object