[Home] [Help] [Dependency Information]
Object Name: | JMF_GTA_SYSTEM_PARAMETERS_OBS# |
---|---|
Object Type: | VIEW |
Owner: | JMF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | Yes | ||
AUTO_BATCH_NUMBERING_FLAG | VARCHAR2 | (1) | Yes | |
NEXT_BATCH_NUMBER | NUMBER | |||
VAT_TAX_TYPE_CODE | VARCHAR2 | (30) | Yes | |
TRX_LINE_SPLIT_FLAG | VARCHAR2 | (1) | Yes | |
GT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
ITEM_NAME_SOURCE_FLAG | VARCHAR2 | (1) | ||
CROSS_REFERENCE_TYPE | VARCHAR2 | (25) | ||
MASTER_ITEM_DEFAULT_FLAG | VARCHAR2 | (1) | ||
LATEST_REF_DEFAULT_FLAG | VARCHAR2 | (1) | ||
RA_LINE_CONTEXT_CODE | VARCHAR2 | (30) | ||
RA_MODEL_ATTRIBUTE_COLUMN | VARCHAR2 | (30) | ||
RA_TAX_ATTRIBUTE_COLUMN | VARCHAR2 | (30) | ||
INV_ITEM_CONTEXT_CODE | VARCHAR2 | (30) | ||
INV_MODEL_ATTRIBUTE_COLUMN | VARCHAR2 | (30) | ||
INV_TAX_ATTRIBUTE_COLUMN | VARCHAR2 | (30) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (22) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (22) | Yes | |
LAST_UPDATE_LOGIN | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, AUTO_BATCH_NUMBERING_FLAG
, NEXT_BATCH_NUMBER
, VAT_TAX_TYPE_CODE
, TRX_LINE_SPLIT_FLAG
, GT_CURRENCY_CODE
, ITEM_NAME_SOURCE_FLAG
, CROSS_REFERENCE_TYPE
, MASTER_ITEM_DEFAULT_FLAG
, LATEST_REF_DEFAULT_FLAG
, RA_LINE_CONTEXT_CODE
, RA_MODEL_ATTRIBUTE_COLUMN
, RA_TAX_ATTRIBUTE_COLUMN
, INV_ITEM_CONTEXT_CODE
, INV_MODEL_ATTRIBUTE_COLUMN
, INV_TAX_ATTRIBUTE_COLUMN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM JMF.JMF_GTA_SYSTEM_PARAMETERS_OBS#;
|
|
|