APPS.ASO_UTILITY_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 3380: FROM ASO_QUOTE_LINES_ALL

3376: -- ER 12879412
3377: l_qte_line_rec.PRODUCT_FISC_CLASSIFICATION,
3378: l_qte_line_rec.TRX_BUSINESS_CATEGORY*/
3379:
3380: FROM ASO_QUOTE_LINES_ALL
3381: WHERE quote_line_id = p_qte_line_id;
3382: RETURN l_qte_line_rec;
3383: EXCEPTION
3384: WHEN NO_DATA_FOUND THEN

Line 3489: FROM ASO_Quote_Lines_All

3485: PRODUCT_FISC_CLASSIFICATION,
3486: TRX_BUSINESS_CATEGORY
3487: */
3488:
3489: FROM ASO_Quote_Lines_All
3490: WHERE quote_header_id = p_qte_header_id
3491: ORDER BY Line_Number;
3492: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3493: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 4246: FROM ASO_Quote_Lines_All

4242: -- ER 12879412
4243: PRODUCT_FISC_CLASSIFICATION,
4244: TRX_BUSINESS_CATEGORY
4245: */
4246: FROM ASO_Quote_Lines_All
4247: WHERE quote_header_id = p_qte_header_id
4248: ORDER BY Line_Number;
4249:
4250: CURSOR c_Qte_Line_SVC_ref(p_qte_line_id IN NUMBER) IS

Line 4282: from ASO_QUOTE_LINES_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)
4282: from ASO_QUOTE_LINES_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

Line 4785: FROM ASO_Quote_Lines_All

4781: -- ER 12879412
4782: PRODUCT_FISC_CLASSIFICATION,
4783: TRX_BUSINESS_CATEGORY
4784: */
4785: FROM ASO_Quote_Lines_All
4786: WHERE quote_header_id = p_qte_header_id
4787: AND quote_line_id = p_qte_line_id
4788: ORDER BY Line_Number;
4789:

Line 4820: from ASO_QUOTE_LINES_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)
4820: from ASO_QUOTE_LINES_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

Line 4867: from aso_quote_lines_all

4863: /* Start bug 13482837 for current quote service reference */
4864:
4865: cursor c_curr_quote_line_details(p_Quote_line_id number) is
4866: select inventory_item_id,quantity,line_list_price,PRICING_QUANTITY_UOM,PRICING_QUANTITY
4867: from aso_quote_lines_all
4868: where quote_line_id=p_quote_line_id;
4869:
4870: /* End bug 13482837 for current quote service reference */
4871: