DBA Data[Home] [Help]

APPS.GMD_QC_ERES_UTILS dependencies on OE_ORDER_HEADERS_ALL

Line 398: FROM oe_order_headers_all

394: ) IS
395:
396: CURSOR c1 IS
397: SELECT order_number
398: FROM oe_order_headers_all
399: WHERE header_id = p_order_id
400: ;
401:
402: BEGIN

Line 416: FROM oe_order_headers_all a, oe_transaction_types_tl b

412: ) IS
413:
414: CURSOR c1 IS
415: SELECT b.name
416: FROM oe_order_headers_all a, oe_transaction_types_tl b
417: WHERE a.order_type_id = b.transaction_type_id
418: AND a.header_id = p_order_id
419: ;
420: