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


VIEW: APPS.PN_EXCLUDE_TERMS_V

Object Details
Object Name: PN_EXCLUDE_TERMS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PAYMENT_TERM_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

PAYMENT_PURPOSE_CODE VARCHAR2 (30)
PAYMENT_TERM_TYPE_CODE VARCHAR2 (30)
FREQUENCY_CODE VARCHAR2 (30)
NORMALIZE VARCHAR2 (1)
LEASE_ID NUMBER

LEASE_CHANGE_ID NUMBER

START_DATE DATE

END_DATE DATE

VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

CUSTOMER_ID NUMBER

CUSTOMER_SITE_USE_ID NUMBER

TARGET_DATE DATE

ACTUAL_AMOUNT NUMBER

ESTIMATED_AMOUNT NUMBER

SET_OF_BOOKS_ID NUMBER

CURRENCY_CODE VARCHAR2 (15)
RATE NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
LOCATION_ID NUMBER (15)
SCHEDULE_DAY NUMBER (15)
CUST_SHIP_SITE_ID NUMBER (15)
AP_AR_TERM_ID NUMBER (15)
CUST_TRX_TYPE_ID NUMBER (15)
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
ORGANIZATION_ID NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_ITEM_DATE DATE

TAX_GROUP_ID NUMBER (15)
TAX_CODE_ID NUMBER (15)
TAX_INCLUDED VARCHAR2 (1)
DISTRIBUTION_SET_ID NUMBER (15)
INV_RULE_ID NUMBER (15)
ACCOUNT_RULE_ID NUMBER (15)
SALESREP_ID NUMBER (15)
APPROVED_BY NUMBER (15)
STATUS VARCHAR2 (30)
INDEX_PERIOD_ID NUMBER

INDEX_TERM_INDICATOR VARCHAR2 (30)
PO_HEADER_ID VARCHAR2 (30)
CUST_PO_NUMBER VARCHAR2 (50)
RECEIPT_METHOD_ID NUMBER (15)
VAR_RENT_INV_ID NUMBER (38)
VAR_RENT_TYPE VARCHAR2 (20)
CHANGED_FLAG VARCHAR2 (20)
RECOVERABLE_FLAG VARCHAR2 (1)
PERIOD_BILLREC_ID NUMBER (15)
REC_AGR_LINE_ID NUMBER (15)
AMOUNT_TYPE VARCHAR2 (30)
NORM_START_DATE DATE

INTERFACE_LINE_CONTEXT VARCHAR2 (30)
INTERFACE_LINE_ATTRIBUTE1 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE2 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE3 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE4 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE5 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE6 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE7 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE8 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE9 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE10 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE11 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE12 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE13 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE14 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE15 VARCHAR2 (150)
TERM_TEMPLATE_ID NUMBER (15)
PAYMENT_PURPOSE VARCHAR2 (80)
PAYMENT_TERM_TYPE VARCHAR2 (80)
VENDOR_NAME VARCHAR2 (240)
VENDOR_NUMBER VARCHAR2 (30)
VENDOR_SITE VARCHAR2 (15)
TAX_FLAG VARCHAR2 (1)
CUSTOMER_NAME VARCHAR2 (50)
CUSTOMER_NUMBER VARCHAR2 (30)
CUSTOMER_SITE_USE VARCHAR2 (40)
CUST_SHIP_SITE_USE VARCHAR2 (40)
TOTAL_PAYMENT NUMBER

LEASED_AREA NUMBER

AREA_TYPE_CODE VARCHAR2 (30)
AREA NUMBER

GROUPING_RULE_ID NUMBER (15)
INV_GROUP_NAME VARCHAR2 (30)
ORG_ID NUMBER (15)
TERM_TEMPLATE VARCHAR2 (100)
TERM_ALTERED_FLAG VARCHAR2 (1)
SOURCE_CODE VARCHAR2 (30)
SOURCE_DESC VARCHAR2 (80)
TERM_COMMENTS VARCHAR2 (2000)
TAX_CLASSIFICATION_CODE VARCHAR2 (30)
TCC_PAYMENT VARCHAR2 (80)
TCC_BILLING VARCHAR2 (80)
LEGAL_ENTITY_ID NUMBER (15)
INDEX_LEASE_ID NUMBER

EXCLUDE_FLAG VARCHAR2 (1)
INDEX_EXCLUDE_TERM_ID NUMBER

