oracle erp

SELECT resp.responsibility_name, pr.user_concurrent_program_name,        rg.request_group_name, ex.executable_name, ex.application_name   FROM fnd_executables_form_v ex,        fnd_concurrent_programs_vl pr,        fnd_request_group_units rgu,        fnd_request_groups rg,        fnd_responsibility_vl resp  WHERE 1 = 1    AND pr.executable_id = ex.executable_id    AND rgu.request_group_id = rg.request_group_id    AND rgu.request_unit_id = pr.concurrent_program_id    AND resp.request_group_id = rg.request_group_id    AND pr.user_concurrent_program_name LIKE '%WSH_R_0005%'

select 'RCV' code       ,ri.interface_transaction_id       ,receipt_num       ,null       ,(select segment1 from mtl_system_items_b        where INVENTORY_ITEM_ID = ri.ITEM_ID          and ORGANIZATION_ID =84) item_no       ,destination_type_code||'-'||inspection_status_code       ,primary_quantity       ,transaction_date       ,null       ,null       ,error_message from  rcv_transactions_interface ri,       rcv_shipment_headers rsh,       po_interface_errors pie where ri.shipment_header_id = rsh.shipment_header_id   and pie.batch_id = ri.group_id   and ri.transaction_status_code='ERROR'

select *  from alr_alerts a, alr_actions_v b where a.alert_id = b.alert_id     and subject ='<Alert Name>';

frmcmp_batch <file_nname.fmb> apps/<passord> output_file=$ONT_TOP/forms/<file_name.fmx> 1) Login to application server. 2) Go to the directory $AU_TOP/forms/US 3) ftp “.fmb” file in binary mode 4) Execute the below command to generate “.fmx”. frmcmp_batch userid=apps/<apps_paswd> module=<Form_Name>.fmb output_file=<Form_Name>.fmx module_type=form batch=no compile_all=special EXAMPLE: frmcmp_batch userid=apps/apps module= RCVRCERC.fmb output_file=$AU_TOP/forms/US/ RCVRCERC.fmx  module_type=form batch=no compile_all=special

-- 建立在 FORM 中 --1. PACKAGE FILE_INFO IS   procedure import_file(v_block varchar2                       , v_field varchar2                       , v_col_separate varchar2                       , v_row_separate varchar2);   function  open_file return number; END; --2 PACKAGE BODY FILE_INFO IS    /*  用 途 : 已 Web方 式 開 啟 檔 案  參 數 : 無     傳 回 值 : >1(選 擇 檔 案 且 Upgrade)           0(選 擇 檔 案 但 未 Upgrade)          -1(未 選 擇 檔 案 )     */   function  open_file return number is     access_id ...