oracle_ebs_mfg_interface

《oracle_ebs_mfg_interface》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Manufacturing&DistributionOpenInterfaceOpenInterfaceArchitectureThreedifferentmethodsforimportandexportdata(inboundandoutbound)InterfaceTables(In)InterfaceViews(Out)FunctionCallsorProgrammaticInterfaces(In/Out)InterfaceTablesRequiressomevalidationthroughaconcurrentprogramYoucanwritedirectlyt

2、othetablesifyouarefamiliarwiththemInterfaceViewsViewssimplifythedatarelationshipsforeasierprocessingEx:mtl_item_quantities_viewDefinedinTechnicalReferenceManualDynamicViewsforOracleQualityFunctionCallsTightintegrationwithoutaddingabatchprocesstomovedataEx:ECOAPIEx:POAPIInboundInterfaceModelS

3、ourceApplicationDestinationApplicationInterfaceTableorDatabaseViewErrorsTableLoadProcessValidateMaintainOpenInterfaceComponentsSourceApplicationDestinationApplicationInterfaceTableIdentifierColumnsControlColumnsDataColumnsRequiredColumnsDerivedColumnsOptionalColumnsErrorsTableDatabaseViewLoa

4、dFunctionsqlloadertotemptabletemptointerfaceValidateFunctionProcessFunctionMaintainFunctionEx:openinterfacewindowOpenInterfacesOracleInventoryItemImportTransactionInterfaceReplenishmentCross-ReferenceCycleCountKanbanLotReservationMoveOrderOraclePurchasingRequisitionInterfacePurchaseInterface

5、ReceivingInterfaceOracleBillofMaterialBOMImportRoutingImportSubstitutionImportDesignatorImportOpenInterfacesOracleWorkinProcessJobImportMoveTransactionResoruceTransactionOracleMasterSchedulingForecastImportMPS/MDSImportOracleEngineeringECOInterfaceOrderManagementOrderImportSalesOrderAPIOracl

6、eQualityResultImportItemImportInterfaceTablemtl_system_items_interfaceUpdatedtablemtl_system_itemsConcurrentProgramImportItemsErrorsTablemtl_interface_errorsRequireddataitem_numberorganization_codedescriptionprocess_flag(1,Pending)transaction_type(CREATE)ItemTableRelationshipMTL_ITEM_CATALOG

7、_GROUPSITEM_CATALOG_GROUP_IDINVENTORY_ITEM_IDORGANIZATION_IDMTL_DESCRIPTIVE_ELEMENTSITEM_CATALOG_GROUP_IDELEMENT_NAMEMTL_ITEM_CATAGORIESCATEGORY_SET_IDINVENTORY_ITEM_IDORGANIZATION_IDCATEGORY_IDMTL_SYSTEM_ITEMSINVENTORY_ITEM_ID,ORGANIZATION_IDMTL_D