Oracle ERP
-
编辑 删除
Oracle 10g Installation under Win7
1. 虚拟内存手动设置2. 使用XP兼容模式安装
-
编辑 删除
Get the column name or table name from prompt of DFF
SELECT T.FORM_LEFT_PROMPT,T.FORM_ABOVE_PROMPT,B.DESCRIPTIVE_FLEX_CONTEXT_CODE,B.APPLICATION_COLUMN_NAMEFROM APPS.FND_DESCR_FLEX_COL_USAGE_TL T,APPS.FND_DESCR_FLEX_COLUMN_USAGES BWHERE B.APPLICATION_I...
-
编辑 删除
All Inventories Value Report - Standard Report
最近有做一张报表，需要用到All Inventories Values Report这张Oracle Standard Report的Receiving Value，现将代码记录如下: SELECT SUM(RECEIVE_QTY.RAW_QTY) RAW_QTY,SUM(RECEIVE_QTY.RAW_VALUE_QTY * RE...
