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]

TABLE: JA.JAI_RCV_LINES

Object Details

Object Name:	JAI_RCV_LINES
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_RCV_LINES
Subobject Name:
Status:	VALID

Stores localization related info for the receipt line.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_RCV_LINES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SHIPMENT_LINE_ID
JAI_RCV_LINES_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
JAI_RCV_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECEIPT_NUM
JAI_RCV_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIPMENT_HEADER_ID
JAI_RCV_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXCISE_INVOICE_NO

Columns

Name	Datatype	Length	Mandatory	Comments
SHIPMENT_LINE_ID	NUMBER	(15)	Yes	Shipment line identifier.
SHIPMENT_HEADER_ID	NUMBER	(15)		Shipment header identifier.
RECEIPT_NUM	VARCHAR2	(30)		Receipt number.
QTY_RECEIVED	NUMBER			Quantity Received.
CLAIM_MODVAT_FLAG	VARCHAR2	(1)		Indicates modvat claim status.
BOE_NUMBER	VARCHAR2	(30)		No longer used
EXCISE_INVOICE_NO	VARCHAR2	(30)		Excise invoice number.
EXCISE_INVOICE_DATE	DATE			Excise invoice date.
TAX_MODIFIED_FLAG	VARCHAR2	(1)		Possible values are Y and N. A value of Y indicates taxes can be modified.
LINE_LOCATION_ID	NUMBER	(15)		Line location identifier.
TAX_AMOUNT	NUMBER			Tax amount.
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
BOE_APPLIED_FLAG	VARCHAR2	(1)		Possible values are Y and N. Indicates if BOE has already been applied.
PROCESS_RECEIVING	VARCHAR2	(2)		Indicates the status of receiving a/c and register entries for the line. Possible values are Y->processed, N -> to be processed, X-> not to applicable.
PROCESS_DELIVERY	VARCHAR2	(2)		Indicates the status of delivery a/c and register entries for the line. Possible values are Y->processed, N -> to be processed, X-> not to applicable.
PROCESS_THIRD_PARTY_INV	VARCHAR2	(2)		Indicates the status of third party invoice generation for the line. Possible values are Y->processed, N -> to be processed, X-> not to applicable.
PROCESS_MODVAT	VARCHAR2	(2)		Indicates the status of modvat a/c and register entries for the line. Possible values are Y->processed, N -> to be processed, X-> not to applicable.
PROCESS_RG	VARCHAR2	(2)		Indicates the status of RG a/c and register entries for the line. Possible values are Y->processed, N -> to be processed, X-> not to applicable.
TRANSACTION_ID	NUMBER			RCV transaction identifier.
ORGANIZATION_ID	NUMBER			Inventory organization identifier.
PROCESS_POPULATE_CENVAT	VARCHAR2	(2)		Indicates if JAI_RCV_CENVAT_CLAIMS has been populated. Possible values are Y->populated, N -> to be populated, X-> not to be populated.
PROCESS_RTR	VARCHAR2	(2)		Reserved for future use.
PROCESS_RTV	VARCHAR2	(2)		Reserved for future use.
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier.
ONLINE_CLAIM_FLAG	VARCHAR2	(1)		Flag indicates whether online claim is allowed or not
RMA_TYPE	VARCHAR2	(150)		RMA type
MFG_TRADING	VARCHAR2	(2)		Possible values NY and YN. First character indicates if it is a manufacturing organization and the second flag indicates if it is a trading organization.
OBJECT_VERSION_NUMBER	NUMBER			Object version number

Query Text

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


SELECT SHIPMENT_LINE_ID
,      SHIPMENT_HEADER_ID
,      RECEIPT_NUM
,      QTY_RECEIVED
,      CLAIM_MODVAT_FLAG
,      BOE_NUMBER
,      EXCISE_INVOICE_NO
,      EXCISE_INVOICE_DATE
,      TAX_MODIFIED_FLAG
,      LINE_LOCATION_ID
,      TAX_AMOUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      BOE_APPLIED_FLAG
,      PROCESS_RECEIVING
,      PROCESS_DELIVERY
,      PROCESS_THIRD_PARTY_INV
,      PROCESS_MODVAT
,      PROCESS_RG
,      TRANSACTION_ID
,      ORGANIZATION_ID
,      PROCESS_POPULATE_CENVAT
,      PROCESS_RTR
,      PROCESS_RTV
,      INVENTORY_ITEM_ID
,      ONLINE_CLAIM_FLAG
,      RMA_TYPE
,      MFG_TRADING
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_RCV_LINES;

Dependencies

[top of page]

JA.JAI_RCV_LINES does not reference any database object

JA.JAI_RCV_LINES is referenced by following:

APPS: JAI_RCV_LINES