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_CMN_MATCH_RECEIPTS

Object Details

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

Records the matching details of Issues against the Receipt in a trading organization

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_CMN_MATCH_RECEIPTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	RECEIPT_ID REF_LINE_ID ORDER_INVOICE
JAI_CMN_MATCH_RECEIPTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REF_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RECEIPT_ID	NUMBER		Yes	Indicates the Receipt, basically a receipt transaction in RG23D register. foreign key to JA_IN_RG23_D.register_id.
REF_LINE_ID	NUMBER		Yes	Indicates Delivery_detail_id or customer_trx_line_id based on whether the transaction is done in Order Management or Receivables.
SUBINVENTORY	VARCHAR2	(20)		Indicates the subinventory from where the matching is done.
QUANTITY_APPLIED	NUMBER		Yes	Indicates delivery detail quantity applied on receipt in Delivery detail UOM.
ISSUE_UOM	VARCHAR2	(3)		Indicates delivery detail UOM of the quantity.
ORDER_INVOICE	VARCHAR2	(2)	Yes	Indicates whether the matching is done for Sales Order or AR Invoice. possible values `O` for Order, `I` for Invoice.
SHIP_STATUS	VARCHAR2	(8)		Indicates the status of delivery detail or customer trx line. possible values are NULL or `CLOSED`.
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER			Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
LAST_UPDATED_BY	NUMBER			Standard Who column
RECEIPT_QUANTITY_APPLIED	NUMBER			Indicates Quantity applied in receipt UOM.
RECEIPT_QUANTITY_UOM	VARCHAR2	(4)		Indicates Receipt Quantity UOM.
REF_LINE_NO	NUMBER	(4)		Reference Line num
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number

Query Text

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


SELECT RECEIPT_ID
,      REF_LINE_ID
,      SUBINVENTORY
,      QUANTITY_APPLIED
,      ISSUE_UOM
,      ORDER_INVOICE
,      SHIP_STATUS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      RECEIPT_QUANTITY_APPLIED
,      RECEIPT_QUANTITY_UOM
,      REF_LINE_NO
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_CMN_MATCH_RECEIPTS;

Dependencies

[top of page]

JA.JAI_CMN_MATCH_RECEIPTS does not reference any database object

JA.JAI_CMN_MATCH_RECEIPTS is referenced by following:

APPS: JAI_CMN_MATCH_RECEIPTS; JAI_JCMR_ARIUD_T1