ITPub博客

WIP_DISCRETE_JOBS.STATUS_TYPE Value Meaning 7 Cancelled 8 Pending Bill Load 9 Failed Bill Load 10 Pending Routing Load 11 Failed Routing Load 12 Closed 13 Pending - Mass Loaded 14 Pending Close 15 Failed Close 1 Unreleased 3 Released 4 Complete 5 Complete - No Charges 6 On Hold

WMS_LICENSE_PLATE_NUMBERS.LPN_CONTEXT LOOKUP_TYPE LOOKUP_CODE MEANING WMS_LPN_CONTEXT 1 In Inventory WMS_LPN_CONTEXT 2 In WIP WMS_LPN_CONTEXT 3 In Receiving WMS_LPN_CONTEXT 4 Issued out of Stores WMS_LPN_CONTEXT 5 Defined but not used WMS_LPN_CONTEXT 6 Intransit WMS_LPN_CONTEXT 7 At Vendor WMS_LPN_CONTEXT 8 Packing context WMS_LPN_CONTEXT 9 Loaded to Dock WMS_LPN_CONTEXT 10 Prepack for WIP WMS_LPN_CONTEXT

WIP_DISCRETE_JOBS.WIP_SUPPLY_TYPE Value Meaning 1 Push 2 Assembly Pull 3 Operation Pull 4 Bulk 5 Supplier 6 Phantom 7 Based on Bill

WIP_ENTITIES.ENTITY_TYPE Value Meaning 1 Discrete job 2 Repetitive assembly 3 Closed discrete job 4 Flow schedule

MTL_TXN_REQUEST_HEADERS.HEADER_STATUS  or MTL_TXN_REQUEST_LINES.LINE_STATUS Value Meaning 1 Incomplete 2 Pending Approval 3 Approved 4 Not Approved 5 Closed 6 Canceled 7 Pre Approved 8 Partially Approved

MTL_TXN_REQUEST_HEADERS.MOVE_ORDER_TYPE LOOKUP_TYPELOOKUP_CODEMEANINGDESCRIPTIONMOVE_ORDER_TYPE1RequisitionMove Order RequisitionMOVE_ORDER_TYPE2ReplenishmentMove Order Type created from replenishmentMOVE_ORDER_TYPE3Pick WaveMove Order Type created for outbound shippingMOVE_ORDER_TYPE4ReceiptMove Order Type for receiving transactionsMOVE_ORDER_TYPE5Manufacturing Component PickMove Order Type created from Component Pick ReleaseMOVE_ORDER_TYPE6Put AwayPut AwayRequisition Move OrdersManually Gene

MTL_SYSTEM_ITEMS_B.LOCATION_CONTROL_CODE LOOKUP_TYPE LOOKUP_CODE MEANING MTL_LOCATION_CONTROL 3 Dynamic entry locator control MTL_LOCATION_CONTROL 5 Locator control determined at item level MTL_LOCATION_CONTROL 4 Locator control determined at subinventory level MTL_LOCATION_CONTROL 1 No locator control MTL_LOCATION_CONTROL 2 Prespecified locator control

MTL_SYSTEM_ITEMS_B.SERIAL_NUMBER_CONTROL_CODE LOOKUP_TYPE LOOKUP_CODE MEANING MTL_SERIAL_NUMBER 1 No serial number control MTL_SERIAL_NUMBER 2 Predefined serial numbers MTL_SERIAL_NUMBER 5 Dynamic entry at inventory receipt MTL_SERIAL_NUMBER 6 Dynamic entry at sales order issue

MTL_SERIAL_NUMBERS.CURRENT_STATUS LOOKUP_TYPE LOOKUP_CODE MEANING SERIAL_NUM_STATUS 1 Defined but not used SERIAL_NUM_STATUS 3 Resides in stores SERIAL_NUM_STATUS 4 Issued out of stores SERIAL_NUM_STATUS 5 Resides in intransit SERIAL_NUM_STATUS 7 Resides in receiving SERIAL_NUM_STATUS 8 Resides in WIP

