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

VIEW: JA.JAI_RCV_RGM_CLAIMS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
CLAIM_SCHEDULE_ID NUMBER (15) Yes
RCV_RGM_LINE_ID NUMBER (15) Yes
SHIPMENT_HEADER_ID NUMBER
Yes
SHIPMENT_LINE_ID NUMBER
Yes
REGIME_CODE VARCHAR2 (30) Yes
TAX_TRANSACTION_ID NUMBER (15)
TRANSACTION_TYPE VARCHAR2 (25) Yes
TRANSACTION_ID NUMBER
Yes
PARENT_TRANSACTION_TYPE VARCHAR2 (25)
INSTALLMENT_NO NUMBER (15) Yes
INSTALLMENT_AMOUNT NUMBER

CLAIMED_AMOUNT NUMBER

SCHEDULED_DATE DATE
Yes
CLAIMED_DATE DATE

STATUS VARCHAR2 (25)
MANUAL_CLAIM_FLAG VARCHAR2 (1)
REMARKS VARCHAR2 (240)
TAX_TYPE VARCHAR2 (30)
TAX_ID NUMBER (15)
TRX_TAX_ID NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9)
Query Text

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


SELECT CLAIM_SCHEDULE_ID
,      RCV_RGM_LINE_ID
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      REGIME_CODE
,      TAX_TRANSACTION_ID
,      TRANSACTION_TYPE
,      TRANSACTION_ID
,      PARENT_TRANSACTION_TYPE
,      INSTALLMENT_NO
,      INSTALLMENT_AMOUNT
,      CLAIMED_AMOUNT
,      SCHEDULED_DATE
,      CLAIMED_DATE
,      STATUS
,      MANUAL_CLAIM_FLAG
,      REMARKS
,      TAX_TYPE
,      TAX_ID
,      TRX_TAX_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_RCV_RGM_CLAIMS#;

Dependencies

[top of page]

JA.JAI_RCV_RGM_CLAIMS# references the following:

SchemaJA
TableJAI_RCV_RGM_CLAIMS
JA.JAI_RCV_RGM_CLAIMS# is referenced by following:

SchemaAPPS
SynonymJAI_RCV_RGM_CLAIMS