APPS.ASO_VALIDATE_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 3983: FROM ASO_QUOTE_LINES_ALL

3979: FROM ASO_QUOTE_HEADERS_ALL
3980: WHERE Quote_Header_Id = l_qte_hdr_id;
3981: CURSOR C_Line_Cur(l_qte_ln_id NUMBER) IS
3982: SELECT Agreement_Id, Commitment_Id, Inventory_Item_Id
3983: FROM ASO_QUOTE_LINES_ALL
3984: WHERE Quote_Line_Id = l_qte_ln_id;
3985:
3986: l_Org_Id NUMBER;
3987: l_Currency_Code VARCHAR2(15);

Line 5099: FROM ASO_QUOTE_LINES_ALL aso

5095: WHERE aso.quote_header_id = p_qte_header_id;
5096:
5097: CURSOR C_qte_line_organization IS
5098: SELECT aso.organization_id
5099: FROM ASO_QUOTE_LINES_ALL aso
5100: WHERE aso.quote_line_id = p_qte_line_id;
5101:
5102: CURSOR C_qte_line_org_id_info IS
5103: SELECT aso.org_id

Line 5104: FROM ASO_QUOTE_LINES_ALL aso

5100: WHERE aso.quote_line_id = p_qte_line_id;
5101:
5102: CURSOR C_qte_line_org_id_info IS
5103: SELECT aso.org_id
5104: FROM ASO_QUOTE_LINES_ALL aso
5105: WHERE aso.quote_line_id = p_qte_line_id;
5106:
5107: l_start_date DATE;
5108: l_end_date DATE;

Line 5290: SELECT line_category_code from aso_quote_lines_all

5286: IS
5287: --Validate line category code for the quote line
5288: --against the Order type using the following query:
5289: Cursor c_ln_category_code is
5290: SELECT line_category_code from aso_quote_lines_all
5291: where quote_line_id = p_qte_line_rec.quote_line_id;
5292:
5293:
5294: Cursor c_qte_category_code is

Line 5469: select quote_line_id from aso_quote_lines_all

5465: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
5466: is
5467:
5468: cursor c_quote is
5469: select quote_line_id from aso_quote_lines_all
5470: where quote_line_id = p_service_ref_line_id
5471: and quote_header_id = p_qte_header_id;
5472:
5473: cursor c_order is

Line 9501: from aso_payments a, aso_quote_lines_all b

9497: and quote_line_id is null;
9498:
9499: cursor c_get_lines_with_null_payment(p_qte_hdr_id number) is
9500: select b.invoice_to_cust_party_id
9501: from aso_payments a, aso_quote_lines_all b
9502: where a.quote_header_id = b.quote_header_id
9503: and a.quote_line_id = b.quote_line_id
9504: and b.quote_header_id = p_qte_hdr_id
9505: and a.quote_line_id is not null

Line 9664: from aso_quote_lines_all

9660:
9661:
9662: Cursor get_organization_id(l_qte_line_id number) is
9663: select organization_id
9664: from aso_quote_lines_all
9665: where quote_line_id = l_qte_line_id;
9666:
9667: Cursor get_ship_code(l_qte_line_id number) is
9668: select ship_method_code