DBA Data[Home] [Help]

APPS.OE_DEFAULT_LINE dependencies on OE_TRANSACTION_TYPES_TL

Line 2869: oe_transaction_types_tl ott

2865: CURSOR C_ORDER_INFO(ord_line_id NUMBER) IS
2866: SELECT /* MOAC_SQL_CHANGE */ ooh.order_number, ott.name
2867: FROM oe_order_lines_all ool,
2868: oe_order_headers ooh,
2869: oe_transaction_types_tl ott
2870: WHERE ool.line_id = ord_line_id
2871: AND ooh.header_id = ool.header_id
2872: AND ott.transaction_type_id = ooh.order_type_id
2873: -- 6916542 AND ooh.transactional_curr_code = p_curr_code