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

VIEW: AP.AP_TERMS_LINES#

Object Details
Object Name: AP_TERMS_LINES#
Object Type: VIEW
Owner: AP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TERM_ID NUMBER
Yes
SEQUENCE_NUM NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
DUE_PERCENT NUMBER

DUE_AMOUNT NUMBER

DUE_DAYS NUMBER

DUE_DAY_OF_MONTH NUMBER

DUE_MONTHS_FORWARD NUMBER

DISCOUNT_PERCENT NUMBER

DISCOUNT_DAYS NUMBER

DISCOUNT_DAY_OF_MONTH NUMBER

DISCOUNT_MONTHS_FORWARD NUMBER

DISCOUNT_PERCENT_2 NUMBER

DISCOUNT_DAYS_2 NUMBER

DISCOUNT_DAY_OF_MONTH_2 NUMBER

DISCOUNT_MONTHS_FORWARD_2 NUMBER

DISCOUNT_PERCENT_3 NUMBER

DISCOUNT_DAYS_3 NUMBER

DISCOUNT_DAY_OF_MONTH_3 NUMBER

DISCOUNT_MONTHS_FORWARD_3 NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (150)
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)
FIXED_DATE DATE

CALENDAR VARCHAR2 (30)
DISCOUNT_AMOUNT NUMBER

DISCOUNT_CRITERIA VARCHAR2 (1)
DISCOUNT_AMOUNT_2 NUMBER

DISCOUNT_CRITERIA_2 VARCHAR2 (1)
DISCOUNT_AMOUNT_3 NUMBER

DISCOUNT_CRITERIA_3 VARCHAR2 (1)
Query Text

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


SELECT TERM_ID
,      SEQUENCE_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DUE_PERCENT
,      DUE_AMOUNT
,      DUE_DAYS
,      DUE_DAY_OF_MONTH
,      DUE_MONTHS_FORWARD
,      DISCOUNT_PERCENT
,      DISCOUNT_DAYS
,      DISCOUNT_DAY_OF_MONTH
,      DISCOUNT_MONTHS_FORWARD
,      DISCOUNT_PERCENT_2
,      DISCOUNT_DAYS_2
,      DISCOUNT_DAY_OF_MONTH_2
,      DISCOUNT_MONTHS_FORWARD_2
,      DISCOUNT_PERCENT_3
,      DISCOUNT_DAYS_3
,      DISCOUNT_DAY_OF_MONTH_3
,      DISCOUNT_MONTHS_FORWARD_3
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      FIXED_DATE
,      CALENDAR
,      DISCOUNT_AMOUNT
,      DISCOUNT_CRITERIA
,      DISCOUNT_AMOUNT_2
,      DISCOUNT_CRITERIA_2
,      DISCOUNT_AMOUNT_3
,      DISCOUNT_CRITERIA_3
FROM AP.AP_TERMS_LINES#;

Dependencies

[top of page]

AP.AP_TERMS_LINES# references the following:

SchemaAP
TableAP_TERMS_LINES
AP.AP_TERMS_LINES# is referenced by following:

SchemaAPPS
SynonymAP_TERMS_LINES