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

TABLE: FUN.FUN_SUBSIDIARY_PARTY_MAPPINGS

Object Details
Object Name: FUN_SUBSIDIARY_PARTY_MAPPINGS
Object Type: TABLE
Owner: FUN
FND Design Data: TableFUN.FUN_SUBSIDIARY_PARTY_MAPPINGS
Subobject Name:
Status: VALID

FUN_SUBSIDIARY_PARTY_MAPPINGS is used to upgrade GL Subsidiaries as Intercompany Organizations. This table is not used once the organizations and transactions have been upgraded.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FUN_SUBSIDIARY_PARTY_MAP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUBSIDIARY_ID
Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER

Party id of the newly created orgaination. Foreign key to HZ_PARTIES.PARTY_ID
SUBSIDIARY_ID NUMBER

Id of the subsidiary being upgraded
CREATED_BY NUMBER

Standard Who column.
CREATION_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER

Standard Who column.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATE_LOGIN NUMBER

Standard Who column.
LEDGER_ID NUMBER

Ledger that the subsidiary is using. Upgraded from Gl_iea_subsidiaries.sets_of_books_id
LEGAL_ENTITY_ID NUMBER

Legal Entity that the Intercompany organization is associated with
Query Text

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


SELECT PARTY_ID
,      SUBSIDIARY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LEDGER_ID
,      LEGAL_ENTITY_ID
FROM FUN.FUN_SUBSIDIARY_PARTY_MAPPINGS;

Dependencies

[top of page]

FUN.FUN_SUBSIDIARY_PARTY_MAPPINGS does not reference any database object

FUN.FUN_SUBSIDIARY_PARTY_MAPPINGS is referenced by following:

SchemaAPPS
SynonymFUN_SUBSIDIARY_PARTY_MAPPINGS