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 3977: FROM ASO_QUOTE_HEADERS_ALL

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

Line 3982: FROM ASO_QUOTE_HEADERS_ALL

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

Line 5097: FROM ASO_QUOTE_HEADERS_ALL aso

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

Line 5298: SELECT quote_category_code from aso_quote_headers_all

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