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

VIEW: JA.JAI_MTL_MATCH_RECEIPTS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
MATCH_RECEIPT_ID NUMBER
Yes
TRANSACTION_TEMP_ID NUMBER
Yes
ORGANIZATION_ID NUMBER (15) Yes
INVENTORY_ITEM_ID NUMBER (15) Yes
RECEIPT_NUMBER VARCHAR2 (30) Yes
QUANTITY NUMBER

CENVAT_QTY_AVAILABLE NUMBER

CENVAT_CLAIMED_PTG NUMBER

CENVAT_CLAIMED_AMT NUMBER

OTHER_CENVAT_CLAIMED_AMT NUMBER

CENVAT_AMT_FOR_2ND_CLAIM NUMBER

CENVAT_AMOUNT NUMBER

VAT_QTY NUMBER

VAT_CLAIMED_PTG NUMBER

VAT_INVOICE_NO VARCHAR2 (200)
QTY_APPLY NUMBER

SHIPMENT_LINE_ID NUMBER
Yes
OTHER_CENVAT_AMT_FOR_2ND_CLAIM NUMBER

CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

Query Text

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


SELECT MATCH_RECEIPT_ID
,      TRANSACTION_TEMP_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      RECEIPT_NUMBER
,      QUANTITY
,      CENVAT_QTY_AVAILABLE
,      CENVAT_CLAIMED_PTG
,      CENVAT_CLAIMED_AMT
,      OTHER_CENVAT_CLAIMED_AMT
,      CENVAT_AMT_FOR_2ND_CLAIM
,      CENVAT_AMOUNT
,      VAT_QTY
,      VAT_CLAIMED_PTG
,      VAT_INVOICE_NO
,      QTY_APPLY
,      SHIPMENT_LINE_ID
,      OTHER_CENVAT_AMT_FOR_2ND_CLAIM
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM JA.JAI_MTL_MATCH_RECEIPTS#;

Dependencies

[top of page]

JA.JAI_MTL_MATCH_RECEIPTS# references the following:

SchemaJA
TableJAI_MTL_MATCH_RECEIPTS
JA.JAI_MTL_MATCH_RECEIPTS# is referenced by following:

SchemaAPPS
SynonymJAI_MTL_MATCH_RECEIPTS