When I am running a query like this
*******************************************************
SELECT
(SELECT LineOfCredit FROM SI_LoanProduct WHERE acct.FinancialControlId =
SI_LoanProduct.ProductId) AS LineOfCredit,
(acct.acctBalance - la.CreditLimit) as overLimitAmount
FROM
SI_accountPortfolios acpf,
SI_productProperties pp,
SI_accountAssociates assoc,
SI_FinancialControls fc,
SI_Accounts acct,
SI_LOANACCOUNT la
WHERE
assoc.isDeleted = 'N' AND
acpf.CustomerId <> 1 AND
assoc.AssociateCustId = 1 AND
acpf.AcctPortfolioId = acct.acctPortfolioId(+) AND
acct.FinancialControlId = pp.ProductId AND
acct.deleted = 0 AND fc.FinancialControlId = pp.ProductId AND
(la.Undone = NULL OR la.Undone = 0) AND
assoc.accountId = acct.accountId AND acct.accountId = la.accountId(+)
*************************************
getting an error *****************************************************
---- Error -------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-8 POS(12) Execution failed, parse again.
SELECT
(SELECT LineOfCredit FROM SI_LoanProduct WHERE acct.FinancialControlId =
SI_LoanProduct.ProductId) AS LineOfCredit,
(acct.acctBalance - la.CreditLimit) as overLimitAmount
FROM
SI_accountPortfolios acpf,
SI_productProperties pp,
SI_accountAssociates assoc,
SI_FinancialControls fc,
SI_Accounts acct,
SI_LOANACCOUNT la
WHERE
assoc.isDeleted = 'N' AND
acpf.CustomerId <> 1 AND
assoc.AssociateCustId = 1 AND
acpf.AcctPortfolioId = acct.acctPortfolioId(+) AND
acct.FinancialControlId = pp.ProductId AND
acct.deleted = 0 AND fc.FinancialControlId = pp.ProductId AND
(la.Undone = NULL OR la.Undone = 0) AND
assoc.accountId = acct.accountId AND acct.accountId = la.accountId(+)
***************************************************
It is successfully running in oracle(There is no record selected)...I created the same table structure in
sap db..so what is the problem...expecting the reply
jain
_________________________________________________________________
Got a wish? Make it come true. http://server1.msn.co.in/msnleads/citibankpersonalloan/citibankploanjuly03.asp?type=txt Best personal loans!
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
