|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
Table Name
|
Select
|
Insert
|
Update
|
Delete
|
|
PTC_ESI_PARAMETERS
|
X
|
|||
|
v$parameter
|
X
|
|||
|
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
|
|
Trigger
|
Event
|
|
esi_nls_parameters
|
logon
|
|
Table Name
|
Select
|
Insert
|
Update
|
Delete
|
|
TIB_INT_LOG_SUB
|
X
|
|
Sequence
|
|
TIB_INT_LOG_SUB_S
|