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


VIEW: APPS.PN_TERM_TEMPLATES_V

Object Details
Object Name: PN_TERM_TEMPLATES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPN.PN_TERM_TEMPLATES_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
ROW_ID ROWID (10)
TERM_TEMPLATE_ID NUMBER

NAME VARCHAR2 (100)
TERM_TEMPLATE_TYPE VARCHAR2 (30)
SET_OF_BOOKS_ID NUMBER

CURRENCY_CODE VARCHAR2 (30)
NORMALIZE VARCHAR2 (1)
SCHEDULE_DAY NUMBER

PAYMENT_PURPOSE_CODE VARCHAR2 (30)
PAYMENT_TERM_TYPE_CODE VARCHAR2 (30)
ACCRUAL_ACCOUNT_ID NUMBER

PROJECT_ID NUMBER

TASK_ID NUMBER

ORGANIZATION_ID NUMBER

EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_ITEM_DATE DATE

VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

CUSTOMER_ID NUMBER

CUSTOMER_SITE_USE_ID NUMBER

CUST_SHIP_SITE_ID NUMBER

AP_AR_TERM_ID NUMBER

CUST_TRX_TYPE_ID NUMBER

TAX_GROUP_ID NUMBER

TAX_CODE_ID NUMBER

DISTRIBUTION_SET_ID NUMBER

INV_RULE_ID NUMBER

ACCOUNT_RULE_ID NUMBER

SALESREP_ID NUMBER

TAX_INCLUDED VARCHAR2 (1)
PO_HEADER_ID NUMBER

CUST_PO_NUMBER VARCHAR2 (50)
RECEIPT_METHOD_ID NUMBER

LOCATION_ID NUMBER (15)
ACTIVE VARCHAR2 (1)
DESCRIPTION VARCHAR2 (100)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN 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)
PAYMENT_PURPOSE VARCHAR2 (80)
PAYMENT_TERM_TYPE VARCHAR2 (80)
VENDOR_NAME VARCHAR2 (240)
VENDOR_NUMBER VARCHAR2 (30)
VENDOR_SITE VARCHAR2 (15)
CUSTOMER_NAME VARCHAR2 (360)
CUSTOMER_NUMBER VARCHAR2 (30)
CUSTOMER_SITE_USE VARCHAR2 (40)
CUST_SHIP_SITE_USE VARCHAR2 (40)
TAX_FLAG VARCHAR2 (0)
PROPERTY_NAME VARCHAR2 (30)
LOCATION_CODE VARCHAR2 (90)
ORG_ID NUMBER (15)
TAX_CLASSIFICATION_CODE VARCHAR2 (30)
TCC_PAYMENT VARCHAR2 (80)
TCC_BILLING VARCHAR2 (80)
Query Text

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


SELECT ROW_ID
,      TERM_TEMPLATE_ID
,      NAME
,      TERM_TEMPLATE_TYPE
,      SET_OF_BOOKS_ID
,      CURRENCY_CODE
,      NORMALIZE
,      SCHEDULE_DAY
,      PAYMENT_PURPOSE_CODE
,      PAYMENT_TERM_TYPE_CODE
,      ACCRUAL_ACCOUNT_ID
,      PROJECT_ID
,      TASK_ID
,      ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      CUST_SHIP_SITE_ID
,      AP_AR_TERM_ID
,      CUST_TRX_TYPE_ID
,      TAX_GROUP_ID
,      TAX_CODE_ID
,      DISTRIBUTION_SET_ID
,      INV_RULE_ID
,      ACCOUNT_RULE_ID
,      SALESREP_ID
,      TAX_INCLUDED
,      PO_HEADER_ID
,      CUST_PO_NUMBER
,      RECEIPT_METHOD_ID
,      LOCATION_ID
,      ACTIVE
,      DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PAYMENT_PURPOSE
,      PAYMENT_TERM_TYPE
,      VENDOR_NAME
,      VENDOR_NUMBER
,      VENDOR_SITE
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      CUSTOMER_SITE_USE
,      CUST_SHIP_SITE_USE
,      TAX_FLAG
,      PROPERTY_NAME
,      LOCATION_CODE
,      ORG_ID
,      TAX_CLASSIFICATION_CODE
,      TCC_PAYMENT
,      TCC_BILLING
FROM APPS.PN_TERM_TEMPLATES_V;

Dependencies

[top of page]

APPS.PN_TERM_TEMPLATES_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTIES
PL/SQL PackagePNP_UTIL_FUNC - show dependent code
ViewPN_LOCATIONS_V
SynonymPN_TERM_TEMPLATES
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.PN_TERM_TEMPLATES_V is not referenced by any database object