APPS.ASO_VALIDATE_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 1623: from aso_quote_headers_all

1619: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1620: IS
1621: CURSOR C_quote_number IS
1622: select quote_version
1623: from aso_quote_headers_all
1624: where quote_number = p_quote_number;
1625:
1626: l_version varchar(240);
1627: BEGIN

Line 3974: FROM ASO_QUOTE_HEADERS_ALL

3970: AND ratrx.customer_trx_id = l_commitment_id;
3971:
3972: CURSOR C_Get_Agreement(l_qte_hdr_id NUMBER) IS
3973: SELECT Contract_Id
3974: FROM ASO_QUOTE_HEADERS_ALL
3975: WHERE Quote_Header_Id = l_qte_hdr_id;
3976:
3977: CURSOR C_Header_Cur(l_qte_hdr_id NUMBER) IS
3978: SELECT Org_Id, Currency_Code, Invoice_To_Cust_Account_Id

Line 3979: FROM ASO_QUOTE_HEADERS_ALL

3975: WHERE Quote_Header_Id = l_qte_hdr_id;
3976:
3977: CURSOR C_Header_Cur(l_qte_hdr_id NUMBER) IS
3978: SELECT Org_Id, Currency_Code, Invoice_To_Cust_Account_Id
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

Line 5094: FROM ASO_QUOTE_HEADERS_ALL aso

5090: AND fl.enabled_flag = 'Y';
5091:
5092: CURSOR C_qte_header_org_info IS
5093: SELECT aso.org_id
5094: FROM ASO_QUOTE_HEADERS_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

Line 5295: SELECT quote_category_code from aso_quote_headers_all

5291: where quote_line_id = p_qte_line_rec.quote_line_id;
5292:
5293:
5294: Cursor c_qte_category_code is
5295: SELECT quote_category_code from aso_quote_headers_all
5296: where quote_header_id = p_qte_header_rec.quote_header_id;
5297:
5298: l_line_category_code VARCHAR2(30);
5299: l_quote_category_code VARCHAR2(240);