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

VIEW: JA.JAI_BOE_DETAIL_TAXES#

Object Details
Object Name: JAI_BOE_DETAIL_TAXES#
Object Type: VIEW
Owner: JA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BOE_DETAIL_TAX_ID NUMBER (15) Yes
BOE_DETAIL_ID NUMBER (15) Yes
TAX_LINE_NO VARCHAR2 (50) Yes
TAX_ID NUMBER (15)
TAX_TYPE VARCHAR2 (30)
TAX_RATE NUMBER

ASSESSABLE_VALUE NUMBER

TAX_AMOUNT NUMBER

UOM NUMBER

APPLIED_AMOUNT NUMBER

QTY_RATE NUMBER

PRECEDENCE_1 NUMBER

PRECEDENCE_2 NUMBER

PRECEDENCE_3 NUMBER

PRECEDENCE_4 NUMBER

PRECEDENCE_5 NUMBER

PRECEDENCE_6 NUMBER

PRECEDENCE_7 NUMBER

PRECEDENCE_8 NUMBER

PRECEDENCE_9 NUMBER

PRECEDENCE_10 NUMBER

BASE_TAX_AMOUNT NUMBER

FUNC_TAX_AMOUNT NUMBER

INCLUSIVE_TAX_FLAG VARCHAR2 (1)
BOE_FLAG VARCHAR2 (1)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
OBJECT_VERSION_NUMBER NUMBER

TAX_CATEGORY_ID NUMBER (15)
Query Text

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


SELECT BOE_DETAIL_TAX_ID
,      BOE_DETAIL_ID
,      TAX_LINE_NO
,      TAX_ID
,      TAX_TYPE
,      TAX_RATE
,      ASSESSABLE_VALUE
,      TAX_AMOUNT
,      UOM
,      APPLIED_AMOUNT
,      QTY_RATE
,      PRECEDENCE_1
,      PRECEDENCE_2
,      PRECEDENCE_3
,      PRECEDENCE_4
,      PRECEDENCE_5
,      PRECEDENCE_6
,      PRECEDENCE_7
,      PRECEDENCE_8
,      PRECEDENCE_9
,      PRECEDENCE_10
,      BASE_TAX_AMOUNT
,      FUNC_TAX_AMOUNT
,      INCLUSIVE_TAX_FLAG
,      BOE_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      TAX_CATEGORY_ID
FROM JA.JAI_BOE_DETAIL_TAXES#;

Dependencies

[top of page]

JA.JAI_BOE_DETAIL_TAXES# references the following:

SchemaJA
TableJAI_BOE_DETAIL_TAXES
JA.JAI_BOE_DETAIL_TAXES# is referenced by following:

SchemaAPPS
SynonymJAI_BOE_DETAIL_TAXES