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 OE_ORDER_HEADERS

Line 1396: oe_order_headers sh,

1392:
1393: CURSOR C(v VARCHAR2) IS
1394: SELECT sh.header_id
1395: FROM so_order_types sot,
1396: oe_order_headers sh,
1397: qa_customers_lov_v rc
1398: WHERE sh.order_type_id = sot.order_type_id and
1399: sh.sold_to_org_id = rc.customer_id and
1400: sh.order_category_code in ('RETURN', 'MIXED') and

Line 3052: oe_order_headers sh,

3048: wild := value;
3049:
3050: sql_string := 'SELECT sh.order_number, sot.name
3051: FROM so_order_types sot,
3052: oe_order_headers sh,
3053: qa_customers_lov_v rc
3054: WHERE sh.order_type_id = sot.order_type_id and
3055: sh.sold_to_org_id = rc.customer_id and
3056: sh.order_category_code in (''RETURN'', ''MIXED'') and

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

3079: wild := value;
3080:
3081: sql_string := 'select distinct to_char(oel.line_number),
3082: ''RMA Number: '' || sh.order_number || '';'' || ''Item: '' || oel.ordered_item description
3083: from oe_order_lines oel, so_order_types sot, oe_order_headers sh
3084: where sh.order_type_id = sot.order_type_id and oel.header_id = sh.header_id and
3085: oel.line_category_code in (''RETURN'', ''MIXED'') and
3086: sh.order_number = :1 and
3087: to_char(oel.line_number) like :2