adspace


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 Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what r issues faced in gl

2871


I am traying to access oracle functiona/ technical interview questions asked by the consultancy "infosys", but i cant find anything when i go the to the links, i need the oracle erp techno functiona questions pls, Thanks, in advance Tovia

2535


1.what is the name of program to create invoice automatic from po.? 2.How to auto upload the bank statement? 3.PO tax has not flown to invoice . why? Debit memo not generated for return of goods.??

3553