APPS.ASO_PROJ_COMM_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 30: FROM ASO_QUOTE_HEADERS_ALL

26:
27: CURSOR C_Get_Header_Info (l_qte_hdr NUMBER) IS
28: SELECT Quote_Number, Last_Update_Date, Quote_Expiration_Date, Quote_Status_Id,
29: Pricing_Status_Indicator, Price_Updated_Date, Credit_Update_Date, Object_Version_Number, Org_Id
30: FROM ASO_QUOTE_HEADERS_ALL
31: WHERE Quote_Header_Id = l_qte_hdr;
32:
33: CURSOR C_Check_Qte_Ordered (l_status NUMBER) IS
34: SELECT 'Y'

Line 314: FROM ASO_QUOTE_LINES_ALL A, ASO_SALES_CREDITS B, ASO_QUOTE_HEADERS_ALL C

310: A.Inventory_Item_Id,
311: SYSDATE,
312: (DECODE(A.Line_Category_Code,'RETURN',-1,1) * A.Quantity * A.Line_Quote_Price) * (SUM(B.Percent)/100) Sales_Credit_Amount,
313: NVL(A.Currency_Code, C.Currency_Code)
314: FROM ASO_QUOTE_LINES_ALL A, ASO_SALES_CREDITS B, ASO_QUOTE_HEADERS_ALL C
315: WHERE A.Quote_Header_Id = P_Qte_Header_Rec.Quote_Header_Id
316: AND A.Quote_Header_Id = B.Quote_Header_Id
317: AND A.Quote_Header_Id = C.Quote_Header_Id
318: AND B.Resource_Id = P_Resource_Id

Line 336: FROM ASO_QUOTE_LINES_ALL A, ASO_QUOTE_HEADERS_ALL B

332: A.Inventory_Item_Id,
333: SYSDATE,
334: 0,
335: NVL(A.Currency_Code, B.Currency_Code)
336: FROM ASO_QUOTE_LINES_ALL A, ASO_QUOTE_HEADERS_ALL B
337: WHERE A.Quote_Header_Id = P_Qte_Header_Rec.Quote_Header_Id
338: AND A.Quote_Header_Id = B.Quote_Header_Id
339: AND A.Quote_Line_Id NOT IN
340: (SELECT C.Line_Number