eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_COPY_QUOTE_PVT dependencies on QP_LIST_HEADERS_VL

Line 141: from OE_AGREEMENTS_B agr, qp_list_headers_vl pri

137: /* Start : Code change done for Bug 12674665 */
138:
139: CURSOR C_Agreement_PL(p_agreement_id Number) Is
140: Select pri.list_header_id, pri.currency_code
141: from OE_AGREEMENTS_B agr, qp_list_headers_vl pri
142: where agr.agreement_id = p_agreement_id
143: and pri.list_header_id = agr.price_list_id
144: and pri.list_type_code in ('PRL','AGR')
145: and pri.active_flag = 'Y'

Line 151: from HZ_CUST_ACCOUNTS cust, qp_list_headers_vl pri

147: and trunc(nvl(pri.end_date_active, sysdate)) >= trunc(sysdate);
148:
149: CURSOR C_Customer_PL(p_cust_acct_id Number) Is
150: Select pri.list_header_id , pri.currency_code
151: from HZ_CUST_ACCOUNTS cust, qp_list_headers_vl pri
152: where cust.cust_account_id = p_cust_acct_id
153: and cust.price_list_id = pri.list_header_id
154: and pri.list_type_code in ('PRL','AGR')
155: and pri.active_flag = 'Y'

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'