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

TABLE: GML.GML_RECV_TRANS_MAP

Object Details
Object Name: GML_RECV_TRANS_MAP
Object Type: TABLE
Owner: GML
FND Design Data: TableGML.GML_RECV_TRANS_MAP
Subobject Name:
Status: VALID


This table contains the mapping of Receipt transactions in OPM to Receiving transactions in Oracle Receiving. This table is part of the OPM Common Purchasing Integration with Oracle Purchasing. Receipts are created in OPM and then a corresponding receipt is created in Oracle Purchasing. This table maps the two transactions.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GML_RECV_TRANS_MAP_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECV_ID
ColumnLINE_ID
Columns
Name Datatype Length Mandatory Comments
RECV_ID NUMBER
Yes recv_id from po_recv_hdr
LINE_ID NUMBER
Yes line_id from po_recv_dtl
INTERFACE_TRANSACTION_ID NUMBER

interface_transaction_id used for insert into rcv_transactions_interface table
GROUP_ID NUMBER

group_id used for insert into rcv_transactions_interface table
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER (15) Yes Standard WHO column
ORGANIZATION_ID NUMBER

Organization ID
RCV_RECEIPT_NUM NUMBER

Receiving receipt number
Query Text

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


SELECT RECV_ID
,      LINE_ID
,      INTERFACE_TRANSACTION_ID
,      GROUP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ORGANIZATION_ID
,      RCV_RECEIPT_NUM
FROM GML.GML_RECV_TRANS_MAP;

Dependencies

[top of page]

GML.GML_RECV_TRANS_MAP does not reference any database object

GML.GML_RECV_TRANS_MAP is referenced by following:

SchemaAPPS
SynonymGML_RECV_TRANS_MAP