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
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.
HiWhat is the view of posting proposal history? need to retrieve some columns in SQL query. Any clues??RegardsHousseiny
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
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
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
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
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?
Already have an account? Login
No account yet? Create an account
Enter your username or 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.