WSH_DELIVERY_DETAILS.RELEASED_STATUS DeliveryLine Status Description N Not Ready to Release R Ready to Release S Released to Warehouse B Backordered Y Staged X Not Applicable C Shipped/Closed D Cancelled

TRANSACTIONSOURCE TYPE ID TRANSACTIONSOURCE NAME DESCRIPTION 1 Purchase order Purchase order 2 Sales order Sales order 3 Account Account 4 Move order Move order 5 Job or Schedule Job or Schedule 6 Account alias Account alias 7 Internal requisition Internal requisition 8 Internal order Internal order 9 Cycle Count Cycle Count 10 Physical Inventory Physical Inventory 11 Standard cost update Standard cost updat

TRANSCTIONACTION ID  DESCRIPTION 1 Issue from stores 2 Subinventory transfer 3 Direct organization transfer 4 Cycle count adjustment 8 Physical inventory adjustment 12 Intransit receipt 21 Intransit shipment 24 Cost update 27 Receipt into stores 28 Staging transfer 29 Delivery adjustments 30 WIP scrap transaction 31 Assembly completion 32 Assembly return 33 Negative component issue 34

Transaction Type = Transaction Source Type + Transaction Action Type TRANSACTIONTYPE ID TRANSACTIONNAME DESCRIPTION TRANSACTIONSOURCE ID TRANSACTIONACTION ID 1 Account issue Issue material against account 3 1 2 Subinventory Transfer Transfer material betweensubinventories 13 2 3 Direct Org Transfer Direct transfer betweentwo organizations 13 3 4 Cycle Count Adjust Record cycle count adjustments 9 4 5 Cycle

Oracle Apps Concurrent Request Table Relationship for pdf version,you can download from "Concurrent Request Tables.pdf" FND_CONCURRENT_PROGRAMS eTRM:FND_CONCURRENT_PROGRAMS stores information about concurrent programs. Each row includes a name and description of the concurrent program. Each row also includes the execution methods for the program (EXECUTION_METHOD_CODE), the argument method (ARGUMENT_METHOD_CODE), and whether the program is constrained (QUEUE_METHOD_CODE)

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=INVRSVF1.fmb userid=apps/apps@mz1ms206 module_type=form batch=yes compile_all=special(Non-GUI Mode)frmcmp_batch module=ABCDEFG.fmb userid=apps/apps@instance output_file=ABCDEFG.fmx11if60genm module=INVKBPSQ.fmb userid=apps/apps@lvis115pCompiling Library fileR12.Generate a pllfrmcmp.sh Module=INVSLENT.p

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 profile option references the \'Product Line Accounting\' function area to retrieve the category set.This profile is updateable only at the Site level.INV:Allow Expense to Asset Transaction Indicates whether you can transfer an item from an expensed subinventory to an asset location.This profile is up

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/B53825_08/current/html/docset.htmlEBS 11i User Guidehttp://docs.oracle.com/cd/B25516_18/current/html/docset.htmlOracle Applications Libraryhttp://docs.oracle.com/cd/A60725_05/html/comnls/us/index.htmeTRM(Electronic Technical Reference Manual)http://etrm.oracle.com/pls/etrm/etrm_search.searchUse to chec

File Types.fmbForm binary source code.fmtForm text.fmxForm executable.mmbMenu source code.mmtMenu text.mmxMenu executable.pldText version Package file.plldesign time of library,can open by Form.plxexecutable , complied version.plsDB Level Package File.pkgDB Level Package File转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7444929

System Variables Toutorial System Variables About System Variables A system variable is an Oracle Forms variable that keeps track of an internal Oracle Forms state. You can reference the value of a system variable to control the way an application behaves. Oracle Forms maintains the values of system variables on a per form basis. That is, the values of all system variables correspond only to the current form. The following list presents the names of the available system variab