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

Object Details

Object Name:	PN_TRX_LEASE_REVENUE
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PN.PN_TRX_LEASE_REVENUE
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PAYMENT_ITEM_ID	NUMBER		Yes	Uniquely identifies a payment or a billing item row. The value is populated using sequence PN_PAYMENT_ITEMS_S
LEASE_NUMBER	VARCHAR2	(30)	Yes	Lease number. Unique identifier of a lease row. User defined, except when profile option PN: Automatic Lease Number Generation is set to "Yes", then PN_LEASES_NUM_S sequence is used to populate this data element.
LEASE_NAME	VARCHAR2	(50)	Yes	Name of the lease
CUSTOMER_NAME	VARCHAR2	(240)		Name of this party
CUSTOMER_SITE	VARCHAR2	(40)	Yes	Site use identifier
PAYMENT_PURPOSE	VARCHAR2	(80)	Yes	Identifies the purpose of the term, for example whether it is for rent, operating expense, insurance, etc.
PAYMENT_TYPE	VARCHAR2	(80)	Yes	Identifies the type of the term, fore example, base, escalation, pre-payment, etc.
LOCATION_CODE	VARCHAR2	(90)		Another way of uniquely identifying a location. The locations are classified as: BUILDING, FLOOR and OFFICE. Oracle Property Manager generates this unique code based on the input provided by the user in the location_alias data element. If the location_alias for the building row is 3OP, the location code for the building is created as 3OP. For a floor in the same building, if the location_alias is -02 then the floor's location code is created as 3OP-2. For an office on the same floor, if the location_alias is -201 then the office location code is created as 3OP-02-201.

Query Text

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


SELECT PAYMENT_ITEM_ID
,      LEASE_NUMBER
,      LEASE_NAME
,      CUSTOMER_NAME
,      CUSTOMER_SITE
,      PAYMENT_PURPOSE
,      PAYMENT_TYPE
,      LOCATION_CODE
FROM APPS.PN_TRX_LEASE_REVENUE;

Dependencies

[top of page]

APPS.PN_TRX_LEASE_REVENUE references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; HZ_CUST_ACCOUNTS_ALL; HZ_CUST_SITE_USES_ALL; HZ_PARTIES; PN_LEASES_ALL; PN_LOCATIONS_ALL; PN_PAYMENT_ITEMS; PN_PAYMENT_TERMS_ALL

APPS.PN_TRX_LEASE_REVENUE is not referenced by any database object