eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_AUTO_SAMPLE_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 35: --QZENG Bug 13881118 Change view from mtl_system_items_b_kfv to mtl_system_items_vl to support NLS

31: --from ic_item_mst
32: --where item_id = x_item_id_in ;
33: --QZENG Bug 13089703: cut length of item_desc to 80 to support sample_desc Varchar2(80) in table GMD_SAMPLES
34: SELECT substrb(nvl(description, ''),1,80)
35: --QZENG Bug 13881118 Change view from mtl_system_items_b_kfv to mtl_system_items_vl to support NLS
36: --FROM mtl_system_items_b_kfv
37: FROM mtl_system_items_vl
38: WHERE organization_id = x_sampling_event.organization_id
39: AND inventory_item_id = x_inventory_item_id;

Line 37: FROM mtl_system_items_vl

33: --QZENG Bug 13089703: cut length of item_desc to 80 to support sample_desc Varchar2(80) in table GMD_SAMPLES
34: SELECT substrb(nvl(description, ''),1,80)
35: --QZENG Bug 13881118 Change view from mtl_system_items_b_kfv to mtl_system_items_vl to support NLS
36: --FROM mtl_system_items_b_kfv
37: FROM mtl_system_items_vl
38: WHERE organization_id = x_sampling_event.organization_id
39: AND inventory_item_id = x_inventory_item_id;
40:
41: cursor sampling_plan_info (x_sampling_plan_id number) is