Hi, I am working on a SQL query related to view PROJECT_FORECAST_ITEM_COST. When opening the project forecast, there is a SQL column address as “&AO.SUB_PROJECT_API.Get_Description(PROJECT_ID,SUB_PROJECT_ID)”. How do I include this column in my SQL query with PROJECT_FORECAST_ITEM_COST table?I would like to understand how API works in general as well when it comes to SQL queries. Many thanksHousseiny
I am getting syntax error when trying to join SQL query with IAL table. Any clues?? select order_no, order_date from( select *from ifsinfo.icfr_pro_116bwhere project_id = '20012') X join IFSAPP.purchase_order Y on X.order_no = Y.order_no ThanksHousseiny
Hi, I have the below two tables with the mentioned fields and sample rows. Table GL_Ledger X has got a lot of actual details down to GL rows while table Budget Y has got budget amounts by Activity_Seq. I need to come up with one report where I have all fields of table X and one additional field for “AMT” coming from budget using the common filed Activity_seq. Two issues in my result:Duplication of budget amounts (in A1 rows). Missing budget for A3 and A5In other words, want to keep all details and rows of table X and pick up all records from table Y with no duplicates.Any clues on how to solve this issue? Also if I will use union all, is there an easy way to copy all table X columns properties to table Y and how to do it if that is the only solution.
HiI got an error with the below line in red when execute. Any clues please. select X.*,IFSAPP.SUB_PROJECT_API.Get_Description(x.PROJECT_ID, x.SUB_PROJECT_ID) Sub_Proj_Des,x.budget_base_curr/120 ITD_BUD,x.actual - ITD_BUD as "Deviation",IFSAPP.ACTIVITY_API.Get_Description(X.ACTIVITY_SEQ) activity_des,IFSAPP.Project_Forecast_Item_API.Get_Project_Cost_Element_Desc(x.FORECAST_ID, x.PROJECT_COST_ELEMENT) cost_elm_desfromproject_forecast_item_all Xwhere project_id = '20062' and forecast_version_id = 'M1003' RegardsHousseiny
Trying to get highest 20 rows of the below query based on “Net Amount in USD” column which is a sum column. Any clues? select INVOICE.IDENTITY as "Identity", supplier.vendor_name,to_char(sum(INVOICE.ACTUAL_NET_DOM_AMOUNT), '$999,999,999') as "Net Amount in USD" from &AO.INVOICE inner join&AO.supplieron &AO.Invoice.identity = &AO.supplier.vendor_nowhere INVOICE.OBJSTATE <> 'Cancelled' group by INVOICE.IDENTITY,vendor_name
HiWhat is the view of posting proposal history? need to retrieve some columns in SQL query. Any clues??RegardsHousseiny
Trying to repeat a specific column “AMOUNT_BALANCE” under this view &AO.ACCOUNTING_BALANCE_AUTH with different periods (i.e. by quarter). what is the easiest way to do it?
I have the below line in SQL query where the user could write only one company or % for all. Is there a way to enable multiple values like we normally do in any view filter by ;? I need this to be a parameter variable based on the user input and not fixed in the query itself. COMPANY LIKE NVL('&COMPANY', '%') regardsHousseiny
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.