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_QUOTE_HEADERS_PVT dependencies on QP_LIST_HEADERS_VL

Line 7176: from OE_AGREEMENTS_B agr, qp_list_headers_vl pri

7172: /* Start : Code change done for Bug 13064273 */
7173:
7174: CURSOR C_Agreement_PL(p_agreement_id Number) Is
7175: Select pri.list_header_id, pri.currency_code
7176: from OE_AGREEMENTS_B agr, qp_list_headers_vl pri
7177: where agr.agreement_id = p_agreement_id
7178: and pri.list_header_id = agr.price_list_id
7179: and pri.list_type_code in ('PRL','AGR')
7180: and pri.active_flag = 'Y'

Line 7186: from HZ_CUST_ACCOUNTS cust, qp_list_headers_vl pri

7182: and trunc(nvl(pri.end_date_active, sysdate)) >= trunc(sysdate);
7183:
7184: CURSOR C_Customer_PL(p_cust_acct_id Number) Is
7185: Select pri.list_header_id , pri.currency_code
7186: from HZ_CUST_ACCOUNTS cust, qp_list_headers_vl pri
7187: where cust.cust_account_id = p_cust_acct_id
7188: and cust.price_list_id = pri.list_header_id
7189: and pri.list_type_code in ('PRL','AGR')
7190: and pri.active_flag = 'Y'

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'