Note:- I have prepared this query since I could not find any inbuilt functions or procedures in Oracle to get this. I had the requirement to treat 2 dates are same if differences is not more then 2 seconds.For the Seconds:-——————-SELECT (‘Your first Date’-‘Your another Date’) * DECODE( UPPER(‘SS’), ‘SS’, 24*60*60 , ‘MI’, 24*60, ‘HH’, 24, […]
Lot of time we want to close the Notification which has come to the user.They are many ways to do it. The following script can be use to Close the Notification./*********************************************— Date ‘Current Date’— Author JPREDDY— Purpose : Close Notifications**********************************************/BEGIN wf_notification.RESPOND( 12504888, — Notification ID.‘Close requested by on ‘||Sysdate, — Comments‘IM12345’ ); — Incident Number. COMMIT;END; /You can […]
When we are define Modifier in the OM module. We can define Modifier at the particular Item or all the Items in the Price List/Item Category etc. The following query will give the Modifier Name and other details of Particular Item of Price List:-————————————————————————————————- SELECT DISTINCT qpa.list_header_id “Modifier Header ID”,qlh.COMMENTS “Modifier Name (Description)”, qpa.list_line_id “Modifier Line […]
To run or execute the Oracle API from the back-end, we need to Initialize the Apps first.We have API to Initialize the Apps.To initialize apps using the API, we need to pass few IN parameter values.The following is the script prepared to initialize apps based on theApplication, User-name and Responsibility name given.Example:-DECLARE l_appl_id NUMBER; l_appl_name […]
Following query can be used to get the Credit Card Number (of different format) from specific column.Column would have credit card Number in the text date. Date is not in any fixed format. And Credit Card Number would also not in any specific Format. In the following query, we have considered few credit card formats. […]
Recent Comments