DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on OE_TRANSACTION_TYPES_ALL

Line 161: from OE_TRANSACTION_TYPES_ALL ord, qp_list_headers_vl pri

157: and trunc(nvl(pri.end_date_active, sysdate)) >= trunc(sysdate);
158:
159: CURSOR C_Order_Type_PL(p_order_type_id Number) Is
160: Select pri.list_header_id, pri.currency_code
161: from OE_TRANSACTION_TYPES_ALL ord, qp_list_headers_vl pri
162: where ord.TRANSACTION_TYPE_ID = p_order_type_id
163: and ord.price_list_id = pri.list_header_id
164: and pri.list_type_code in ('PRL','AGR')
165: and pri.active_flag = 'Y'