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.QA_PLAN_ELEMENT_API dependencies on SO_ORDER_TYPES

Line 1414: FROM so_order_types sot,

1410: id NUMBER;
1411:
1412: CURSOR C(v VARCHAR2) IS
1413: SELECT sh.header_id
1414: FROM so_order_types sot,
1415: oe_order_headers sh,
1416: qa_customers_lov_v rc
1417: WHERE sh.order_type_id = sot.order_type_id and
1418: sh.sold_to_org_id = rc.customer_id and

Line 3143: FROM so_order_types sot,

3139: -- After Single Scan LOV
3140: wild := value;
3141:
3142: sql_string := 'SELECT sh.order_number, sot.name
3143: FROM so_order_types sot,
3144: oe_order_headers sh,
3145: qa_customers_lov_v rc
3146: WHERE sh.order_type_id = sot.order_type_id and
3147: sh.sold_to_org_id = rc.customer_id and

Line 3175: from oe_order_lines oel, so_order_types sot, oe_order_headers sh

3171: wild := value;
3172:
3173: sql_string := 'select distinct to_char(oel.line_number),
3174: ''RMA Number: '' || sh.order_number || '';'' || ''Item: '' || oel.ordered_item description
3175: from oe_order_lines oel, so_order_types sot, oe_order_headers sh
3176: where sh.order_type_id = sot.order_type_id and oel.header_id = sh.header_id and
3177: oel.line_category_code in (''RETURN'', ''MIXED'') and
3178: sh.order_number = :1 and
3179: to_char(oel.line_number) like :2