APPS SCHEMA OBJECTS

企業管理 > 實行 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	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
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
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
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

這是否有幫助?