Oracle EBS Dictionary
田攀
tian.pan@qq.com
展开
-
Trigger Toutorial
Trigger Toutorial Triggers1.1 About Triggers and Processes Triggers are blocks of PL/SQL code that you write to perform specific tasks. There are pre-defined runtime events for which you c转载 2012-04-10 13:14:42 · 2855 阅读 · 0 评论 -
MTL_SYSTEM_ITEMS_B.LOCATION_CONTROL_CODE
MTL_SYSTEM_ITEMS_B.LOCATION_CONTROL_CODELOOKUP_TYPELOOKUP_CODEMEANINGMTL_LOCATION_CONTROL3Dynamic entry locator controlMTL_LOCATION_CONTROL5Locator control de原创 2012-08-21 11:19:18 · 4615 阅读 · 0 评论 -
MTL_TXN_REQUEST_HEADERS.HEADER_STATUS or MTL_TXN_REQUEST_LINES.LINE_STATUS
MTL_TXN_REQUEST_HEADERS.HEADER_STATUS or MTL_TXN_REQUEST_LINES.LINE_STATUS ValueMeaning1Incomplete2Pending Approval3Approved4Not Approved5Clo原创 2012-08-21 11:24:40 · 10137 阅读 · 0 评论 -
WIP_ENTITIES.ENTITY_TYPE
WIP_ENTITIES.ENTITY_TYPEValueMeaning1Discrete job2Repetitive assembly3Closed discrete job4Flow schedule原创 2012-08-21 11:27:54 · 7791 阅读 · 0 评论 -
WIP_DISCRETE_JOBS.WIP_SUPPLY_TYPE
WIP_DISCRETE_JOBS.WIP_SUPPLY_TYPEValueMeaning1Push2Assembly Pull3Operation Pull4Bulk5Supplier6Phantom7Based on Bill原创 2012-08-21 11:29:28 · 9396 阅读 · 0 评论 -
Profile Options In INV,PO,OM,MS/MRP
Below is a list of some of the key Profile Options in various modules.Profile Options - INVENTORYINV:Accounting Category Set Indicates the default category set for defining category account. This prof转载 2012-04-11 16:32:37 · 5130 阅读 · 0 评论 -
Oracle EBS Related Links
Move this content to http://blog.csdn.net/pan_tian/article/details/7472310Metalinkhttps://support.oracle.com/ (Old Link ishttps://metalink.oracle.com/)EBS R12 User Guidehttp://docs.oracle.com/cd/B5382原创 2012-04-11 15:06:50 · 3167 阅读 · 0 评论 -
Oracle EBS Development Command
Open Form fileR12frmbld.sh INVTOMAI.fmb11if60desm XXX.fmbCompiling formR12frmcmp.sh module=INVRSVF1.fmb userid=apps/apps@mz1ms206 module_type=form compile_all=special(Batch Mode)frmcmp.sh module=INVRS原创 2012-04-24 03:22:49 · 8524 阅读 · 0 评论 -
Move Order Type
MTL_TXN_REQUEST_HEADERS.MOVE_ORDER_TYPE LOOKUP_TYPELOOKUP_CODEMEANINGDESCRIPTIONMOVE_ORDER_TYPE1RequisitionMove Order RequisitionMOVE_ORDER_TYPE2ReplenishmentMove Order Type created from replenishment原创 2012-08-21 11:22:00 · 5997 阅读 · 0 评论 -
EBS File Types
File Types.fmbForm binary source code.fmtForm text.fmxForm executable.mmbMenu source code.mmtMenu text.mmxMenu executable.pldText version Packag原创 2012-04-10 13:24:39 · 2039 阅读 · 0 评论 -
Transaction Types
Transaction Type = Transaction Source Type + Transaction Action TypeTRANSACTIONTYPE IDTRANSACTIONNAMEDESCRIPTIONTRANSACTIONSOURCE IDTRANSACTIONACTION ID原创 2012-08-21 10:44:30 · 7693 阅读 · 0 评论 -
MTL_SERIAL_NUMBERS.CURRENT_STATUS
MTL_SERIAL_NUMBERS.CURRENT_STATUSLOOKUP_TYPELOOKUP_CODEMEANINGSERIAL_NUM_STATUS1Defined but not usedSERIAL_NUM_STATUS3Resides in storesSERIAL_NUM_STATUS4I原创 2012-08-21 11:15:15 · 11480 阅读 · 0 评论 -
System Variables Toutorial
System Variables ToutorialSystem VariablesAbout System Variables A system variable is an Oracle Forms variable that keeps track of an internal Oracle Forms state. You can reference the v转载 2012-04-10 13:09:50 · 2234 阅读 · 0 评论 -
Oracle EBS Development Software Download List
EBS or Other Oracle Producthttps://edelivery.oracle.com/you can find downloads for all licensable Oracle products.Oracle Developer Suitehttp://www.oracle.com/technetwork/developer-tool原创 2012-04-11 13:01:30 · 4760 阅读 · 0 评论 -
Concurrent Request Tables
Oracle Apps Concurrent Request Table Relationshipfor pdf version,you can download from "Concurrent Request Tables.pdf"FND_CONCURRENT_PROGRAMSeTRM:FND_CONCURRENT_PROGRAMS stores informati原创 2012-06-29 12:47:03 · 5930 阅读 · 0 评论 -
Transaction Action Types
TRANSCTIONACTION ID DESCRIPTION1Issue from stores2Subinventory transfer3Direct organization transfer4Cycle count adjustment8Physical inventory adjustment原创 2012-08-21 10:46:23 · 3348 阅读 · 0 评论 -
Transaction Source Types
TRANSACTIONSOURCE TYPE IDTRANSACTIONSOURCE NAMEDESCRIPTION1Purchase orderPurchase order2Sales orderSales order3AccountAccount4Move orderMove order5J原创 2012-08-21 10:47:44 · 2901 阅读 · 0 评论 -
Delivery Line Status (WSH_DELIVERY_DETAILS.RELEASED_STATUS)
WSH_DELIVERY_DETAILS.RELEASED_STATUSDeliveryLine StatusDescriptionNNot Ready to ReleaseRReady to ReleaseSReleased to WarehouseBBackorderedYStaged原创 2012-08-21 11:12:47 · 5450 阅读 · 0 评论 -
MTL_SYSTEM_ITEMS_B.SERIAL_NUMBER_CONTROL_CODE
MTL_SYSTEM_ITEMS_B.SERIAL_NUMBER_CONTROL_CODELOOKUP_TYPELOOKUP_CODEMEANINGMTL_SERIAL_NUMBER1No serial number controlMTL_SERIAL_NUMBER2Predefined serial number原创 2012-08-21 11:16:53 · 10165 阅读 · 0 评论 -
WMS_LICENSE_PLATE_NUMBERS.LPN_CONTEXT
WMS_LICENSE_PLATE_NUMBERS.LPN_CONTEXTLOOKUP_TYPELOOKUP_CODEMEANINGWMS_LPN_CONTEXT1In InventoryWMS_LPN_CONTEXT2In WIPWMS_LPN_CONTEXT3In ReceivingWMS_原创 2012-08-21 11:31:40 · 7341 阅读 · 0 评论 -
WIP_DISCRETE_JOBS.STATUS_TYPE
WIP_DISCRETE_JOBS.STATUS_TYPEValueMeaning7Cancelled8Pending Bill Load9Failed Bill Load10Pending Routing Load11Failed Routing Load12Clo原创 2012-08-21 11:33:29 · 10138 阅读 · 0 评论 -
EBS提供的所有Key Flexfields(KFF)
EBS提供了很多标准的KFF,通过下边这个SQL就可以查询(以Applicaiton Code排序)SELECT B.APPLICATION_SHORT_NAME,A.ID_FLEX_CODE,A.ID_FLEX_NAME,A.APPLICATION_TABLE_NAME,A.UNIQUE_ID_COLUMN_NAME,A.DESCRIPTION FROM FND_ID_FLEXS A原创 2012-05-04 10:54:36 · 5442 阅读 · 0 评论