DBA Data[Home] [Help]

APPS.OE_DEFAULT_LINE dependencies on OE_TRANSACTION_TYPES_TL

Line 2988: oe_transaction_types_tl ott

2984: CURSOR C_ORDER_INFO(ord_line_id NUMBER) IS
2985: SELECT /* MOAC_SQL_CHANGE */ ooh.order_number, ott.name
2986: FROM oe_order_lines_all ool,
2987: oe_order_headers ooh,
2988: oe_transaction_types_tl ott
2989: WHERE ool.line_id = ord_line_id
2990: AND ooh.header_id = ool.header_id
2991: AND ott.transaction_type_id = ooh.order_type_id
2992: -- 6916542 AND ooh.transactional_curr_code = p_curr_code