INTRODUCTION: Maps are introduced in oracle apex to show the exact locations and information in a simple way. In this blog, we are displaying the latitude and longitude by pointing…
Read MoreIntroduction: This SQL query is used to fetching the data of FG Items where used details like Component Item, Component Item Description, Parent ,Parent Item Description, Item Seq, Effettivity…
Read MoreIntroduction: This SQL query is used to fetching the data of Bill of Materials Explosion details like Order Level, Root Assembly, Assembly Item, Assembly Item Description, Assembly Item Type,…
Read MoreIntro:-This script will provide all related Bom Routing department details. Code:- SELECT xep.legal_entity_id “Legal Entity ID”, xep.name “Legal Entity”, hr_outl.name “Organization Name”, hr_outl.organization_id “Organization ID”, …
Read MoreIntro:-This script will provide all related Form Personalization details. Code:- SELECT ffv.form_id “Form ID”, ffv.form_name “Form Name”, ffv.user_form_name “User Form Name”, ffv.description “Form Description”, …
Read More1-) Query to get the executable details for the concurrent program or package Introduction: This query is used to fetch the user concurrent program name, concurrent program name, executable id…
Read MoreIntroduction: This query is used to fetch the data of customer name and also the details like the account number, addresses, city, country, postal code and customer account id. In…
Read MoreIntroduction: This SQL query is used to fetching the data of Customer contact details like Customer Name, Contact Name, Email Address Contact Number and Dunning Letters etc… In this…
Read MoreIntroduction: This SQL query is used to fetching the data of Customer CIF information to identify whether we have any duplicate CIF numbers exists or not. Cause of…
Read More