|
Table Name
|
Select
|
Insert
|
Update
|
Delete
|
|---|---|---|---|---|
|
APPS.FND_USER
|
X
|
|||
|
APPS.FND_APPLICATION
|
X
|
|||
|
APPS.FND_RESPONSIBILITY_TL
|
X
|
|||
|
APPS.V$INSTANCE
|
X
|
|||
|
APPS.FND_PRODUCT_GROUPS
|
X
|
|||
|
INV.MTL_SYSTEM_ITEMS_INTERFACE
|
X
|
X
|
X
|
|
|
INV.MTL_ITEM_REVISIONS_INTERFACE
|
X
|
X
|
X
|
|
|
INV.MTL_ITEM_CATEGORIES_INTERFACE
|
X
|
X
|
||
|
INV.MTL_INTERFACE_ERRORS
|
X
|
|||
|
INV.MTL_SYSTEM_ITEMS_B
|
X
|
|||
|
APPS.MTL_PARAMETERS
|
X
|
|||
|
ESISYL.PTC_ESI_PARAMETERS
|
X
|
X
|
|
Owned By
|
API - PROCEDURE
|
|---|---|
|
Oracle
|
fnd_request.submit_request
|
|
Oracle
|
fnd_concurrent.wait_for_request
|
|
Oracle
|
fnd_request.set_options
|
|
Oracle
|
FND_GLOBAL.APPS_INITIALIZE
|
|
Oracle
|
FND_PROFILE.INITIALIZE
|
|
Oracle
|
FND_CLIENT_INFO.setup_client_info
|
|
Oracle
|
utl_file.fopen
|
|
Oracle
|
utl_file.put_line
|
|
Oracle
|
utl_file.fclose
|
|
Oracle
|
fnd_file.put_line
|
|
Oracle
|
fnd_file.LOG
|
|
PTC
|
pk_tib_openitem_import.pro_pre_OpenItem
|
|
PTC
|
pk_tib_openitem_import.pro_post_OpenItem
|
|
PTC
|
pk_tib_openitem_import.OpenItem_Validation
|
|
PTC
|
pk_tib_openitem_import.main
|
|
PTC
|
pk_tib_openitem_import.main_update
|
|
PTC
|
pk_tib_openitem_import.main_adb_create
|
|
PTC
|
pk_tib_openitem_import.main_adb_update
|
|
PTC
|
pk_tib_log.log_interface_status
|
|
Synonym
|
|---|
|
ESISYSL.TIB_INT_MTL_SYS_ITEMS_IFACE
|
|
ESISYSL.IB_INT_MTL_ITEM_CATGER_IFACE
|
|
ESISYSL.TIB_INT_MTL_SYS_ITEMS_IFACE_S
|
|
ESISYSL.PTC_JOB_PROCESS_SET
|
|
ESISYSL.TIB_INT_MTL_ITEM_REV_IFACE
|
|
ESISYSL.TIB_MTL_ITEMS_IFACE_EXCP
|
|
ESISYSL.TIB_MTL_ITEM_REV_EXCP
|
|
ESISYSL.TIB_MTL_ITEM_CATGER_IFACE_EXCP
|
|
Table Name
|
Select
|
Insert
|
Update
|
Delete
|
|---|---|---|---|---|
|
APPS.FND_USER
|
X
|
|||
|
APPS.FND_APPLICATION
|
X
|
|||
|
APPS.FND_RESPONSIBILITY_TL
|
X
|
|||
|
APPS.V$INSTANCE
|
X
|
|||
|
APPS.FND_PRODUCT_GROUPS
|
X
|
|||
|
ESISYL.PTC_ESI_PARAMETERS
|
X
|
X
|
|
Owned By
|
API - PROCEDURE
|
|---|---|
|
Oracle
|
BOM_BO_PUB.Process_Bom
|
|
Oracle
|
Error_Handler.Get_Message_Count
|
|
Oracle
|
Error_Handler.Get_Message_List
|
|
Oracle
|
BOM_RTG_PUB.Process_Rtg
|
|
Oracle
|
utl_file.fopen
|
|
Oracle
|
utl_file.put_line
|
|
Oracle
|
utl_file.fclose
|
|
Oracle
|
fnd_file.put_line
|
|
Oracle
|
fnd_file.LOG
|
|
PTC
|
pk_tib_billsapi_import.Pro_Pre_BOM_API_1155
|
|
PTC
|
pk_tib_billsapi_import.Pro_Post_BOM_API_1155
|
|
PTC
|
pk_tib_billsapi_import. BillsAPI_Validation
|
|
PTC
|
pk_tib_billsapi_import. main
|
|
PTC
|
pk_tib_billsapi_import. main_adb
|
|
PTC
|
pk_tib_log.log_interface_status
|
|
Synonym
|
|---|
|
ESISYSL.TIB_INT_BOM_API_HDR_S
|
|
ESISYSL.TIB_INT_BOM_API_HDR FOR
|
|
ESISYSL.TIB_INT_BOM_API_HDR_EXCP
|
|
ESISYSL.TIB_INT_BOM_API_ITM_REV
|
|
ESISYSL.TIB_INT_BOM_API_ITM_REV_EXCP
|
|
ESISYSL.TIB_INT_BOM_API_INV_COMP
|
|
ESISYSL.TIB_INT_BOM_API_INV_COMP_EXCP
|
|
ESISYSL.TIB_INT_BOM_API_REF_DESG
|
|
ESISYSL.T IB_INT_BOM_API_REF_DESG_EXCP
|
|
ESISYSL. TIB_INT_BOM_API_SUBS_COMP
|
|
ESISYSL. TIB_INT_BOM_API_SUBS_COMP_EXCP
|
|
ESISYSL. TIB_INT_BOM_API_COMP_OPS
|
|
ESISYSL.T IB_INT_BOM_API_COMP_OPS_EXCP
|
|
Table Name
|
Select
|
Insert
|
Update
|
Delete
|
|---|---|---|---|---|
|
APPS.V$INSTANCE
|
X
|
|||
|
APPS.FND_PRODUCT_GROUPS
|
X
|
|||
|
ESISYSL.PTC_ESI_PARAMETERS
|
X
|
X
|
|
Owned By
|
API - PROCEDURE
|
|---|---|
|
Oracle
|
BOM_BO_PUB.Process_Bom
|
|
Oracle
|
Error_Handler.Get_Message_Count
|
|
Oracle
|
Error_Handler.Get_Message_List
|
|
Oracle
|
BOM_RTG_PUB.Process_Rtg
|
|
Oracle
|
utl_file.fopen
|
|
Oracle
|
utl_file.put_line
|
|
Oracle
|
utl_file.fclose
|
|
Oracle
|
fnd_file.put_line
|
|
Oracle
|
fnd_file.LOG
|
|
PTC
|
PTC_RTG_BOM.BILLS_ALL
|
|
PTC
|
PTC_RTG_API. RoutingsAPI_Validation
|
|
PTC
|
PTC_RTG_API.main
|
|
PTC
|
PTC_RTG_API.main_adb
|
|
PTC
|
pk_tib_log.log_interface_status
|
|
Synonym
|
|---|
|
ESISYSL.PTC_INT_RTG_API_HDR_S
|
|
ESISYSL.PTC_INT_RTG_API_HDR
|
|
ESISYSL.PTC_INT_RTG_API_HDR_EXCP
|
|
ESISYSL.PTC_INT_RTG_API_REV
|
|
ESISYSL.PTC_INT_RTG_API_REV_EXCP
|
|
ESISYSL.PTC_INT_RTG_API_OPR
|
|
ESISYSL.PTC_INT_RTG_API_OPR_EXCP
|
|
ESISYSL.PTC_INT_RTG_API_OPR_RES
|
|
ESISYSL.PTC_INT_RTG_API_OPR_RES_EXCP
|
|
Table Name
|
Select
|
Insert
|
Update
|
Delete
|
|---|---|---|---|---|
|
APPS.FND_USER
|
X
|
|||
|
APPS.FND_APPLICATION
|
X
|
|||
|
APPS.FND_RESPONSIBILITY_TL
|
X
|
|||
|
APPS.V$INSTANCE
|
X
|
|||
|
APPS.FND_PRODUCT_GROUPS
|
X
|
|||
|
APPS.MTL_SYSTEM_ITEMS
|
X
|
|||
|
APPS.BOM_BILL_OF_MATERIALS
|
X
|
|||
|
APPS.BOM_INVENTORY_COMPONENTS
|
X
|
X
|
||
|
APPS.BOM_SUBSTITUTE_COMPONENTS
|
X
|
|||
|
APPS.MTL_PARAMETERS
|
X
|
|||
|
APPS.BOM_REFERENCE_DESIGNATORS
|
X
|
|||
|
ESISYL.PTC_ESI_PARAMETERS
|
X
|
X
|
|
Owned By
|
API - PROCEDURE - FUNCTION
|
|---|---|
|
Oracle
|
ENG_ECO_PUB.Process_Eco
|
|
Oracle
|
Error_Handler.Get_Message_Count
|
|
Oracle
|
Error_Handler.Get_Message_List
|
|
Oracle
|
utl_file.fopen
|
|
Oracle
|
utl_file.put_line
|
|
Oracle
|
utl_file.fclose
|
|
Oracle
|
fnd_file.put_line
|
|
Oracle
|
fnd_file.LOG
|
|
PTC
|
pk_tib_engchord_import.Pro_Pre_ECO
|
|
PTC
|
pk_tib_engchord_import.Pro_Post_ECO
|
|
PTC
|
pk_tib_engchord_import.EngChOrd_Validation
|
|
PTC
|
pk_tib_engchord_import.main
|
|
PTC
|
pk_tib_engchord_import.main_adb
|
|
PTC
|
pk_tib_engchord.DO_DIS_COMP
|
|
PTC
|
pk_tib_engchord.IsSubstituteForDelete
|
|
PTC
|
pk_tib_engchord.IsdesignatorForDelete
|
|
PTC
|
pk_tib_engchord.esi_GetEffectivity
|
|
PTC
|
pk_tib_log.log_interface_status
|
|
Synonym
|
|---|
|
ESISYSL.TIB_INT_ECO_ENGR_CHANGE
|
|
ESISYSL.TIB_INT_ECO_ORD_REVISIONS
|
|
ESISYSL.TIB_INT_ECO_REVISE_ITM
|
|
ESISYSL.TIB_INT_ECO_REV_COMP
|
|
ESISYSL.TIB_INT_ECO_SUBS_COMP
|
|
ESISYSL.TIB_INT_ECO_REF_DESIG
|
|
ESISYSL.TIB_INT_ECO_REV_OPERATION
|
|
ESISYSL.TIB_INT_ECO_OPN_RESOURCE
|
|
ESISYSL.TIB_INT_ECO_SUBOP_RESOURCE
|
|
ESISYSL. TIB_INT_ECO_ENGR_CHANGE_EXCP
|
|
ESISYSL. TIB_INT_ECO_ORD_REVISIONS_EXCP
|
|
ESISYSL. TIB_INT_ECO_REVISE_ITM_EXCP
|
|
ESISYSL.TIB_INT_ECO_REV_COMP_EXCP
|
|
ESISYSL. TIB_INT_ECO_SUBS_COMP_EXCP
|
|
ESISYSL. TIB_INT_ECO_REF_DESIG_EXCP
|
|
ESISYSL. TIB_INT_ECO_REV_OPERATION_EXCP
|
|
ESISYSL. TIB_INT_ECO_OPN_RESOURCE_EXCP
|
|
ESISYSL. TIB_ECO_SUBOP_RES_EXCP
|
|
ESISYSL. TIB_INT_ECO_ENGR_CHANGE_S
|
|
GRANT- SELECT
|
SCHEMA
|
|---|---|
|
MTL_ITEM_FLEXFIELDS
|
ESISYSL
|
|
ORG_ORGANIZATION_DEFINITIONS
|
ESISYSL
|
|
CST_ITEM_COST_DETAILS_V
|
ESISYSL
|
|
ICX_MTL_ONHAND_ITEMS_KFV
|
ESISYSL
|
|
CST_ITEM_COST_TYPE_V
|
ESISYSL
|
|
Synonym
|
|---|
|
ESISYSL.PTC_ESI_PARAMETERS
|
|
Owned By
|
API - PROCEDURE
|
|---|---|
|
PTC
|
pk_tib_log.log_interface_status
|
|
Synonym
|
|---|
|
ESISYSL.TIB_INT_LOG_SUB
|
|
ESISYSL.TIB_INT_LOG_SUB_S
|
|
APPS.FND_PRODUCT_GROUPS
|
|
GRANT- EXECUTE
|
SCHEMA
|
|---|---|
|
pk_tib_log
|
ESISYSL
|
|
GRANT- SELECT
|
SCHEMA
|
|---|---|
|
AR_PAYMENTS_INTERFACE_ALL
|
ESISYSL
|
|
OE_HEADERS_IFACE_ALL
|
ESISYSL
|
|
OE_LINES_IFACE_ALL
|
ESISYSL
|
|
OE_PRICE_ADJS_IFACE_ALL
|
ESISYSL
|
|
OE_CREDITS_IFACE_ALL
|
ESISYSL
|
|
OE_LOTSERIALS_IFACE_ALL
|
ESISYSL
|
|
OE_RESERVTNS_IFACE_ALL
|
ESISYSL
|
|
OE_ACTIONS_IFACE_ALL
|
ESISYSL
|
|
PO_HEADERS_INTERFACE
|
ESISYSL
|
|
PO_LINES_INTERFACE
|
ESISYSL
|
|
RA_CUSTOMERS_INTERFACE_ALL
|
ESISYSL
|
|
RA_CUSTOMER_PROFILES_INT_ALL
|
ESISYSL
|
|
RA_CUST_PAY_METHOD_INT_ALL
|
ESISYSL
|
|
RA_CONTACT_PHONES_INT_ALL
|
ESISYSL
|
|
RA_CUSTOMER_BANKS_INT_ALL
|
ESISYSL
|
|
PO_REQUISITIONS_INTERFACE_ALL
|
ESISYSL
|
|
PO_REQ_DIST_INTERFACE_ALL
|
ESISYSL
|
|
WIP_JOB_SCHEDULE_INTERFACE
|
ESISYSL
|
|
WIP_JOB_DTLS_INTERFACE
|
ESISYSL
|
|
MTL_CI_INTERFACE
|
ESISYSL
|
|
QA_RESULTS_INTERFACE
|
ESISYSL
|
|
GL_INTERFACE
|
ESISYSL
|
|
MTL_SYSTEM_ITEMS
|
ESISYSL
|
|
MTL_SYSTEM_ITEMS_INTERFACE
|
ESISYSL
|
|
MTL_ITEM_REVISIONS_INTERFACE
|
ESISYSL
|
|
WIP_MOVE_TXN_INTERFACE
|
ESISYSL
|
|
CST_COMP_SNAP_INTERFACE
|
ESISYSL
|
|
CST_PC_ITEM_COST_INTERFACE
|
ESISYSL
|
|
CST_PC_COST_DET_INTERFACE
|
ESISYSL
|
|
AP_INVOICES_INTERFACE
|
ESISYSL
|
|
AP_INVOICE_LINES_INTERFACE
|
ESISYSL
|
|
RCV_SHIPMENT_HEADERS
|
ESISYSL
|
|
RCV_TRANSACTIONS_INTERFACE
|
ESISYSL
|
|
GL_BUDGET_INTERFACE
|
ESISYSL
|
|
BOM_BILL_OF_MTLS_INTERFACE
|
ESISYSL
|
|
BOM_INVENTORY_COMPS_INTERFACE
|
ESISYSL
|
|
BOM_REF_DESGS_INTERFACE
|
ESISYSL
|
|
BOM_SUB_COMPS_INTERFACE
|
ESISYSL
|
|
RLM_INTERFACE_HEADERS_ALL
|
ESISYSL
|
|
RLM_INTERFACE_LINES_ALL
|
ESISYSL
|
|
MTL_TRANSACTIONS_INTERFACE
|
ESISYSL
|
|
FA_BUDGET_INTERFACE
|
ESISYSL
|
|
FA_MASS_ADDITIONS
|
ESISYSL
|
|
MRP_FORECAST_INTERFACE
|
ESISYSL
|
|
MRP_SCHEDULE_INTERFACE
|
ESISYSL
|
|
MTL_TRANSACTION_LOTS_INTERFACE
|
ESISYSL
|
|
MTL_SERIAL_NUMBERS_INTERFACE
|
ESISYSL
|
|
MTL_REPLENISH_HEADERS_INT
|
ESISYSL
|
|
MTL_REPLENISH_LINES_INT
|
ESISYSL
|
|
MTL_ITEM_REVISIONS_INTERFACE
|
ESISYSL
|
|
MTL_CI_XREFS_INTERFACE
|
ESISYSL
|
|
MTL_CC_ENTRIES_INTERFACE
|
ESISYSL
|
|
MTL_PARAMETERS
|
ESISYSL
|
|
CST_COMP_SNAP_INTERFACE
|
ESISYSL
|
|
RA_INTERFACE_LINES_ALL
|
ESISYSL
|
|
RA_INTERFACE_SALESCREDITS_ALL
|
ESISYSL
|
|
WIP_COST_TXN_INTERFACE
|
ESISYSL
|
|
MTL_SYSTEM_ITEMS_B
|
ESISYSL
|
|
OE_LOT_SERIAL_NUMBERS
|
ESISYSL
|
|
OE_PRICE_ADJUSTMENTS
|
ESISYSL
|
|
OE_SALES_CREDITS
|
ESISYSL
|
|
OE_ORDER_LINES_ALL
|
ESISYSL
|
|
OE_ORDER_HEADERS_ALL
|
ESISYSL
|
|
HZ_LOCATIONS
|
ESISYSL
|
|
HZ_PARTIES
|
ESISYSL
|
|
HZ_PARTY_SITES
|
ESISYSL
|
|
HZ_CUST_ACCT_SITES_ALL
|
ESISYSL
|
|
HZ_CUST_SITE_USES_ALL
|
ESISYSL
|
|
PO_VENDOR_SITES_ALL
|
ESISYSL
|
|
PO_VENDORS
|
ESISYSL
|
|
PO_DISTRIBUTIONS_ALL
|
ESISYSL
|
|
PO_LINE_LOCATIONS_ALL
|
ESISYSL
|
|
PO_LINES_ALL
|
ESISYSL
|
|
PO_HEADERS_ALL
|
ESISYSL
|
|
HR.HR_LOCATIONS_ALL
|
ESISYSL
|
|
PER_ALL_PEOPLE_F
|
ESISYSL
|
|
PER_PERIODS_OF_SERVICE
|
ESISYSL
|
|
PER_ALL_ASSIGNMENTS_F
|
ESISYSL
|
|
PER_APPLICATIONS
|
ESISYSL
|
|
PER_ADDRESSES
|
ESISYSL
|
|
JTF_IH_INTERACTIONS
|
ESISYSL
|
|
JTF_IH_ACTIVITIES
|
ESISYSL
|
|
HZ_PARTIES
|
ESISYSL
|
|
HZ_CONTACT_POINTS
|
ESISYSL
|
|
HZ_PARTY_SITES
|
ESISYSL
|
|
HZ_CUST_ACCOUNTS
|
ESISYSL
|
|
HZ_CUST_ACCT_SITES_ALL
|
ESISYSL
|
|
HZ_CUST_SITE_USES_ALL
|
ESISYSL
|
|
AP_BANK_ACCOUNT_USES_ALL
|
ESISYSL
|
|
AP_BANK_ACCOUNTS_ALL
|
ESISYSL
|
|
AP_BANK_BRANCHES
|
ESISYSL
|
|
HZ_CUST_ACCOUNTS
|
ESISYSL
|
|
HZ_CUSTOMER_PROFILES
|
ESISYSL
|
|
HZ_CUST_PROFILE_CLASSES
|
ESISYSL
|
|
HZ_CUST_ACCOUNT_ROLES
|
ESISYSL
|
|
HZ_ROLE_RESPONSIBILITY
|
ESISYSL
|
|
HZ_CUST_ACCT_RELATE_ALL
|
ESISYSL
|
|
HZ_CUST_PROFILE_AMTS
|
ESISYSL
|
|
RA_CUSTOMER_TRX_LINES_ALL
|
ESISYSL
|
|
RA_CUSTOMER_TRX_ALL
|
ESISYSL
|
|
HZ_LOCATIONS
|
ESISYSL
|
|
HZ_PARTIES
|
ESISYSL
|
|
HZ_PARTY_SITES
|
ESISYSL
|
|
HZ_CUST_ACCT_SITES_ALL
|
ESISYSL
|
|
HZ_CUST_SITE_USES_ALL
|
ESISYSL
|
|
BOM_BILL_OF_MATERIALS
|
ESISYSL
|
|
MTL_ITEM_REVISIONS
|
ESISYSL
|
|
BOM_OPERATIONAL_ROUTINGS
|
ESISYSL
|
|
BOM_OPERATION_SEQUENCES
|
ESISYSL
|
|
BOM_OPERATION_RESOURCES
|
ESISYSL
|
|
AP_INVOICES_ALL
|
ESISYSL
|
|
AP_INVOICE_PAYMENTS_ALL
|
ESISYSL
|
|
AP_CHECKS_ALL
|
ESISYSL
|
|
ENG_ENGINEERING_CHANGES
|
ESISYSL
|
|
ENG_CHANGE_ORDER_REVISIONS
|
ESISYSL
|
|
ENG_REVISED_ITEMS
|
ESISYSL
|
|
ENG_CURRENT_SCHEDULED_DATE
|
ESISYSL
|
|
BOM_INVENTORY_COMPONENTS
|
ESISYSL
|
|
BOM_SUBSTITUTE_COMPONENTS
|
ESISYSL
|
|
BOM_REFERENCE_DESIGNATORS
|
ESISYSL
|
|
GL_BUDGET_VERSIONS
|
ESISYSL
|
|
GL_BALANCES
|
ESISYSL
|
|
GL_JE_HEADERS
|
ESISYSL
|
|
GL_JE_LINES
|
ESISYSL
|
|
GL_JE_BATCHES
|
ESISYSL
|
|
AP_INVOICES_ALL
|
ESISYSL
|
|
AP_INVOICE_DISTRIBUTIONS_ALL
|
ESISYSL
|
|
PO_VENDOR_SITES_ALL
|
ESISYSL
|
|
PO_VENDORS
|
ESISYSL
|
|
MTL_ITEM_CATEGORIES
|
ESISYSL
|
|
MTL_CATEGORIES_B
|
ESISYSL
|
|
MTL_ONHAND_QUANTITIES
|
ESISYSL
|
|
MTL_TXN_REQUEST_HEADERS
|
ESISYSL
|
|
MTL_TXN_REQUEST_LINES
|
ESISYSL
|
|
PO_VENDORS
|
ESISYSL
|
|
PO_VENDOR_SITES_ALL
|
ESISYSL
|
|
BOM_OPERATIONAL_ROUTINGS
|
ESISYSL
|
|
BOM_RESOURCES
|
ESISYSL
|
|
BOM_OPERATION_RESOURCES
|
ESISYSL
|
|
BOM_OPERATION_SEQUENCES
|
ESISYSL
|
|
CST_ACTIVITIES
|
ESISYSL
|
|
BOM_DEPARTMENTS
|
ESISYSL
|
|
FND_LOOKUP_TYPES_VL
|
ESISYSL
|
|
FND_LOOKUP_VALUES
|
ESISYSL
|
|
MTL_SYSTEM_ITEMS_INTF_SETS_S
|
ESISYSL
|
|
FND_PRODUCT_GROUPS
|
ESISYSL
|
|
PO_DISTRIBUTIONS_INTERFACE
|
ESISYSL
|
|
RCV_HEADERS_INTERFACE
|
ESISYSL
|
|
RA_INTERFACE_DISTRIBUTIONS_ALL
|
ESISYSL
|
|
MLOG$_MTL_SYSTEM_ITEMS_B
|
ESISYSL
|
|
BOM_STRUCTURES_B
|
ESISYSL
|
|
BOM_COMPONENTS_B
|
ESISYSL
|
|
MTL_ITEM_REVISIONS_B
|
ESISYSL
|
|
MTL_ITEM_CATEGORIES_INTERFACE
|
ESISYSL
|
|
MTL_ONHAND_QUANTITIES_DETAIL
|
ESISYSL
|
|
PO_VENDORS_OBS
|
ESISYSL
|