Oracle EBS – Order Management Interview Questions
Oracle EBS – Order Management Interview QuestionsOracle Apps – Order Management Interview Questions 1. What are the Base Tables and...
All Posts
Oracle Reports Frequently Asked Questions (FAQ)/ Oracle Reports Interview Questions
Oracle Reports Frequently Asked Questions (FAQ)/ Oracle Reports Interview QuestionsOracle Reports Frequently Asked QuestionsOracle Reports Interview Q...
Query to get concurrent program and executable details
SELECT fcpt.user_concurrent_program_name,
fcp.concurrent_program_name,
fat.application_name,
fet.executable_name,
fate.application_name exe_application,
flv.meaning ...Query to get responsibility level profile option values
--Add new subqueries for your profile options
SELECT resp_list.resp_name,
g.responsibility_name,
h.application_name,
g.responsibility_key,
i.request_group_name,
...Query to validate migration of XML/BI Publisher Template and Data Definition
SELECT xt_list.*, xdo_db.*
FROM (SELECT XDDV.data_source_code "Data Definition Code",
XDDV.data_source_name "Data Definition",
XDDV.description "Data Definit...Query to get details of XML/BI Publisher Template and Data Definition
SELECT XDDV.data_source_code "Data Definition Code",
XDDV.data_source_name "Data Definition",
XDDV.description "Data Definition Description",
XTB.template_code "T...Query to get Site level and Organization level Profile Option Value
--Site level profile option value
SELECT USER_PROFILE_OPTION_NAME, fpov.profile_option_value
FROM fnd_profile_option_values fpov, fnd_profile_options_vl fpo
WHERE fpov.profile_option_id(+...Query to get attribute values of Inventory Item Template
SELECT template_name,
USER_ATTRIBUTE_NAME,
CONTROL_LEVEL_DSP,
ATTRIBUTE_VALUE,
ENABLED_FLAG
FROM MTL_ITEM_TEMPL_ATTRIBUTES_V mita, MTL_ITEM_TEMPLATES_ALL_V mit
...Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assets
-- Period status for Inventory
SELECT DISTINCT opu.name AS operating_unit,
per.organization_id AS inv_org_id,
par.organization_code AS inv_org_code,
...Oracle apps EBS sql to get Fixed Asset (FA) details with Net Book Value (NBV) and Depreciation
SELECT DISTINCT
fab.asset_id,
fab.asset_number,
FAT.DESCRIPTION,
fab.current_units,
SUM (fdh.units_assigned) units_assigned_count,
...Query to find Sales Orders that are shipped but not invoiced
SELECT b.order_number,
a.line_number,
a.ordered_item,
a.line_type_id,
a.ordered_quantity,
a.shipped_quantity,
a.freight_terms_code,
b.order_type_id
F...Query to get details of WIP discrete jobs
SELECT wdj.wip_entity_id cum_entity_id,
wdj.organization_id cum_org_id,
ml_elem_type.meaning elem_var_type,
SUM (
ROUND (
DECODE (
...