DBA Data[Home] [Help]

APPS.ONT_ITM_PKG dependencies on RA_TERMS_TL

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

1025: SELECT h.order_number, ot.name, h.cust_po_number, h.transactional_curr_code,
1026: h.conversion_type_code, h.conversion_rate, h.ordered_date, term.name
1027: INTO l_order_number, l_order_type, l_cust_po_number, l_transactional_curr_code,
1028: l_conversion_type_code, l_conversion_rate, l_ordered_date, l_payment_term_name
1029: FROM oe_order_headers h, oe_transaction_types_tl ot, ra_terms_tl term
1030: WHERE h.header_id = p_line_rec.header_id
1031: AND h.order_type_id = ot.transaction_type_id
1032: AND ot.language = userenv('LANG')
1033: AND h.payment_term_id = term.term_id(+)