APC&INV different about items
来源:互联网 发布:美发软件那个好 编辑:程序博客网 时间:2024/06/09 07:45
SELECT *
FROM (SELECT msib.segment1 item_num,
fl_col.descriptive_flex_context_code attr_group_name,
fl_col.end_user_column_name attr_internal_name_apc,
tl.form_left_prompt attr_name_apc,
fl_col.application_column_name database_column_apc,
DECODE (fl_col.application_column_name,
'C_EXT_ATTR1', emib.c_ext_attr1,
'C_EXT_ATTR2', emib.c_ext_attr2,
'C_EXT_ATTR3', emib.c_ext_attr3,
'C_EXT_ATTR4', emib.c_ext_attr4,
'C_EXT_ATTR5', emib.c_ext_attr5,
'C_EXT_ATTR6', emib.c_ext_attr6,
'C_EXT_ATTR7', emib.c_ext_attr7,
'C_EXT_ATTR8', emib.c_ext_attr8,
'C_EXT_ATTR9', emib.c_ext_attr9,
'C_EXT_ATTR10', emib.c_ext_attr10,
'C_EXT_ATTR11', emib.c_ext_attr11,
'C_EXT_ATTR12', emib.c_ext_attr12,
'C_EXT_ATTR13', emib.c_ext_attr13,
'C_EXT_ATTR14', emib.c_ext_attr14,
'C_EXT_ATTR15', emib.c_ext_attr15,
'C_EXT_ATTR16', emib.c_ext_attr16,
'C_EXT_ATTR17', emib.c_ext_attr17,
'C_EXT_ATTR18', emib.c_ext_attr18,
'C_EXT_ATTR19', emib.c_ext_attr19,
'C_EXT_ATTR20', emib.c_ext_attr20,
'C_EXT_ATTR21', emib.c_ext_attr21,
'C_EXT_ATTR22', emib.c_ext_attr22,
'C_EXT_ATTR23', emib.c_ext_attr23,
'C_EXT_ATTR24', emib.c_ext_attr24,
'C_EXT_ATTR25', emib.c_ext_attr25,
'C_EXT_ATTR26', emib.c_ext_attr26,
'C_EXT_ATTR27', emib.c_ext_attr27,
'C_EXT_ATTR28', emib.c_ext_attr28,
'C_EXT_ATTR29', emib.c_ext_attr29,
'C_EXT_ATTR30', emib.c_ext_attr30,
'C_EXT_ATTR31', emib.c_ext_attr31,
'C_EXT_ATTR32', emib.c_ext_attr32,
'C_EXT_ATTR33', emib.c_ext_attr33,
'C_EXT_ATTR34', emib.c_ext_attr34,
'C_EXT_ATTR35', emib.c_ext_attr35,
'C_EXT_ATTR36', emib.c_ext_attr36,
'C_EXT_ATTR37', emib.c_ext_attr37,
'C_EXT_ATTR38', emib.c_ext_attr38,
'C_EXT_ATTR39', emib.c_ext_attr39,
'C_EXT_ATTR40', emib.c_ext_attr40
) attr_name_value_apc,
(SELECT MAX (mdev.element_value)
FROM mtl_descr_element_values mdev
WHERE msib.inventory_item_id =
mdev.inventory_item_id
AND mdev.element_name = tl.form_left_prompt)
attr_value_inv
FROM fnd_descr_flex_column_usages fl_col,
ego_fnd_dsc_flx_ctx_ext fl_ctx_ext,
fnd_descr_flex_col_usage_tl tl,
ego_mtl_sy_items_ext_b emib,
mtl_system_items_b msib,
hr_organization_units hou,
mtl_item_catalog_groups_tl mcg,
fnd_descr_flex_contexts_tl fdfct
WHERE msib.organization_id = hou.organization_id
AND hou.NAME = 'Item Master Org - IO'
AND (msib.item_type = 'EMM' OR msib.item_type = 'OEMOD')
AND msib.item_catalog_group_id = mcg.item_catalog_group_id
AND fdfct.application_id = fl_col.application_id
AND fl_col.application_id = fl_ctx_ext.application_id
AND fl_col.descriptive_flex_context_code =
fl_ctx_ext.descriptive_flex_context_code
AND fl_col.descriptive_flexfield_name =
fl_ctx_ext.descriptive_flexfield_name
AND tl.application_id = fl_col.application_id
AND tl.descriptive_flexfield_name =
fl_col.descriptive_flexfield_name
AND tl.descriptive_flex_context_code =
fl_col.descriptive_flex_context_code
AND tl.application_column_name = fl_col.application_column_name
AND fl_col.enabled_flag = 'Y'
AND tl.LANGUAGE = USERENV ('LANG')
AND tl.LANGUAGE = mcg.LANGUAGE
AND tl.LANGUAGE = fdfct.LANGUAGE
AND emib.organization_id = hou.organization_id
AND emib.attr_group_id = fl_ctx_ext.attr_group_id
AND fdfct.descriptive_flex_context_code =
fl_ctx_ext.descriptive_flex_context_code
AND fdfct.descriptive_flex_context_name = mcg.description
AND fl_ctx_ext.application_id > 0
AND emib.inventory_item_id = msib.inventory_item_id
AND emib.organization_id = msib.organization_id
AND fl_col.descriptive_flex_context_code <> 'EMR_PIC_ATTRIBS'
-- AND msib.SEGMENT1='EZX2-A20'
)
WHERE NVL (attr_name_value_apc, CHR (0)) <> NVL (attr_value_inv, CHR (0))
- APC&INV different about items
- apc
- apc
- apc
- apc
- apc
- APC
- APC
- A different way to think about creative genius
- about Redefinition of sqlite3 as different kind of symbol
- HowTo: ListView, Adapter, getView and different list items’ layouts in one ListView
- HowTo: ListView, Adapter, getView and different list items’ layouts in one ListView
- HowTo: ListView, Adapter, getView and different list items’ layouts in one ListView
- HowTo: ListView, Adapter, getView and different list items’ layouts in one ListView
- HowTo: ListView, Adapter, getView and different list items’ layouts in one ListView
- HowTo: ListView, Adapter, getView and different list items’ layouts in one ListView
- HowTo: ListView, Adapter, getView and different list items’ layouts in one ListView
- INV - 多組織架構
- Mock RequestContextListener
- C++编译错误 error C2143 error C2146
- UINavigationController
- 如何编译并打开WinCE Bluetooth Stack的LOG
- OpenR2 呼叫流程
- APC&INV different about items
- 网络端口大全
- eclipse遇到An error has occurred. See the log file
- 子线程阻塞的一个解决方案
- java中long,int,short与byte数组之间的转换
- LVS Tutorial
- ok6410增加工作队列的platform按键驱动程序
- 用CoreText 实现显示可点击 的URL
- vlc的应用之一:在命令行下的使用