DBA Data[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