APPS.ASO_UTILITY_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 750: FROM ASO_QUOTE_HEADERS_ALL

746: l_qte_header_rec.TRX_BUSINESS_CATEGORY */
747:
748:
749:
750: FROM ASO_QUOTE_HEADERS_ALL
751: WHERE quote_header_id = p_qte_header_id;
752: RETURN l_qte_header_rec;
753: EXCEPTION
754: WHEN NO_DATA_FOUND THEN

Line 4265: FROM ASO_QUOTE_HEADERS_ALL

4261: /* Cursors used for the customer_products*/
4262:
4263: /*CURSOR c_get_cust_acct_id IS
4264: SELECT cust_account_id
4265: FROM ASO_QUOTE_HEADERS_ALL
4266: WHERE quote_header_id = p_qte_header_id;
4267: */
4268: CURSOR c_get_orig_order_line_id(p_instance_id IN NUMBER, p_cust_account_id NUMBER) IS
4269: SELECT original_order_line_id

Line 4277: from ASO_QUOTE_HEADERS_ALL

4273:
4274: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
4275: CURSOR c_get_cust_acct_id IS
4276: select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',nvl(END_CUSTOMER_CUST_ACCOUNT_ID,cust_account_id),cust_account_id) cust_account_id
4277: from ASO_QUOTE_HEADERS_ALL
4278: WHERE quote_header_id = p_qte_header_id;
4279:
4280: CURSOR c_get_cust_acct_id_ln(p_qte_line_id number) IS
4281: select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',END_CUSTOMER_CUST_ACCOUNT_ID)

Line 4287: from aso_quote_headers_all

4283: WHERE quote_line_id = p_qte_line_id;
4284:
4285: cursor c_get_price_list(p_qte_hdr_id number) is
4286: select price_list_id
4287: from aso_quote_headers_all
4288: where quote_header_id = p_qte_hdr_id;
4289:
4290:
4291: l_cust_account_id number;

Line 4815: from ASO_QUOTE_HEADERS_ALL

4811:
4812: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
4813: CURSOR c_get_cust_acct_id IS
4814: select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',nvl(END_CUSTOMER_CUST_ACCOUNT_ID,cust_account_id),cust_account_id) cust_account_id
4815: from ASO_QUOTE_HEADERS_ALL
4816: WHERE quote_header_id = p_qte_header_id;
4817:
4818: CURSOR c_get_cust_acct_id_ln(p_qte_line_id number) IS
4819: select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',END_CUSTOMER_CUST_ACCOUNT_ID)

Line 4825: from aso_quote_headers_all

4821: WHERE quote_line_id = p_qte_line_id;
4822:
4823: cursor c_get_price_list(p_qte_hdr_id number) is
4824: select price_list_id
4825: from aso_quote_headers_all
4826: where quote_header_id = p_qte_hdr_id;
4827:
4828:
4829: l_cust_account_id number;

Line 4833: FROM ASO_QUOTE_HEADERS_ALL

4829: l_cust_account_id number;
4830:
4831: /* CURSOR c_get_cust_acct_id IS
4832: SELECT cust_account_id
4833: FROM ASO_QUOTE_HEADERS_ALL
4834: WHERE quote_header_id = p_qte_header_id;*/
4835:
4836: /*** End: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
4837: