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

TABLE: PO.PO_UDA_MAPPINGS

Object Details
Object Name: PO_UDA_MAPPINGS
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_UDA_MAPPINGS
Subobject Name:
Status: VALID


This table stores the mapping between dummy attribute groups ids and corresponding real attribute group ids. On the Attribute Group definition pages, the attribute groups are defined against a dummy attribute group type. When the attribute group is enabled for one or more business entities ( such as Purchase order Header, Requisition line, etc.) , a sync api creates attribute group definition for the corresponding real attribute group type. The correspondence information for the attribute group between different business entities is stored in this table. This information is used for propagating UDA data from one document to the other during Autocreate.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_UDA_MAPPINGS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDUMMY_ATTRIBUTE_GROUP_ID
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
DUMMY_ATTRIBUTE_GROUP_ID NUMBER
Yes Attribute Group ID pertaining to Dummy Attribute Group
PO_HEADER_GROUP_ID NUMBER

Attribute Group ID pertaining to PO Header Attribute Group
PO_LINE_GROUP_ID NUMBER

Attribute Group ID pertaining to PO Line Attribute Group
PO_DISTRIBUTIONS_GROUP_ID NUMBER

Attribute Group ID pertaining to PO Distribution Attribute Group
PO_SHIPMENTS_GROUP_ID NUMBER

Attribute Group ID pertaining to PO Shipment Attribute Group
REQ_HEADER_GROUP_ID NUMBER

Attribute Group ID pertaining to Requisition Header Attribute Group
REQ_LINE_GROUP_ID NUMBER

Attribute Group ID pertaining to Requisition Line Attribute Group
REQ_DISTRIBUTION_GROUP_ID NUMBER

Attribute Group ID pertaining to Requisition Distribution Attribute Group
PON_AUC_ITEM_PRICE_GROUP_ID NUMBER

Attribute Group ID pertaining to Auction Line Attribute Group
PON_AUC_HEADER_GROUP_ID NUMBER

Attribute Group ID pertaining to Auction Header Attribute Group
BID_HEADER_GROUP_ID NUMBER

Attribute Group ID pertaining to Bid Header Attribute Group
BID_ITEM_PRICE_GROUP_ID NUMBER

Attribute Group ID pertaining to Bid Line Attribute Group
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT DUMMY_ATTRIBUTE_GROUP_ID
,      PO_HEADER_GROUP_ID
,      PO_LINE_GROUP_ID
,      PO_DISTRIBUTIONS_GROUP_ID
,      PO_SHIPMENTS_GROUP_ID
,      REQ_HEADER_GROUP_ID
,      REQ_LINE_GROUP_ID
,      REQ_DISTRIBUTION_GROUP_ID
,      PON_AUC_ITEM_PRICE_GROUP_ID
,      PON_AUC_HEADER_GROUP_ID
,      BID_HEADER_GROUP_ID
,      BID_ITEM_PRICE_GROUP_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM PO.PO_UDA_MAPPINGS;

Dependencies

[top of page]

PO.PO_UDA_MAPPINGS does not reference any database object

PO.PO_UDA_MAPPINGS is referenced by following:

SchemaPO
ViewPO_UDA_MAPPINGS#