OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » sql validation in profile？

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sql validation in profile？ [message #173735]

Wed, 24 May 2006 04:55

zhangivan
Messages: 4
Registered: May 2006
Location: Shanghai

Junior Member

SELECT A.CONCATENATED_SEGMENTS, A.CODE_COMBINATION_ID, ATK_GL_GET_CCID_NAME(C.SET_OF_BOOKS_ID,A.CODE_COMBINATION_ID)

FROM GL_CODE_COMBINATIONS_KFV A, GL_CODE_COMBINATIONS_V B, GL_SETS_OF_BOOKS C

WHERE A.CODE_COMBINATION_ID = B.CODE_COMBINATION_ID
--AND C.SET_OF_BOOKS_ID = (SELECT FND_PROFILE.VALUE
('GL_SET_OF_BKS_ID') FROM DUAL)
（i can‘t find any value if this sentence is plus）

AND C.CHART_OF_ACCOUNTS_ID = A.CHART_OF_ACCOUNTS_ID
ORDER BY A.CONCATENATED_SEGMENTS

what does this ’select。。‘ mean？
please give me some help

Report message to a moderator

Re: sql validation in profile？ [message #173740 is a reply to message #173735]

Wed, 24 May 2006 05:17

manwadkar
Messages: 104
Registered: September 2005
Location: Washington DC

Senior Member

It goes and find out SET OF BOOKS ID from profile option value

Report message to a moderator

Previous Topic:	Vendor Sites
Next Topic:	Project accounting materils plz

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 03:31:30 CDT 2024