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: ViewPN.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 (240)
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:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymHZ_CUST_ACCOUNTS_ALL
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTIES
SynonymPN_LEASES_ALL
SynonymPN_LOCATIONS_ALL
SynonymPN_PAYMENT_ITEMS
SynonymPN_PAYMENT_TERMS_ALL
SynonymPN_PROPERTIES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
SynonymXLA_EVENTS
SynonymXLA_TRANSACTION_ENTITIES
APPS.PN_XLA_EXTRACT_HEADERS_V is referenced by following:

SchemaAPPS
Package BodyXLA_00240_AAD_S_000003_PKG - show dependent code