打開檢查form , 查所有PLSQL ,關鍵字LOV_NAME  和 user_attribute_value
找到
MTL_ITEM_TEMPL_ATTRIBUTES_PKG
有如下指令

 


        trunc_name := substr(:mtl_item_templ_attributes.attribute_name, 18, 27);
        Set_Item_Property('mtl_item_templ_attributes.user_attribute_value',
     LOV_NAME, trunc_name||'_QP');
        set_item_property('mtl_item_templ_attributes.user_attribute_value',
     LOV_VALIDATION, PROPERTY_TRUE);

 

 

 

 

得知下拉選單的值是由substr(:mtl_item_templ_attributes.attribute_name, 18, 27)+'_QP' 得出的
因此進form 查 ATTRIBUTE_NAME 得MTL_SYSTEM_ITEMS.RECEIVING_ROUTING_ID
substr(:mtl_item_templ_attributes.attribute_name, 18, 27)+'_QP' =RECEIVING_ROUTING_ID_QP

  temp1.jpg  



尋找form record group 'RECEIVING_ROUTING_ID_QP'

 

temp2.jpg  

 

得到SQL 抓出來調整成ZHT執行後
 
select routing_name, description, routing_header_id from (
   SELECT   TO_NUMBER (lookup_code) routing_header_id,
            last_update_date,
            last_updated_by,
            creation_date,
            created_by,
            last_update_login,
            meaning routing_name,
            attribute_category,
            attribute1,
            attribute2,
            attribute3,
            attribute4,
            attribute5,
            attribute6,
            attribute7,
            attribute8,
            attribute9,
            attribute10,
            attribute11,
            attribute12,
            attribute13,
            attribute14,
            attribute15,
            description
     FROM   fnd_lookup_values lv
    WHERE       LANGUAGE = 'ZHT'
            AND view_application_id = 0
            AND security_group_id = 0
            AND lookup_type = 'RCV_ROUTING_HEADERS'  ) order by routing_name

 

arrow
arrow
    全站熱搜

    Nolem 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