eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.JAI_MTL_CVAT_V

Object Details

Object Name:	JAI_MTL_CVAT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JA.JAI_MTL_CVAT_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
RECEIPT_NUM	VARCHAR2	(30)	Indicates the receipt number
QUANTITY	NUMBER		Indicates quantity
ORGANIZATION_ID	NUMBER	(15)	Indicates the organization in which the interorg transfer is done
INVENTORY_ITEM_ID	NUMBER	(15)	Indicates the item identifier that is being transacted
CENVAT_CLAIMED_PTG	NUMBER		Indicates the amount of Excise tax that has been claimed in percentage terms
VAT_CLAIMED_PTG	NUMBER		Indicates the amount of Value Added Tax that has been claimed in percentage terms
CENVAT_QTY_AVAILABLE	NUMBER		Indicates the quantity for which excise tax can still be claimed
VAT_QTY	NUMBER		Indicates the quantity for which Value Added tax can still be claimed
CENVAT_AMT_FOR_2ND_CLAIM	NUMBER		Indicates the amount of Excise tax that is available for second claim
SHIPMENT_LINE_ID	NUMBER		Indicates the shipment line identifer of the receipt
CENVAT_CLAIMED_AMT	NUMBER		Indicates the amount of excise tax that has been claimed.
OTHER_CENVAT_CLAIMED_AMT	NUMBER		Indicates the amount of excise cess tax that has been claimed.
OTHER_CENVAT_AMT_FOR_2ND_CLAIM	NUMBER		Indicates the amount of Excise cess tax that is available for second claim
CENVAT_AMOUNT	NUMBER		Indicates the total excise amount available for claim in the receipt
OTHER_CENVAT_AMT	NUMBER		Indicates the total excise cess amount available for claim in the receipt
TRANSACTION_ID	NUMBER		Indicates the transaction identifier for which claim is done
EXCISE_INVOICE_NO	VARCHAR2	(30)	Indicates the excise invoice number
EXCISE_INVOICE_DATE	DATE		Indicates the excise invoice date
VAT_INVOICE_NO	VARCHAR2	(240)	Indicates the vat invoice number

Query Text

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


SELECT RECEIPT_NUM
,      QUANTITY
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      CENVAT_CLAIMED_PTG
,      VAT_CLAIMED_PTG
,      CENVAT_QTY_AVAILABLE
,      VAT_QTY
,      CENVAT_AMT_FOR_2ND_CLAIM
,      SHIPMENT_LINE_ID
,      CENVAT_CLAIMED_AMT
,      OTHER_CENVAT_CLAIMED_AMT
,      OTHER_CENVAT_AMT_FOR_2ND_CLAIM
,      CENVAT_AMOUNT
,      OTHER_CENVAT_AMT
,      TRANSACTION_ID
,      EXCISE_INVOICE_NO
,      EXCISE_INVOICE_DATE
,      VAT_INVOICE_NO
FROM APPS.JAI_MTL_CVAT_V;

Dependencies

[top of page]

APPS.JAI_MTL_CVAT_V references the following:

APPS: JAI_RCV_CENVAT_CLAIMS; JAI_RCV_RGM_LINES; JAI_RCV_TRANSACTIONS

APPS.JAI_MTL_CVAT_V is not referenced by any database object