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

VIEW: JA.JAI_CMN_RG_COMP_DTLS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15)
LOCATION_ID NUMBER (15)
INVENTORY_ITEM_ID NUMBER (15)
FIN_YEAR NUMBER (9)
REGISTER_ID NUMBER (15)
SLNO NUMBER (15)
REGISTER_TYPE VARCHAR2 (2)
BASIC_OPENING_BALANCE NUMBER

ADDITIONAL_OPENING_BALANCE NUMBER

OTHER_OPENING_BALANCE NUMBER

CR_BASIC_ED NUMBER

CR_ADDITIONAL_ED NUMBER

CR_OTHER_ED NUMBER

DR_BASIC_ED NUMBER

DR_ADDITIONAL_ED NUMBER

DR_OTHER_ED NUMBER

BASIC_CLOSING_BALANCE NUMBER

ADDITIONAL_CLOSING_BALANCE NUMBER

OTHER_CLOSING_BALANCE NUMBER

TRANSACTION_DATE DATE

CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
EXCISE_COMP_DTL_ID NUMBER (15) Yes
OBJECT_VERSION_NUMBER NUMBER

Query Text

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


SELECT ORGANIZATION_ID
,      LOCATION_ID
,      INVENTORY_ITEM_ID
,      FIN_YEAR
,      REGISTER_ID
,      SLNO
,      REGISTER_TYPE
,      BASIC_OPENING_BALANCE
,      ADDITIONAL_OPENING_BALANCE
,      OTHER_OPENING_BALANCE
,      CR_BASIC_ED
,      CR_ADDITIONAL_ED
,      CR_OTHER_ED
,      DR_BASIC_ED
,      DR_ADDITIONAL_ED
,      DR_OTHER_ED
,      BASIC_CLOSING_BALANCE
,      ADDITIONAL_CLOSING_BALANCE
,      OTHER_CLOSING_BALANCE
,      TRANSACTION_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      EXCISE_COMP_DTL_ID
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_CMN_RG_COMP_DTLS#;

Dependencies

[top of page]

JA.JAI_CMN_RG_COMP_DTLS# references the following:

SchemaJA
TableJAI_CMN_RG_COMP_DTLS
JA.JAI_CMN_RG_COMP_DTLS# is referenced by following:

SchemaAPPS
SynonymJAI_CMN_RG_COMP_DTLS