[Home] [Help] [Dependency Information]
Object Name: | HZ_IMP_CONTACTS_SG# |
---|---|
Object Type: | VIEW |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (15) | ||
BATCH_MODE_FLAG | VARCHAR2 | (1) | ||
ACTION_FLAG | VARCHAR2 | (1) | ||
ERROR_FLAG | VARCHAR2 | (1) | ||
INT_ROW_ID | ROWID | (10) | ||
PARTY_ACTION_FLAG | VARCHAR2 | (1) | ||
CONTACT_ID | NUMBER | (15) | ||
RELATIONSHIP_TYPE | VARCHAR2 | (30) | ||
RELATIONSHIP_CODE | VARCHAR2 | (30) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
CONTACT_ORIG_SYSTEM | VARCHAR2 | (30) | ||
SUB_ORIG_SYSTEM | VARCHAR2 | (30) | ||
OBJ_ID | NUMBER | (15) | ||
SUB_ID | NUMBER | (15) | ||
CONTACT_ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | ||
SUB_ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, BATCH_MODE_FLAG
, ACTION_FLAG
, ERROR_FLAG
, INT_ROW_ID
, PARTY_ACTION_FLAG
, CONTACT_ID
, RELATIONSHIP_TYPE
, RELATIONSHIP_CODE
, START_DATE
, END_DATE
, CONTACT_ORIG_SYSTEM
, SUB_ORIG_SYSTEM
, OBJ_ID
, SUB_ID
, CONTACT_ORIG_SYSTEM_REFERENCE
, SUB_ORIG_SYSTEM_REFERENCE
FROM AR.HZ_IMP_CONTACTS_SG#;
|
|
|