[Home] [Help]
APPS.ASO_PROJ_COMM_PVT dependencies on ASO_SALES_CREDITS
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