[Home] [Help] [Dependency Information]
Object Name: | DDR_R_ORG_BSNS_ENT_EXTN# |
---|---|
Object Type: | VIEW |
Owner: | DDR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MFG_ORG_CD | VARCHAR2 | (30) | Yes | |
ORG_BSNS_ENT_ID | NUMBER | Yes | ||
ORG_CD | VARCHAR2 | (30) | Yes | |
BSNS_ENT_CD | VARCHAR2 | (30) | Yes | |
ATTR_NAME_1 | VARCHAR2 | (40) | ||
ATTR_VAL_1 | VARCHAR2 | (40) | ||
ATTR_NAME_2 | VARCHAR2 | (40) | ||
ATTR_VAL_2 | VARCHAR2 | (40) | ||
ATTR_NAME_3 | VARCHAR2 | (40) | ||
ATTR_VAL_3 | VARCHAR2 | (40) | ||
ATTR_NAME_4 | VARCHAR2 | (40) | ||
ATTR_VAL_4 | VARCHAR2 | (40) | ||
ATTR_NAME_5 | VARCHAR2 | (40) | ||
ATTR_VAL_5 | VARCHAR2 | (40) | ||
ATTR_NAME_6 | VARCHAR2 | (40) | ||
ATTR_VAL_6 | VARCHAR2 | (40) | ||
ATTR_NAME_7 | VARCHAR2 | (40) | ||
ATTR_VAL_7 | VARCHAR2 | (40) | ||
ATTR_NAME_8 | VARCHAR2 | (40) | ||
ATTR_VAL_8 | VARCHAR2 | (40) | ||
ATTR_NAME_9 | VARCHAR2 | (40) | ||
ATTR_VAL_9 | VARCHAR2 | (40) | ||
ATTR_NAME_10 | VARCHAR2 | (40) | ||
ATTR_VAL_10 | VARCHAR2 | (40) | ||
ATTR_NAME_11 | VARCHAR2 | (40) | ||
ATTR_VAL_11 | VARCHAR2 | (40) | ||
ATTR_NAME_12 | VARCHAR2 | (40) | ||
ATTR_VAL_12 | VARCHAR2 | (40) | ||
ATTR_NAME_13 | VARCHAR2 | (40) | ||
ATTR_VAL_13 | VARCHAR2 | (40) | ||
ATTR_NAME_14 | VARCHAR2 | (40) | ||
ATTR_VAL_14 | VARCHAR2 | (40) | ||
ATTR_NAME_15 | VARCHAR2 | (40) | ||
ATTR_VAL_15 | VARCHAR2 | (40) | ||
ATTR_NAME_16 | VARCHAR2 | (40) | ||
ATTR_VAL_16 | VARCHAR2 | (40) | ||
ATTR_NAME_17 | VARCHAR2 | (40) | ||
ATTR_VAL_17 | VARCHAR2 | (40) | ||
ATTR_NAME_18 | VARCHAR2 | (40) | ||
ATTR_VAL_18 | VARCHAR2 | (40) | ||
ATTR_NAME_19 | VARCHAR2 | (40) | ||
ATTR_VAL_19 | VARCHAR2 | (40) | ||
ATTR_NAME_20 | VARCHAR2 | (40) | ||
ATTR_VAL_20 | VARCHAR2 | (40) | ||
EFF_FROM_DT | DATE | Yes | ||
EFF_TO_DT | DATE | |||
SRC_SYS_IDNT | VARCHAR2 | (40) | Yes | |
SRC_SYS_DT | DATE | Yes | ||
CRTD_BY_DSR | VARCHAR2 | (30) | Yes | |
LAST_UPDT_BY_DSR | VARCHAR2 | (30) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT MFG_ORG_CD
, ORG_BSNS_ENT_ID
, ORG_CD
, BSNS_ENT_CD
, ATTR_NAME_1
, ATTR_VAL_1
, ATTR_NAME_2
, ATTR_VAL_2
, ATTR_NAME_3
, ATTR_VAL_3
, ATTR_NAME_4
, ATTR_VAL_4
, ATTR_NAME_5
, ATTR_VAL_5
, ATTR_NAME_6
, ATTR_VAL_6
, ATTR_NAME_7
, ATTR_VAL_7
, ATTR_NAME_8
, ATTR_VAL_8
, ATTR_NAME_9
, ATTR_VAL_9
, ATTR_NAME_10
, ATTR_VAL_10
, ATTR_NAME_11
, ATTR_VAL_11
, ATTR_NAME_12
, ATTR_VAL_12
, ATTR_NAME_13
, ATTR_VAL_13
, ATTR_NAME_14
, ATTR_VAL_14
, ATTR_NAME_15
, ATTR_VAL_15
, ATTR_NAME_16
, ATTR_VAL_16
, ATTR_NAME_17
, ATTR_VAL_17
, ATTR_NAME_18
, ATTR_VAL_18
, ATTR_NAME_19
, ATTR_VAL_19
, ATTR_NAME_20
, ATTR_VAL_20
, EFF_FROM_DT
, EFF_TO_DT
, SRC_SYS_IDNT
, SRC_SYS_DT
, CRTD_BY_DSR
, LAST_UPDT_BY_DSR
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM DDR.DDR_R_ORG_BSNS_ENT_EXTN#;
|
|
|