SELECT 'Receipt' matching,
pv.vendor_name,
pv.segment1 vendor#,
pvs.vendor_site_cod...SELECT owner, table_name, TRUNC (SUM (bytes) / 1024 / 1024) MB
FROM (SELECT segment_name table_name, owner, bytes
FROM dba_segments
WHERE segment_type IN ('TABLE', 'TABLE PA...SELECT DISTINCT
ffv.form_name,
user_form_name,
fcr.function_name,
fff.user_function_name,
fcr.description per_description,
trigger_event,
...--
SELECT /*Supplier Information*/
aps.segment1 oracle_supplier_number,
aps.vendor_id,
aps.vendor_name suppli...SELECT COUNT (DISTINCT ai2.invoice_num), ai1.invoice_num
FROM ap.ap_invoices_all ai1,
ap.ap_invoice_distributions_all aid1,
ap.ap_invoices_all ai2
WHERE ...SELECT COUNT (DISTINCT d.segment1), a.invoice_num
FROM ap.ap_invoices_all A,
ap.ap_invoice_distributions_all b,
po.po_distributions_all C,
po.po_headers...SELECT fa.application_name,
fpov.level_id,
fa.application_short_name,
fpo.USER_PROFILE_OPTION_NAME,
fpo.PROFILE_OPTION_NAME,
DECODE (fpov.level_id,
...SELECT fcpl.user_concurrent_program_name,
fcp.concurrent_program_name,
par.end_user_column_name,
par.form_left_prompt prompt,
par.enabled_flag,
par.required_flag,
...SET SERVEROUTPUT ON;
DECLARE
CURSOR c_main
IS
SELECT DISTINCT a.menu_id, fm.MENU_NAME
FROM fnd_responsibility_vl a, fnd_menus fm
WHERE responsibility_name LIKE 'Your Re...SELECT ffvs.flex_value_set_id,
ffvs.flex_value_set_name,
ffvs.description set_description,
ffvs.validation_type,
ffv.flex_value_id,
ffv.flex_value,
ffvt.flex_...SELECT DISTINCT fcpl.user_concurrent_program_name,
fcp.concurrent_program_name,
fapp.application_name,
frg.request_group_name,
fnrtl.res...SELECT segment1,
bos.OPERATION_SEQ_NUM,
RESOURCE_SEQ_NUM,
effectivity_date
FROM apps.bom_operation_sequences bos,
bom_operational_routings bor,
mtl_system_item...