DBA Data[Home] [Help]

APPS.ONT_ITM_PKG dependencies on RA_TERMS_TL

Line 849: FROM oe_order_headers h, oe_transaction_types_tl ot, ra_terms_tl term

845: SELECT h.order_number, ot.name, h.cust_po_number, h.transactional_curr_code,
846: h.conversion_type_code, h.conversion_rate, h.ordered_date, term.name
847: INTO l_order_number, l_order_type, l_cust_po_number, l_transactional_curr_code,
848: l_conversion_type_code, l_conversion_rate, l_ordered_date, l_payment_term_name
849: FROM oe_order_headers h, oe_transaction_types_tl ot, ra_terms_tl term
850: WHERE h.header_id = p_line_rec.header_id
851: AND h.order_type_id = ot.transaction_type_id
852: AND ot.language = userenv('LANG')
853: AND h.payment_term_id = term.term_id(+)