Enterprise Administration > Implementing Windchill ESI > Implementing Windchill ESI in an ORACLE Applications Environment > Oracle Applications API and OIT Structures > Oracle Applications Object Details > APPS SCHEMA OBJECTS
  
APPS SCHEMA OBJECTS
The following objects appear in the APPS SCHEMA.
MasterConfiguration_OpenItem_all_Mods.sql
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
MasterConfiguration_BillsOfMtlAPI_all_Mods.sql
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
MasterConfiguration_Routing_BOM_do.sql
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
MasterConfiguration_EnggChangeOrder_all_Mods.sql
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
ESI_PartDetails_Mods.sql
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
ptc_esi_parameters_do.sql
Synonym
ESISYSL.PTC_ESI_PARAMETERS
common_all_Mods.sql
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