DBA Data[Home] [Help]

APPS.ASO_QUOTE_HEADERS_PVT dependencies on OE_TRANSACTION_TYPES_ALL

Line 7196: from OE_TRANSACTION_TYPES_ALL ord, qp_list_headers_vl pri

7192: and trunc(nvl(pri.end_date_active, sysdate)) >= trunc(sysdate);
7193:
7194: CURSOR C_Order_Type_PL(p_order_type_id Number) Is
7195: Select pri.list_header_id, pri.currency_code
7196: from OE_TRANSACTION_TYPES_ALL ord, qp_list_headers_vl pri
7197: where ord.TRANSACTION_TYPE_ID = p_order_type_id
7198: and ord.price_list_id = pri.list_header_id
7199: and pri.list_type_code in ('PRL','AGR')
7200: and pri.active_flag = 'Y'