如果LOV来源不是系统原有表中的数据,而是需要自己定义的,那么可使用值集定义好数据源,然后在这里的SQL中使用,下面的例子就是这样的: 上述例子中,lov数据来源于fnd_flex_values_vl视图,该视图中的内容是用户可以在界面上定义增加的,一般步骤是: a)先定义一个值集(Nav:系统管理员责任->应用产品->验证->请求集:...
select * from fnd_application select * from fnd_application_tl where application_id=101 select * from fnd_application_vl where application_id = 101 ---值集 select * from fnd_flex_value_sets select * from fnd_flex_values select * from fnd_flex_values_vl ---弹性域 select * from fnd_id...
gl_code_combinations glcc, fnd_flex_values_vl glf, gl_periods gp, gl_sets_of_books gsb, po_vendors p WHERE … 4、指示优化器的方法与目标的hints: ALL_ROWS -- 基于代价的优化器,以吞吐量为目标 FIRST_ROWS(n) -- 基于代价的优化器,以响应时间为目标 CHOOSE -- 根据是否有统计信息,选择不同的...
select * from fnd_application_tl where application_id= 101 select * from fnd_application_vl where application_id = 101 -- 值集 select * from fnd_flex_value_sets select * from fnd_flex_values select * from fnd_flex_values_vl -- 弹性域 ...
上述例子中,lov数据来源于fnd_flex_values_vl视图,该视图中的内容是用户可以在界面上定义增加的,一般步骤是: a)先定义一个值集(Nav:系统管理员责任->应用产品->验证->请求集: 值集名将用在上面的sql中,验证类型为独立。 b)为新定义的值集添加值(NAV:系统管理员责任->应用产品->验证->值) ...
Oracle Form Builder FRM-40212,OracleFormBuilderFRM-40212错误
I am doing a report in oracle ebs r12 and I need to list flex values from fnd_flex_values_vl view in a hierarchical way using a SQL query. It doesn`t necessary has to be a hierarchial query. Any query will do. I just need a SQL statement that will return me flex values in ...
事务处理来源类型:MTL_TXN_SOURCE_TYPES 事务处理类型:MTL_TRANSACTION_TYPES 查找组织:HR_ORGANIZATION_UNITS_V 查找子库存:MTL_SECONDARY_INVENTORIES_FK_V 查找货位:MTL_ITEM_LOCATIONS 查找弹性域值集:FND_FLEX_VALUES_VL 采购模块: 申请汇总:PO_REQUISITION_HEADERS_INQ_ALL 申请行汇总:PO_REQUISITION_LINES_INQ...
--Äê¶Èselectb.FLEX_VALUE,b.FLEX_VALUE_ID,b.DESCRIPTIONfromapps.FND_FLEX_VALUE_SETSa,apps.fnd_flex_values_vlbwhereA.FLEX_VALUE_SET_ID=B.FLEX_VALUE_SET_IDANDA.flex_value_set_name='PS_Äê¶È';--ÃŵêÀàÐÍSELECTt.lookup_code,t.meaningFROMFND_LOOKUP_VALUESTW...
ANDFSV.ID_FLEX_CODE='GL#' ANDFSV.ATTRIBUTE_VALUE='Y' ANDFSV.APPLICATION_COLUMN_NAME=FDF.APPLICATION_COLUMN_NAME ANDFSV.SEGMENT_ATTRIBUTE_TYPE<>'GL_GLOBAL')弹性域限定词,*/ fdf.DEFAULT_TYPE默认类型, fdf.DEFAULT_VALUE默认值 FROMFND_ID_FLEX_SEGMENTS_VLFDF,FND_FLEX_VALUE_SETSVS WHEREFDF....