|
テーブル名
|
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
|
|
テーブル名
|
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
|
|
テーブル名
|
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
|
|
テーブル名
|
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
|
|
シノニム
|
|
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
|
|
テーブル名
|
Select
|
Insert
|
更新
|
「削除」
|
|
PTC_ESI_PARAMETERS
|
X
|
|||
|
v$parameter
|
X
|
|||
|
テーブル名
|
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_parameters
|
ログオン
|
|
テーブル名
|
Select
|
Insert
|
更新
|
「削除」
|
|
TIB_INT_LOG_SUB
|
X
|
|
シーケンス
|
|
TIB_INT_LOG_SUB_S
|