Home » Applications » Oracle Fusion Apps & E-Business Suite » how to pick account (oracle 10g)
how to pick account [message #463172] Tue, 29 June 2010 23:59 Go to next message
ashish_f
Messages: 14
Registered: May 2010
Junior Member
hi all,i am new in oracle apps
following is my query to generate bill of entry

select BOE_ID ,ORGANIZATION_ID,BOE_TYPE,PORT_CODE,BOL_DATE,BOE_AMOUNT
from JAI_CMN_BOE_HDRS

i need to add one field in above query i.e.account code combination.
How can i pick that particular account in which that BOE_AMOUNT getting stored.

Report message to a moderator

Re: how to pick account [message #464888 is a reply to message #463172] Sat, 10 July 2010 05:08 Go to previous message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member
Can you describe the tables Structure where you get BOE_AMOUNT ?

Report message to a moderator

Previous Topic: Lot/Serial validation
Next Topic: line level
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 13:02:58 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.