Hi I'm new in ERP - Oracle Application
i appriciate if any one help me in this issue
i need SQL to get
badeget balance
Acutal Balance
Encumbrance Balance
fund Avalable
thanx
ahmed
Answer / Umesh Pandit
To get the budget information you mentioned (Budget Balance, Actual Balance, Encumbrance Balance, and Fund Available), you can use Oracle's FND_PROJECT_ACTIVITIES view. Here is an example SQL query:nn```sqlnSELECT budget_id, budget_name, budget_amount, actual_amount, encumbrance_amount, fund_available nFROM fnd_project_activities nWHERE budget_id = '<your budget id>' nORDER BY activity_id;n```nReplace '<your budget id>' with your specific budget ID. This query retrieves the budget details for a given budget ID and sorts them by activity ID.
| Is This Answer Correct ? | 0 Yes | 0 No |
Can any one tell me Client Interaction?
What is Intercompany Invoicing?
what is invoice variance in ap
On what basis you will define accounting structure
why should we create prorate calender and what is the difference between depreciation calender and prorate calender in fixed assets module?
What is a Value set and types of value set?
What is the basic setup of payable?
At what level FA is implemented?
what is internal retairment?
Is FA Supports Multi _org?
Is it possible to import invoices of a specific Sales Order?
What kind of budgets have you worked on?