ESISYSL SCHEMA OBJECTS
The following objects appear in the ESISYSL SCHEMA.
MasterConfiguration_OpenItem_all_Mods.sql
Table Name
Select
Insert
Update
Delete
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
Synonym
MTL_PARAMETERS
MTL_SYSTEM_ITEMS
Sequence
TIB_INT_MTL_SYS_ITEMS_IFACE_S
PTC_JOB_PROCESS_SET
Index
Table Name
Column Name
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
Table Name
Select
Insert
Update
Delete
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
Index
Table Name
Column Name
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
Sequence
TIB_INT_BOM_API_HDR_S
BOM_BILL_OF_MATERIALS
BOM_INVENTORY_COMPONENTS
MasterConfiguration_Routing_BOM_do.sql
Table Name
Select
Insert
Update
Delete
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
Index
Table Name
Column Name
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
Sequence
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
Table Name
Select
Insert
Update
Delete
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
Index
Table Name
Column Name
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
Synonym
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
Table Name
Select
Insert
Update
Delete
PTC_ESI_PARAMETERS
X
v$parameter
X
MasterConfiguration_TIBCOLogTablePublisher_all_Mods.sql
Table Name
Select
Insert
Update
Delete
P_TIB_INT_LOG_SUB
X
Index
Table Name
Column Name
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
Sequence
P_TIB_INT_LOG_SUB_SEQ
Trigger
Table Name
Event
TRI_P_TIB_INT_LOG_SUB
TIB_INT_LOG_SUB
Insert
esi_nls_parm_trg.sql
Trigger
Event
esi_nls_parameters
logon
common_all_Mods.sql
Table Name
Select
Insert
Update
Delete
TIB_INT_LOG_SUB
X
Sequence
TIB_INT_LOG_SUB_S
這是否有幫助?