笨笨乐园

2006年8月3日

BOM Interface

摘要： 一．新增SELECT*FROMBOM.BOM_BILL_OF_MTLS_INTERFACESELECT*FROMBOM.BOM_INVENTORY_COMPS_INTERFACEinsertintobom.bom_bill_of_mtls_interface(assembly_type,--M/Eassembly_item_id,organization_id,process_flag,trans... 阅读全文

posted @ 2006-08-03 19:50 Angus 阅读(607) 评论(0) 推荐(0) 编辑

Item Interface

摘要： 一．新增主组织：INSERTINTOMTL_SYSTEM_ITEMS_INTERFACE(PROCESS_FLAG,TRANSACTION_TYPE,SET_PROCESS_ID,ORGANIZATION_CODE,SEGMENT1,DESCRIPTION)VALUES(1,--PROCESS_FLAG,'CREATE',--TRANSACTION_TYPE,1000,--SET_PROCESS_... 阅读全文

posted @ 2006-08-03 19:33 Angus 阅读(541) 评论(0) 推荐(0) 编辑

PL/SQL Package

摘要： First Step:createtableDEPT(DEPTNONUMBER(20)notnull,DNAMEVARCHAR2(14),LOCVARCHAR2(13))Second Step: createorreplacepackageShowRecordis--Author:ANGUSTANG--Created:2006-08-0315:03:56--Purpose:UseCursorPRO... 阅读全文

posted @ 2006-08-03 15:33 Angus 阅读(587) 评论(3) 推荐(0) 编辑

导航