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

VIEW: JA.JAI_RCV_CENVAT_CLAIMS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER (15) Yes
SHIPMENT_LINE_ID NUMBER (15)
CENVAT_AMOUNT NUMBER

CENVAT_CLAIMED_AMT NUMBER

CENVAT_CLAIMED_PTG NUMBER

CENVAT_SEQUENCE NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
VENDOR_CHANGED_FLAG VARCHAR2 (1)
VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

UNCLAIM_CENVAT_FLAG VARCHAR2 (1)
UNCLAIM_CENVAT_DATE DATE

UNCLAIMED_CENVAT_AMOUNT NUMBER

PARTIAL_CENVAT_CLAIM VARCHAR2 (2)
NON_BONDED_DELIVERY_FLAG VARCHAR2 (1)
QUANTITY_FOR_2ND_CLAIM NUMBER

OTHER_CENVAT_AMT NUMBER

OTHER_CENVAT_CLAIMED_AMT NUMBER

ONLINE_CLAIM_FLAG VARCHAR2 (1)
CENVAT_AMT_FOR_2ND_CLAIM NUMBER

OTHER_CENVAT_AMT_FOR_2ND_CLAIM NUMBER

OBJECT_VERSION_NUMBER NUMBER

Query Text

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


SELECT TRANSACTION_ID
,      SHIPMENT_LINE_ID
,      CENVAT_AMOUNT
,      CENVAT_CLAIMED_AMT
,      CENVAT_CLAIMED_PTG
,      CENVAT_SEQUENCE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      VENDOR_CHANGED_FLAG
,      VENDOR_ID
,      VENDOR_SITE_ID
,      UNCLAIM_CENVAT_FLAG
,      UNCLAIM_CENVAT_DATE
,      UNCLAIMED_CENVAT_AMOUNT
,      PARTIAL_CENVAT_CLAIM
,      NON_BONDED_DELIVERY_FLAG
,      QUANTITY_FOR_2ND_CLAIM
,      OTHER_CENVAT_AMT
,      OTHER_CENVAT_CLAIMED_AMT
,      ONLINE_CLAIM_FLAG
,      CENVAT_AMT_FOR_2ND_CLAIM
,      OTHER_CENVAT_AMT_FOR_2ND_CLAIM
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_RCV_CENVAT_CLAIMS#;

Dependencies

[top of page]

JA.JAI_RCV_CENVAT_CLAIMS# references the following:

SchemaJA
TableJAI_RCV_CENVAT_CLAIMS
JA.JAI_RCV_CENVAT_CLAIMS# is referenced by following:

SchemaAPPS
SynonymJAI_RCV_CENVAT_CLAIMS