[Home] [Help] [Dependency Information]
Object Name: | T_SRC_LOC_TMPL# |
---|---|
Object Type: | VIEW |
Owner: | MSD |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LR1_ATTR1 | VARCHAR2 | (100) | ||
LR1_ATTR2 | VARCHAR2 | (100) | ||
T_EP_L_ATT_1 | VARCHAR2 | (100) | ||
T_EP_L_ATT_10 | VARCHAR2 | (100) | ||
T_EP_L_ATT_2 | VARCHAR2 | (100) | ||
T_EP_L_ATT_3 | VARCHAR2 | (100) | ||
T_EP_L_ATT_4 | VARCHAR2 | (100) | ||
T_EP_L_ATT_5 | VARCHAR2 | (100) | ||
T_EP_L_ATT_6 | VARCHAR2 | (100) | ||
T_EP_L_ATT_7 | VARCHAR2 | (100) | ||
T_EP_L_ATT_8 | VARCHAR2 | (100) | ||
T_EP_L_ATT_9 | VARCHAR2 | (100) | ||
T_EP_LR1 | VARCHAR2 | (100) | ||
T_EP_LR2 | VARCHAR2 | (100) | ||
T_EP_LR2A | VARCHAR2 | (100) | ||
T_EP_LS1 | VARCHAR2 | (100) | ||
T_EP_LS2 | VARCHAR2 | (100) | ||
T_EP_LS3 | VARCHAR2 | (100) | ||
T_EP_LS4 | VARCHAR2 | (100) | ||
T_EP_LS5 | VARCHAR2 | (100) | ||
T_EP_LS6 | VARCHAR2 | (100) | ||
DM_SITE_CODE | VARCHAR2 | (240) | ||
DM_SITE_DESC | VARCHAR2 | (240) | ||
DM_ORG_CODE | VARCHAR2 | (240) | ||
DM_ORG_DESC | VARCHAR2 | (240) | ||
E1_BRANCH_CITY | VARCHAR2 | (100) | ||
E1_BRANCH_STATE | VARCHAR2 | (100) | ||
E1_BRANCH_COUNTRY | VARCHAR2 | (100) | ||
E1_BRANCH_ZIP_CODE | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_1 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_2 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_3 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_4 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_5 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_6 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_7 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_8 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_9 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_10 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_11 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_12 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_13 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_14 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_15 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_16 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_17 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_18 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_19 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_20 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_21 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_22 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_23 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_24 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_25 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_26 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_27 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_28 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_29 | VARCHAR2 | (100) | ||
E1_BRANCH_CATEGORY_30 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CITY | VARCHAR2 | (100) | ||
E1_CUSTOMER_STATE | VARCHAR2 | (100) | ||
E1_CUSTOMER_COUNTRY | VARCHAR2 | (100) | ||
E1_CUSTOMER_BUSINESS_UNIT | VARCHAR2 | (100) | ||
E1_CUSTOMER_MAILING_NAME | VARCHAR2 | (100) | ||
E1_CUSTOMER_ZIP_CODE | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_1 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_2 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_3 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_4 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_5 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_6 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_7 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_8 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_9 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_10 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_11 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_12 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_13 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_14 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_15 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_16 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_17 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_18 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_19 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_20 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_21 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_22 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_23 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_24 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_25 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_26 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_27 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_28 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_29 | VARCHAR2 | (100) | ||
E1_CUSTOMER_CATEGORY_30 | VARCHAR2 | (100) | ||
EBS_TP_ZONE_CODE | VARCHAR2 | (240) | ||
EBS_TP_ZONE_DESC | VARCHAR2 | (240) | ||
EBS_ZONE_CODE | VARCHAR2 | (240) | ||
EBS_ZONE_DESC | VARCHAR2 | (240) | ||
EBS_ACCOUNT_CODE | VARCHAR2 | (240) | ||
EBS_ACCOUNT_DESC | VARCHAR2 | (240) | ||
EBS_CUSTOMER_CODE | VARCHAR2 | (240) | ||
EBS_CUSTOMER_DESC | VARCHAR2 | (240) | ||
EBS_CUSTOMER_CLASS_CODE | VARCHAR2 | (240) | ||
EBS_CUSTOMER_CLASS_DESC | VARCHAR2 | (240) | ||
EBS_OPERATION_UNIT_CODE | VARCHAR2 | (240) | ||
EBS_OPERATION_UNIT_DESC | VARCHAR2 | (240) | ||
EBS_BUSINESS_GROUP_CODE | VARCHAR2 | (240) | ||
EBS_BUSINESS_GROUP_DESC | VARCHAR2 | (240) | ||
EBS_LEGAL_ENTITY_CODE | VARCHAR2 | (240) | ||
EBS_LEGAL_ENTITY_DESC | VARCHAR2 | (240) | ||
EBS_SALES_CHANNEL_CODE | VARCHAR2 | (240) | ||
EBS_SALES_CHANNEL_DESC | VARCHAR2 | (240) | ||
EBS_SITE_DEST_KEY | NUMBER | (10) | ||
EBS_ORG_DEST_KEY | NUMBER | (10) | ||
EBS_SALES_CHANNEL_DEST_KEY | NUMBER | (10) | ||
EBS_SUPPLIER_CODE | VARCHAR2 | (240) | ||
EBS_SUPPLIER_DESC | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT LR1_ATTR1
, LR1_ATTR2
, T_EP_L_ATT_1
, T_EP_L_ATT_10
, T_EP_L_ATT_2
, T_EP_L_ATT_3
, T_EP_L_ATT_4
, T_EP_L_ATT_5
, T_EP_L_ATT_6
, T_EP_L_ATT_7
, T_EP_L_ATT_8
, T_EP_L_ATT_9
, T_EP_LR1
, T_EP_LR2
, T_EP_LR2A
, T_EP_LS1
, T_EP_LS2
, T_EP_LS3
, T_EP_LS4
, T_EP_LS5
, T_EP_LS6
, DM_SITE_CODE
, DM_SITE_DESC
, DM_ORG_CODE
, DM_ORG_DESC
, E1_BRANCH_CITY
, E1_BRANCH_STATE
, E1_BRANCH_COUNTRY
, E1_BRANCH_ZIP_CODE
, E1_BRANCH_CATEGORY_1
, E1_BRANCH_CATEGORY_2
, E1_BRANCH_CATEGORY_3
, E1_BRANCH_CATEGORY_4
, E1_BRANCH_CATEGORY_5
, E1_BRANCH_CATEGORY_6
, E1_BRANCH_CATEGORY_7
, E1_BRANCH_CATEGORY_8
, E1_BRANCH_CATEGORY_9
, E1_BRANCH_CATEGORY_10
, E1_BRANCH_CATEGORY_11
, E1_BRANCH_CATEGORY_12
, E1_BRANCH_CATEGORY_13
, E1_BRANCH_CATEGORY_14
, E1_BRANCH_CATEGORY_15
, E1_BRANCH_CATEGORY_16
, E1_BRANCH_CATEGORY_17
, E1_BRANCH_CATEGORY_18
, E1_BRANCH_CATEGORY_19
, E1_BRANCH_CATEGORY_20
, E1_BRANCH_CATEGORY_21
, E1_BRANCH_CATEGORY_22
, E1_BRANCH_CATEGORY_23
, E1_BRANCH_CATEGORY_24
, E1_BRANCH_CATEGORY_25
, E1_BRANCH_CATEGORY_26
, E1_BRANCH_CATEGORY_27
, E1_BRANCH_CATEGORY_28
, E1_BRANCH_CATEGORY_29
, E1_BRANCH_CATEGORY_30
, E1_CUSTOMER_CITY
, E1_CUSTOMER_STATE
, E1_CUSTOMER_COUNTRY
, E1_CUSTOMER_BUSINESS_UNIT
, E1_CUSTOMER_MAILING_NAME
, E1_CUSTOMER_ZIP_CODE
, E1_CUSTOMER_CATEGORY_1
, E1_CUSTOMER_CATEGORY_2
, E1_CUSTOMER_CATEGORY_3
, E1_CUSTOMER_CATEGORY_4
, E1_CUSTOMER_CATEGORY_5
, E1_CUSTOMER_CATEGORY_6
, E1_CUSTOMER_CATEGORY_7
, E1_CUSTOMER_CATEGORY_8
, E1_CUSTOMER_CATEGORY_9
, E1_CUSTOMER_CATEGORY_10
, E1_CUSTOMER_CATEGORY_11
, E1_CUSTOMER_CATEGORY_12
, E1_CUSTOMER_CATEGORY_13
, E1_CUSTOMER_CATEGORY_14
, E1_CUSTOMER_CATEGORY_15
, E1_CUSTOMER_CATEGORY_16
, E1_CUSTOMER_CATEGORY_17
, E1_CUSTOMER_CATEGORY_18
, E1_CUSTOMER_CATEGORY_19
, E1_CUSTOMER_CATEGORY_20
, E1_CUSTOMER_CATEGORY_21
, E1_CUSTOMER_CATEGORY_22
, E1_CUSTOMER_CATEGORY_23
, E1_CUSTOMER_CATEGORY_24
, E1_CUSTOMER_CATEGORY_25
, E1_CUSTOMER_CATEGORY_26
, E1_CUSTOMER_CATEGORY_27
, E1_CUSTOMER_CATEGORY_28
, E1_CUSTOMER_CATEGORY_29
, E1_CUSTOMER_CATEGORY_30
, EBS_TP_ZONE_CODE
, EBS_TP_ZONE_DESC
, EBS_ZONE_CODE
, EBS_ZONE_DESC
, EBS_ACCOUNT_CODE
, EBS_ACCOUNT_DESC
, EBS_CUSTOMER_CODE
, EBS_CUSTOMER_DESC
, EBS_CUSTOMER_CLASS_CODE
, EBS_CUSTOMER_CLASS_DESC
, EBS_OPERATION_UNIT_CODE
, EBS_OPERATION_UNIT_DESC
, EBS_BUSINESS_GROUP_CODE
, EBS_BUSINESS_GROUP_DESC
, EBS_LEGAL_ENTITY_CODE
, EBS_LEGAL_ENTITY_DESC
, EBS_SALES_CHANNEL_CODE
, EBS_SALES_CHANNEL_DESC
, EBS_SITE_DEST_KEY
, EBS_ORG_DEST_KEY
, EBS_SALES_CHANNEL_DEST_KEY
, EBS_SUPPLIER_CODE
, EBS_SUPPLIER_DESC
FROM MSD.T_SRC_LOC_TMPL#;
|
|
|