DBA Data[Home] [Help]

APPS.QA_PLAN_ELEMENT_API dependencies on SO_LINES

Line 1251: FROM mtl_system_items_kfv msik, so_lines sl

1247: id NUMBER;
1248:
1249: CURSOR c (h_id IN VARCHAR2) IS
1250: SELECT sl.line_number
1251: FROM mtl_system_items_kfv msik, so_lines sl
1252: WHERE sl.inventory_item_id = msik.inventory_item_id
1253: AND header_id = h_id;
1254:
1255: BEGIN

Line 2898: -- "so_lines" is obsoleted in 11i. Replacing it with oe_order_lines

2894: END get_so_number_lov;
2895:
2896:
2897: -- Bug 4958763. SQL Repository Fix SQL ID: 15009074
2898: -- "so_lines" is obsoleted in 11i. Replacing it with oe_order_lines
2899: -- also SO Line Number is not having LOV in Forms and QWB
2900: -- and so removing the lov in Mobile as well
2901: -- even after commenting out it does not require any change in Mobile code
2902: -- saugupta Wed, 08 Feb 2006 03:00:30 -0800 PDT

Line 2922: FROM mtl_system_items_kfv msik, so_lines sl

2918: -- After Single Scan LOV
2919: wild := value;
2920:
2921: sql_string := 'SELECT to_char(sl.line_number), msik.concatenated_segments
2922: FROM mtl_system_items_kfv msik, so_lines sl
2923: WHERE sl.inventory_item_id = msik.inventory_item_id
2924: AND header_id like :1';
2925:
2926: OPEN x_ref FOR sql_string USING wild;