APPS.ASO_VALIDATE_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 3986: FROM ASO_QUOTE_LINES_ALL

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

Line 5102: FROM ASO_QUOTE_LINES_ALL aso

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

Line 5107: FROM ASO_QUOTE_LINES_ALL aso

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

Line 5293: SELECT line_category_code from aso_quote_lines_all

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

Line 5472: select quote_line_id from aso_quote_lines_all

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

Line 9549: from aso_payments a, aso_quote_lines_all b

9545: and quote_line_id is null;
9546:
9547: cursor c_get_lines_with_null_payment(p_qte_hdr_id number) is
9548: select b.invoice_to_cust_party_id
9549: from aso_payments a, aso_quote_lines_all b
9550: where a.quote_header_id = b.quote_header_id
9551: and a.quote_line_id = b.quote_line_id
9552: and b.quote_header_id = p_qte_hdr_id
9553: and a.quote_line_id is not null

Line 9712: from aso_quote_lines_all

9708:
9709:
9710: Cursor get_organization_id(l_qte_line_id number) is
9711: select organization_id
9712: from aso_quote_lines_all
9713: where quote_line_id = l_qte_line_id;
9714:
9715: Cursor get_ship_code(l_qte_line_id number) is
9716: select ship_method_code