エンタープライズ管理 > Windchill ESI の実装 > ORACLE Applications 環境での Windchill ESI の実装 > Oracle Applications API と OIT の構造 > Oracle Applications のオブジェクトの詳細 > ESISYSL スキーマオブジェクト
  
ESISYSL スキーマオブジェクト
以下のオブジェクトが ESISYSL スキーマに表示されます。
MasterConfiguration_OpenItem_all_Mods.sql
テーブル名
Select
Insert
更新
「削除」
TIB_INT_MTL_SYS_ITEMS_IFACE
X
X
X
TIB_MTL_ITEMS_IFACE_EXCP
TIB_INT_MTL_ITEM_REV_IFACE
X
X
TIB_MTL_ITEM_REV_EXCP
TIB_INT_MTL_ITEM_CATGER_IFACE
X
X
TIB_MTL_ITEM_CATGER_IFACE_EXCP
ESI_LOCKTABLE
シノニム
MTL_PARAMETERS
MTL_SYSTEM_ITEMS
シーケンス
TIB_INT_MTL_SYS_ITEMS_IFACE_S
PTC_JOB_PROCESS_SET
索引
テーブル名
列名
IDX_TIB_INT_MTL_SYS_ITEMS_IFA0
TIB_INT_MTL_SYS_ITEMS_IFACE
TIBCO_INT_PROCESS_FLAG
IDX_TIB_INT_MTL_ITEM_REV_IFAC1
TIB_INT_MTL_ITEM_REV_IFACE
TIBCO_KEY
IDX_TIB_INT_MTL_ITEM_CATGER_I2
TIB_INT_MTL_ITEM_CATGER_IFACE
TIBCO_KEY
MasterConfiguration_BillsOfMtlAPI_all_Mods.sqlv
テーブル名
Select
Insert
更新
「削除」
TIB_INT_BOM_API_HDR
X
X
X
TIB_INT_BOM_API_HDR_EXCP
TIB_INT_BOM_API_INV_COMP
X
X
TIB_INT_BOM_API_INV_COMP_EXCP
TIB_INT_BOM_API_REF_DESG
X
X
TIB_INT_BOM_API_REF_DESG_EXCP
TIB_INT_BOM_API_SUBS_COMP
X
X
TIB_INT_BOM_API_SUBS_COMP_EXCP
TIB_INT_BOM_API_ITM_REV
X
X
TIB_INT_BOM_API_ITM_REV_EXCP
TIB_INT_BOM_API_COMP_OPS
TIB_INT_BOM_API_COMP_OPS_EXCP
索引
テーブル名
列名
TIB_INT_BOM_API_HDR_N1
TIB_INT_BOM_API_HDR
ASSEMBLY_ITEM_NAME、ORGANIZATION_CODE、ALTERNATE_BOM_CODE、TIBCO_KEY、TIBCO_INT_PROCESS_FLAG
TIB_INT_BOM_API_HDR_N2
TIB_INT_BOM_API_HDR
ASSEMBLY_ITEM_NAME、ORGANIZATION_CODE、ALTERNATE_BOM_CODE
TIB_INT_BOM_API_HDR_N3
TIB_INT_BOM_API_HDR
TIBCO_KEY
TIB_INT_BOM_API_INV_CMP_N1
TIB_INT_BOM_API_INV_COMP
ORGANIZATION_CODE、ASSEMBLY_ITEM_NAME、ALTERNATE_BOM_CODE
TIB_INT_BOM_API_INV_CMP_N2
TIB_INT_BOM_API_INV_COMP
TIBCO_KEY
TIB_INT_BOM_API_ITM_REV_N1
TIB_INT_BOM_API_ITM_REV
ASSEMBLY_ITEM_NAME、ORGANIZATION_CODE
TIB_INT_BOM_API_ITM_REV_N2
TIB_INT_BOM_API_ITM_REV
TIBCO_KEY
TIB_INT_BOM_API_REF_DESG_N1
TIB_INT_BOM_API_REF_DESG
ORGANIZATION_CODE、ASSEMBLY_ITEM_NAME、START_EFFECTIVE_DATE、OPERATION_SEQUENCE_NUMBER、COMPONENT_ITEM_NAME、ALTERNATE_BOM_CODE
TIB_INT_BOM_API_REF_DESG_N2
TIB_INT_BOM_API_REF_DESG
TIBCO_KEY
TIB_INT_BOM_API_SUBS_CMP_N1
TIB_INT_BOM_API_SUBS_COMP
ORGANIZATION_CODE、ASSEMBLY_ITEM_NAME、START_EFFECTIVE_DATE、OPERATION_SEQUENCE_NUMBER、COMPONENT_ITEM_NAME、ALTERNATE_BOM_CODE
TIB_INT_BOM_API_SUBS_COMP_N2
TIB_INT_BOM_API_SUBS_COMP
TIBCO_KEY
TIB_INT_BOM_API_COMP_OPS_N1
TIB_INT_BOM_API_COMP_OPS
ORGANIZATION_CODE、ASSEMBLY_ITEM_NAME、ALTERNATE_BOM_CODE
TIB_INT_BOM_API_COMP_OPS_N2
TIB_INT_BOM_API_COMP_OPS
TIBCO_KEY
シーケンス
TIB_INT_BOM_API_HDR_S
BOM_BILL_OF_MATERIALS
BOM_INVENTORY_COMPONENTS
MasterConfiguration_Routing_BOM_do.sql
テーブル名
Select
Insert
更新
「削除」
PTC_INT_RTG_API_HDR
X
X
X
PTC_INT_RTG_API_HDR_EXCP
PTC_INT_RTG_API_REV
X
X
PTC_INT_RTG_API_REV_EXCP
PTC_INT_RTG_API_OPR
X
X
PTC_INT_RTG_API_OPR_EXCP
PTC_INT_RTG_API_OPR_RES
X
X
PTC_INT_RTG_API_OPR_RES_EXCP
索引
テーブル名
列名
PTC_INT_RTG_API_HDR_N1
PTC_INT_RTG_API_HDR
ASSEMBLY_ITEM_NAME、ORGANIZATION_CODE、ALTERNATE_ROUTING_CODE、TIBCO_KEY、TIBCO_INT_PROCESS_FLAG
PTC_INT_RTG_API_HDR_N2
PTC_INT_RTG_API_HDR
ASSEMBLY_ITEM_NAME、ORGANIZATION_CODE、ALTERNATE_BOM_CODE
PTC_INT_RTG_API_HDR_N3
PTC_INT_RTG_API_HDR
TIBCO_KEY
PTC_INT_RTG_API_REV_N1
PTC_INT_RTG_API_REV
ASSEMBLY_ITEM_NAME、ORGANIZATION_CODE
PTC_INT_RTG_API_REV_N2
PTC_INT_RTG_API_REV
TIBCO_KEY
PTC_INT_RTG_API_OPR_N1
PTC_INT_RTG_API_OPR
ASSEMBLY_ITEM_NAME、ORGANIZATION_CODE、ALTERNATE_ROUTING_CODE、START_EFFECTIVE_DATE
PTC_INT_RTG_API_OPR_N2
PTC_INT_RTG_API_OPR
ASSEMBLY_ITEM_NAME、ORGANIZATION_CODE、ALTERNATE_ROUTING_CODE、START_EFFECTIVE_DATE、OPERATION_SEQUENCE_NUMBER
PTC_INT_RTG_API_OPR_N3
PTC_INT_RTG_API_OPR
TIBCO_KEY
PTC_INT_RTG_API_OPR_RES_N1
PTC_INT_RTG_API_OPR_RES
ASSEMBLY_ITEM_NAME、ORGANIZATION_CODE、ALTERNATE_ROUTING_CODE、OP_START_EFFECTIVE_DATE、OPERATION_SEQUENCE_NUMBER
シーケンス
PTC_INT_RTG_API_HDR_S
PTC_INT_RTG_API_OPR_RES_N2
PTC_INT_RTG_API_OPR_RES
TIBCO_KEY
MasterConfiguration_EnggChangeOrder_all_Mods.sql
テーブル名
Select
Insert
更新
「削除」
TIB_INT_ECO_ENGR_CHANGE
X
X
X
TIB_INT_ECO_ENGR_CHANGE_EXCP
TIB_INT_ECO_ORD_REVISIONS
X
X
TIB_INT_ECO_ORD_REVISIONS_EXCP
TIB_INT_ECO_REVISE_ITM
X
X
TIB_INT_ECO_REVISE_ITM_EXCP
TIB_INT_ECO_REV_COMP
X
X
X
TIB_INT_ECO_REV_COMP_EXCP
TIB_INT_ECO_REF_DESIG
X
X
TIB_INT_ECO_REF_DESIG_EXCP
TIB_INT_ECO_SUBS_COMP
X
X
TIB_INT_ECO_SUBS_COMP_EXCP
TIB_INT_ECO_REV_OPERATION
X
X
TIB_INT_ECO_REV_OPERATION_EXCP
TIB_INT_ECO_OPN_RESOURCE
X
X
TIB_INT_ECO_OPN_RESOURCE_EXCP
TIB_INT_ECO_SUBOP_RESOURCE
X
X
TIB_ECO_SUBOP_RES_EXCP
索引
テーブル名
列名
TIB_INT_ECO_ENGR_CHANGE_N1
TIB_INT_ECO_ENGR_CHANGE
ECO_NAME,ORGANIZATION_CODE、TIBCO_UNIQUE_ID、TIBCO_INT_PROCESS_FLAG
TIB_INT_ECO_ENGR_CHANGE_N2
TIB_INT_ECO_ENGR_CHANGE
ECO_NAME,ORGANIZATION_CODE
TIB_INT_ECO_ENGR_CHANGE_N3
TIB_INT_ECO_ENGR_CHANGE
TIBCO_KEY
TIB_INT_ECO_ORD_REVISIONS_N1
TIB_INT_ECO_ORD_REVISIONS
ECO_NAME,ORGANIZATION_CODE
TIB_INT_ECO_ORD_REVISIONS_N2
TIB_INT_ECO_ORD_REVISIONS
TIBCO_KEY
TIB_INT_ECO_REVISE_ITM_N1
TIB_INT_ECO_REVISE_ITM
ECO_NAME,ORGANIZATION_CODE
TIB_INT_ECO_REVISE_ITM_N2
TIB_INT_ECO_REVISE_ITM
ECO_NAME,ORGANIZATION_CODE,REVISED_ITEM_NAME、START_EFFECTIVE_DATE
TIB_INT_ECO_REVISE_ITM_N3
TIB_INT_ECO_REVISE_ITM
TIBCO_KEY
TIB_INT_ECO_REV_COMP_N1
TIB_INT_ECO_REV_COMP
ECO_NAME,ORGANIZATION_CODE,REVISED_ITEM_NAME、START_EFFECTIVE_DATE
TIB_INT_ECO_REV_COMP_N2
TIB_INT_ECO_REV_COMP
ECO_NAME,ORGANIZATION_CODE,REVISED_ITEM_NAME、START_EFFECTIVE_DATE、COMPONENT_ITEM_NAME、OPERATION_SEQUENCE_NUMBER
TIB_INT_ECO_REV_COMP_N3
TIB_INT_ECO_REV_COMP
TIBCO_KEY
TIB_INT_ECO_REF_DESIG_N1
TIB_INT_ECO_REF_DESIG
ECO_NAME,ORGANIZATION_CODE,REVISED_ITEM_NAME、START_EFFECTIVE_DATE、COMPONENT_ITEM_NAME、OPERATION_SEQUENCE_NUMBER
TIB_INT_ECO_REF_DESIG_N2
TIB_INT_ECO_REF_DESIG
TIBCO_KEY
TIB_INT_ECO_SUBS_COMP_N1
TIB_INT_ECO_SUBS_COMP
ECO_NAME,ORGANIZATION_CODE,REVISED_ITEM_NAME、START_EFFECTIVE_DATE、COMPONENT_ITEM_NAME、OPERATION_SEQUENCE_NUMBER
TIB_INT_ECO_SUBS_COMP_N2
TIB_INT_ECO_SUBS_COMP
TIBCO_KEY
TIB_INT_ECO_REV_OPERATION_N1
TIB_INT_ECO_REV_OPERATION
ECO_NAME,ORGANIZATION_CODE,REVISED_ITEM_NAME、START_EFFECTIVE_DATE
TIB_INT_ECO_REV_OPERATION_N2
TIB_INT_ECO_REV_OPERATION
ECO_NAME,ORGANIZATION_CODE,REVISED_ITEM_NAME、START_EFFECTIVE_DATE、OPERATION_SEQUENCE_NUMBER
TIB_INT_ECO_REV_OPERATION_N3
TIB_INT_ECO_REV_OPERATION
ORGANIZATION_CODE、REVISED_ITEM_NAME、START_EFFECTIVE_DATE、OPERATION_SEQUENCE_NUMBER
TIB_INT_ECO_REV_OPERATION_N4
TIB_INT_ECO_REV_OPERATION
TIBCO_KEY
TIB_INT_ECO_OPN_RESOURCE_N1
TIB_INT_ECO_OPN_RESOURCE
ECO_NAME,ORGANIZATION_CODE,REVISED_ITEM_NAME、OP_START_EFFECTIVE_DATE、OPERATION_SEQUENCE_NUMBER
TIB_INT_ECO_OPN_RESOURCE_N2
TIB_INT_ECO_OPN_RESOURCE
TIBCO_KEY
TIB_INT_ECO_SUBOP_RESOURCE_N1
TIB_INT_ECO_SUBOP_RESOURCE
ORGANIZATION_CODE、REVISED_ITEM_NAME、OP_START_EFFECTIVE_DATE、OPERATION_SEQUENCE_NUMBER
TIB_INT_ECO_SUBOP_RESOURCE_N2
TIB_INT_ECO_SUBOP_RESOURCE
TIBCO_KEY
ESI_PartDetails_Mods.sql
シノニム
APPS. MTL_ITEM_FLEXFIELDS
APPS. ORG_ORGANIZATION_DEFINITIONS
APPS. CST_ITEM_COST_DETAILS_V
APPS. ICX_MTL_ONHAND_ITEMS_KFV
APPS. CST_ITEM_COST_TYPE_V
ptc_esi_parameters_do.sql
テーブル名
Select
Insert
更新
「削除」
PTC_ESI_PARAMETERS
X
v$parameter
X
MasterConfiguration_TIBCOLogTablePublisher_all_Mods.sql
テーブル名
Select
Insert
更新
「削除」
P_TIB_INT_LOG_SUB
X
索引
テーブル名
列名
IDX1_P_TIB_INT_LOG_SUB
P_TIB_INT_LOG_SUB
ADB_SEQUENCE
IDX2_P_TIB_INT_LOG_SUB
P_TIB_INT_LOG_SUB
ADB_L_DELIVERY_STATUS, ADB_SEQUENCE
IDX3_P_TIB_INT_LOG_SUB
P_TIB_INT_LOG_SUB
ADB_L_CMSEQUENCE
シーケンス
P_TIB_INT_LOG_SUB_SEQ
トリガ
テーブル名
イベント
TRI_P_TIB_INT_LOG_SUB
TIB_INT_LOG_SUB
Insert
esi_nls_parm_trg.sql
トリガ
イベント
esi_nls_parameters
ログオン
common_all_Mods.sql
テーブル名
Select
Insert
更新
「削除」
TIB_INT_LOG_SUB
X
シーケンス
TIB_INT_LOG_SUB_S