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


TABLE: BIM.BIM_I_PARTY_SGMT_STG

Object Details
Object Name: BIM_I_PARTY_SGMT_STG
Object Type: TABLE
Owner: BIM
Subobject Name:
Status: VALID


Party Market Segment Staging table


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SEGMENT_ID NUMBER

Segment ID
PARTY_ID NUMBER

Party ID
START_DATE_ACTIVE DATE

Start Date Active
END_DATE_ACTIVE DATE

End Date Active
STATUS VARCHAR2 (1)
Status
ACCOUNT_OPEN_DATE DATE

Account Open Date
ACCOUNT_CLOSE_DATE DATE

Account Close Date
Query Text

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


SELECT SEGMENT_ID
,      PARTY_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      ACCOUNT_OPEN_DATE
,      ACCOUNT_CLOSE_DATE
FROM BIM.BIM_I_PARTY_SGMT_STG;

Dependencies

[top of page]

BIM.BIM_I_PARTY_SGMT_STG does not reference any database object

BIM.BIM_I_PARTY_SGMT_STG is referenced by following:

SchemaAPPS
SynonymBIM_I_PARTY_SGMT_STG