INCLUDE_IN_VAR_RENT VARCHAR2 (30)
Query Text

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


SELECT ROW_ID
,      PAYMENT_TERM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PAYMENT_PURPOSE_CODE
,      PAYMENT_TERM_TYPE_CODE
,      FREQUENCY_CODE
,      NORMALIZE
,      LEASE_ID
,      LEASE_CHANGE_ID
,      START_DATE
,      END_DATE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      TARGET_DATE
,      ACTUAL_AMOUNT
,      ESTIMATED_AMOUNT
,      SET_OF_BOOKS_ID
,      CURRENCY_CODE
,      RATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LOCATION_ID
,      SCHEDULE_DAY
,      CUST_SHIP_SITE_ID
,      AP_AR_TERM_ID
,      CUST_TRX_TYPE_ID
,      PROJECT_ID
,      TASK_ID
,      ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      TAX_GROUP_ID
,      TAX_CODE_ID
,      TAX_INCLUDED
,      DISTRIBUTION_SET_ID
,      INV_RULE_ID
,      ACCOUNT_RULE_ID
,      SALESREP_ID
,      APPROVED_BY
,      STATUS
,      INDEX_PERIOD_ID
,      INDEX_TERM_INDICATOR
,      PO_HEADER_ID
,      CUST_PO_NUMBER
,      RECEIPT_METHOD_ID
,      VAR_RENT_INV_ID
,      VAR_RENT_TYPE
,      CHANGED_FLAG
,      RECOVERABLE_FLAG
,      PERIOD_BILLREC_ID
,      REC_AGR_LINE_ID
,      AMOUNT_TYPE
,      NORM_START_DATE
,      INTERFACE_LINE_CONTEXT
,      INTERFACE_LINE_ATTRIBUTE1
,      INTERFACE_LINE_ATTRIBUTE2
,      INTERFACE_LINE_ATTRIBUTE3
,      INTERFACE_LINE_ATTRIBUTE4
,      INTERFACE_LINE_ATTRIBUTE5
,      INTERFACE_LINE_ATTRIBUTE6
,      INTERFACE_LINE_ATTRIBUTE7
,      INTERFACE_LINE_ATTRIBUTE8
,      INTERFACE_LINE_ATTRIBUTE9
,      INTERFACE_LINE_ATTRIBUTE10
,      INTERFACE_LINE_ATTRIBUTE11
,      INTERFACE_LINE_ATTRIBUTE12
,      INTERFACE_LINE_ATTRIBUTE13
,      INTERFACE_LINE_ATTRIBUTE14
,      INTERFACE_LINE_ATTRIBUTE15
,      TERM_TEMPLATE_ID
,      PAYMENT_PURPOSE
,      PAYMENT_TERM_TYPE
,      VENDOR_NAME
,      VENDOR_NUMBER
,      VENDOR_SITE
,      TAX_FLAG
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      CUSTOMER_SITE_USE
,      CUST_SHIP_SITE_USE
,      TOTAL_PAYMENT
,      LEASED_AREA
,      AREA_TYPE_CODE
,      AREA
,      GROUPING_RULE_ID
,      INV_GROUP_NAME
,      ORG_ID
,      TERM_TEMPLATE
,      TERM_ALTERED_FLAG
,      SOURCE_CODE
,      SOURCE_DESC
,      TERM_COMMENTS
,      TAX_CLASSIFICATION_CODE
,      TCC_PAYMENT
,      TCC_BILLING
,      LEGAL_ENTITY_ID
,      INDEX_LEASE_ID
,      EXCLUDE_FLAG
,      INDEX_EXCLUDE_TERM_ID
,      INCLUDE_IN_VAR_RENT
FROM APPS.PN_EXCLUDE_TERMS_V;

Dependencies

[top of page]

APPS.PN_EXCLUDE_TERMS_V references the following:

SchemaAPPS
ViewAR_CUSTOMERS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymHZ_CUST_SITE_USES_ALL
PL/SQL PackagePNP_UTIL_FUNC - show dependent code
SynonymPN_INDEX_EXCLUDE_TERM_ALL
SynonymPN_INDEX_LEASES_ALL
SynonymPN_LEASES_ALL
SynonymPN_PAYMENT_TERMS
SynonymPN_PAY_GROUP_RULES
SynonymPN_SYSTEM_SETUP_OPTIONS
SynonymPN_TERM_TEMPLATES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.PN_EXCLUDE_TERMS_V is not referenced by any database object