ITPub博客

表 4. BOM.CST_COST_ELEMENTS , 5.  BOM.CST_ACTIVITIES 和 6. INV.MTL_SYSTEM_ITEMS_B[@more@] 4.    TABLE: BOM.CST_COST_ELEMENTSCST_COST_ELEMENTS stores the five seeded cost elements: Material, Material Overhead, Resource, Outside Processing, and Overhead.Primary Key: CST_COST_ELEMENTS_PKCOST_ELEMENT_ID ColumnsNameDatatypeLengthMandatoryCommentsCOST_ELEMENT_IDNUMBER YesCost element identifierCOST_ELEMENTVARCHAR2(50)YesCost element nameDESCRIPTIONVARCHAR2(240)Y

表2. BOM.CST_ITEM_COST_DETAILS 和 3. BOM.CST_COST_TYPES[@more@]2. TABLE: BOM.CST_ITEM_COST_DETAILS (CORE Table)CST_ITEM_COST_DETAILS stores detailed cost information for an item fora cost type. It is the child table of CST_ITEM_COSTS..There are three types of detailed item cost: User-defined, Defaulted,and Rolled up. User-defined costs can be entered in the Item Costswindow. Defaulted and Rolled up costs are generated by CostRollup..If the item does not have cost control information for the

关于Oracle App的表结构描述的文档特别少，自己先整理一部分。记不住所有的表，整理一下至少下次找起来快。核心表是 BOM.CST_ITEM_COST_DETAILS [@more@]Table relationship:Table Foreign TableForeign Key ColumnCST_ITEM_COST_DETAILSCST_ITEM_COSTS CST_ITEM_COST_DETAILS.INVENTORY_ITEM_ID CST_ITEM_COST_DETAILS.COST_TYPE_ID CST_ITEM_COST_DETAILS.ORGANIZATION_ID CST_ITEM_COST_DETAILSCST_COST_TYPES CST_ITEM_COST_DETAILS.COST_TYPE_ID CST_ITEM_COST_DETAILSMTL_SYSTEM_ITEMS_B CST_ITEM_COST_DETAILS.INVENTORY_ITEM

以Table Type Value Set为例，创建和应用value set做试验经常使用的一个目录，也先存到这里 ^_^   /oracle/apps1159/visdb/9.2.0/appsutil/outbound/VIS_tataoracle[@more@]创建 "Table Type Value Set"1. Loing with "Application Developer" responsibility2. click Application --> Validation --> Set3. Input the Value Set Name, select the Format Type accordingly,set the Maximun Size4. select the "Table" as the Validation Type5. Click Edit Information6. 选择包含表名的T

主要4个步骤：1. Enter an Order2. Book the Order3. Pick Release the Order4. Ship the Order[@more@]具体操作(以"AT&T Universal Card"作为示例客户)：1. Login APP as "Order Management Super User, Vision Operations(USA)" responsibility2. Click Orders.Returns --> Sales Orders3. Select "AT&T Universal Card" as the Customer4. In the "Line Items" tab, insert 2 items. One ordered item is "ASO003", the other order item is "ASO004"5. Click

用存储过程实现数据outbound例子 [@more@]1. 创建stored procedure，命名为"test_denilsen_util_p"CREATE OR REPLACE PROCEDURE test_denilsen_util_p (errbuf      OUT VARCHAR2,                                               retcode  &n