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_XLA_EXTRACT_HEADERS_V

Object Details

Object Name:	PN_XLA_EXTRACT_HEADERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PN.PN_XLA_EXTRACT_HEADERS_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
LEASE_CLASS	VARCHAR2	(80)	Yes	Identifies the class of the lease.
LEASE_NAME	VARCHAR2	(50)	Yes	Name of the lease
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.
LOCATION_ID	NUMBER	(15)		Uniquely identifies a location row.
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.
PAYMENT_ITEM_ID	NUMBER		Yes	Uniquely identifies a payment or a billing item row. The value is populated using sequence PN_PAYMENT_ITEMS_S
PAYMENT_TERM_ID	NUMBER		Yes	Uniquely identifies a payment or a billing item row. The value is populated using sequence PN_PAYMENT_ITEMS_S
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.
PAYMENT_TERM_FREQUENCY	VARCHAR2	(80)	Yes	The frequency of the term, specifying how often this term will come into effect, for example, monthly, annually, etc
PROPERTY_CODE	VARCHAR2	(90)		Property Code should be Unique.
PROPERTY_NAME	VARCHAR2	(30)		Stores the Property Name.
CUSTOMER_ACCOUNT_ID	NUMBER			Associates the customer row in HZ_CUST_ACCOUNTS with the term row. The data element is null for a payment term row.
CUSTOMER_NAME	VARCHAR2	(360)		Name of this party
CUSTOMER_SITE	VARCHAR2	(40)		Site use identifier
CUSTOMER_SITE_ID	NUMBER			Associates the customer's bill to site with the term row. The data element is null for a payment term row
SUPPLIER_ID	NUMBER			Associates the row in PO_VENDORS with the term row. The data element is null for a billing term row.
SUPPLIER_SITE_ID	NUMBER			Associates the row in PO_VENDOR_SITES with the payment or billing term. The data element is null for a billing term row.
SUPPLIER_NAME	VARCHAR2	(240)		Supplier Name
SUPPLIER_SITE	VARCHAR2	(15)		Site code name
EVENT_ID	NUMBER	(15)	Yes	Event Id
TERM_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
TERM_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
TERM_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
TERM_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
TERM_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
TERM_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
TERM_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
TERM_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
TERM_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
TERM_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
TERM_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
TERM_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
TERM_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
TERM_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
TERM_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
TERM_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ITEM_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ITEM_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ITEM_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ITEM_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ITEM_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ITEM_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ITEM_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ITEM_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ITEM_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ITEM_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ITEM_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ITEM_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ITEM_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ITEM_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ITEM_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ITEM_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment

Query Text

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


SELECT LEASE_CLASS
,      LEASE_NAME
,      LEASE_NUMBER
,      LOCATION_ID
,      LOCATION_CODE
,      PAYMENT_ITEM_ID
,      PAYMENT_TERM_ID
,      PAYMENT_PURPOSE
,      PAYMENT_TYPE
,      PAYMENT_TERM_FREQUENCY
,      PROPERTY_CODE
,      PROPERTY_NAME
,      CUSTOMER_ACCOUNT_ID
,      CUSTOMER_NAME
,      CUSTOMER_SITE
,      CUSTOMER_SITE_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE
,      EVENT_ID
,      TERM_ATTRIBUTE_CATEGORY
,      TERM_ATTRIBUTE1
,      TERM_ATTRIBUTE2
,      TERM_ATTRIBUTE3
,      TERM_ATTRIBUTE4
,      TERM_ATTRIBUTE5
,      TERM_ATTRIBUTE6
,      TERM_ATTRIBUTE7
,      TERM_ATTRIBUTE8
,      TERM_ATTRIBUTE9
,      TERM_ATTRIBUTE10
,      TERM_ATTRIBUTE11
,      TERM_ATTRIBUTE12
,      TERM_ATTRIBUTE13
,      TERM_ATTRIBUTE14
,      TERM_ATTRIBUTE15
,      ITEM_ATTRIBUTE_CATEGORY
,      ITEM_ATTRIBUTE1
,      ITEM_ATTRIBUTE2
,      ITEM_ATTRIBUTE3
,      ITEM_ATTRIBUTE4
,      ITEM_ATTRIBUTE5
,      ITEM_ATTRIBUTE6
,      ITEM_ATTRIBUTE7
,      ITEM_ATTRIBUTE8
,      ITEM_ATTRIBUTE9
,      ITEM_ATTRIBUTE10
,      ITEM_ATTRIBUTE11
,      ITEM_ATTRIBUTE12
,      ITEM_ATTRIBUTE13
,      ITEM_ATTRIBUTE14
,      ITEM_ATTRIBUTE15
FROM APPS.PN_XLA_EXTRACT_HEADERS_V;

Dependencies

[top of page]

APPS.PN_XLA_EXTRACT_HEADERS_V 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; PN_PROPERTIES_ALL; PO_VENDORS; PO_VENDOR_SITES_ALL; XLA_EVENTS; XLA_TRANSACTION_ENTITIES

APPS.PN_XLA_EXTRACT_HEADERS_V is referenced by following:

APPS: XLA_00240_AAD_S_000003_PKG - show dependent code