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

TABLE: JA.JAI_RCV_RGM_LINES

Object Details
Object Name: JAI_RCV_RGM_LINES
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_RCV_RGM_LINES
Subobject Name:
Status: VALID


Stores the Line information of receipt claims.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_RCV_RGM_LINES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRCV_RGM_LINE_ID
Columns
Name Datatype Length Mandatory Comments
RCV_RGM_LINE_ID NUMBER (15) Yes Unique Identifier for the Table
SHIPMENT_HEADER_ID NUMBER
Yes Unique Shipment Header Identifier
SHIPMENT_LINE_ID NUMBER
Yes Unique Shipment Line Identifier
LOCATION_ID NUMBER
Yes Unique Identifier for the location
ORGANIZATION_ID NUMBER (15)
Unique Identifier for the Organization
INVENTORY_ITEM_ID NUMBER (15)
Unique Identifier for the Item
RECEIPT_NUM VARCHAR2 (30)
Unique Receipt number
RECEIPT_DATE DATE

Date on which Receipt is made
REGIME_CODE VARCHAR2 (30) Yes Regime Code, of the regime, to which current record belongs
REGIME_ITEM_CLASS VARCHAR2 (30) Yes Item Class for the Item
TRANSACTION_ID NUMBER (15)
Unique Transaction Identifier
RECOVERABLE_AMOUNT NUMBER

Total amount to be recovered
RECOVERED_AMOUNT NUMBER

Total recovered amount
PROCESS_STATUS_FLAG VARCHAR2 (1)
Status of the current line. The different values and meanings are - "N" - Not Claimed, "P" - Partial Claimed, "F" - Full Claimed, "X" - Non-Claimable
TERM_ID NUMBER (15)
Unique Term Identifier linked with the Transaction
INVOICE_NO VARCHAR2 (240)
Invoice Number for the Transaction
INVOICE_DATE DATE

Invoice Date for the Transaction
VENDOR_ID NUMBER (15)
Unique Supplier Identifier, for which the invoice is created
VENDOR_SITE_ID NUMBER (15)
Unique Supplier Site Identifier, for which the invoice is created
RECEIPT_SOURCE_CODE VARCHAR2 (25)
Source of the Receipt. The different values can be - CUSTOMER, INTERNAL ORDER, VENDOR
RECEIVE_QTY NUMBER

Quantity, for which RECEIVE Transaction is done
CORRECT_RECEIVE_QTY NUMBER

Quantity, for CORRECT OF RECEIVE Transaction is done
RTV_QTY NUMBER

Quantity, for which RETURN TO VENDOR Transaction is done
CORRECT_RTV_QTY NUMBER

Quantity, for CORRECT OF RETURN TO VENDOR Transaction is done
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number.
BATCH_NUM NUMBER (15)
Unique Identifier for the Group of lines, to be claimed
Query Text

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


SELECT RCV_RGM_LINE_ID
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      RECEIPT_NUM
,      RECEIPT_DATE
,      REGIME_CODE
,      REGIME_ITEM_CLASS
,      TRANSACTION_ID
,      RECOVERABLE_AMOUNT
,      RECOVERED_AMOUNT
,      PROCESS_STATUS_FLAG
,      TERM_ID
,      INVOICE_NO
,      INVOICE_DATE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      RECEIPT_SOURCE_CODE
,      RECEIVE_QTY
,      CORRECT_RECEIVE_QTY
,      RTV_QTY
,      CORRECT_RTV_QTY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      BATCH_NUM
FROM JA.JAI_RCV_RGM_LINES;

Dependencies

[top of page]

JA.JAI_RCV_RGM_LINES does not reference any database object

JA.JAI_RCV_RGM_LINES is referenced by following:

SchemaAPPS
SynonymJAI_RCV_RGM_LINES