APPS.ASO_PROJ_COMM_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 47: FROM ASO_QUOTE_LINES_ALL

43: AND Resource_Id = l_resource;
44:
45: CURSOR C_Get_Line_Id (l_hdr_id NUMBER) IS
46: SELECT Quote_Line_Id
47: FROM ASO_QUOTE_LINES_ALL
48: WHERE Quote_Header_Id = l_hdr_id;
49:
50: C_Header_Info C_Get_Header_Info%ROWTYPE;
51:

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