ITPub博客

列出所有Scheduled Concurrent Program select r.request_id, p.user_concurrent_program_name || case when p.user_concurrent_program_name = \'Report Set\' then (select \' - \' || s.user_request_set_name from apps.fnd_request_sets_tl s where s.application_id = r.argument1 and s.request_set_id = r.argument2 and language = \'US\' ) when p.user_concurrent_program_name =

订单的关闭是自动的，在所有行工作流结束（Close或者Cancel）后0.5天，订单头也将在Workflow Background Process的推动下关闭。 还有另外一种说法：you can wait until month-end and the “Order Flow – Generic” workflow will close it for you. 所以造成了很多时候订单行已经关闭了，但订单头还是处于Booked状态，这个时候如果你想Close订单头，你可以手动运行Workflow Background Process来关闭订单，也可以

1.List E-Business Suite Profile Option Values For All Levelsset long 10000 set pagesize 500 set linesize 160 column SHORT_NAME format a30 column NAME format a40 column LEVEL_SET format a15 column CONTEXT format a30 column VALUE format a40 select p.profile_option_name SHORT_NAME, n.user_profile_option_name NAME, decode(v.level_id, 10001, \'Site\', 10002, \'Application\', 10003, \'Responsibility\', 10004, \'User\', 10005, \'Server\', 10006, \'Org\', 10007, decode(to_char(v.level_value2), \'-1\',

rem ----------------------------------------------------------------------- rem Filename: appinfo.sql rem Purpose: Script to display status of all the Concurrent Managers rem Author: Anonymous rem ----------------------------------------------------------------------- set head on column OsId format A10 justify left column CpId format 999999 column Opid format 999 column Manager format A30 column Status format A20 column Started_At format A30 column Cpid

AD_APPLIED_PATCHES contains the list of patches that were directly applied.AD_BUGS contains the list of all the patches that were directly applied or were contained in the patches that were directly applied.For example, if you are trying to find out if a certain pre-requisite patch has been applied, query AD_BUGS. If you are trying to find out patches applied in a date range, query AD_APPLIED_PATCHES.SELECT * FROM ad_bugs WHERE bug_number = \'patch_number\'; SELECT * FROM ad_ap

declare x_po_head_id number ; begin select po_header_id into x_po_head_id from po_headers_all where segment1 = \'&ponumber\' and org_id = &org_id; update po_headers_all set authorization_status = \'APPROVED\', approved_flag = \'Y\', approved_date = sysdate, last_update_date= sysdate where po_header_id = x_po_head_id; update po_line_locations_all set approved_flag = \'Y\' where po_header_id = x_po_head_id ; commit; end;

EBS PO Approve Scriptdeclare x_po_head_id number ; begin select po_header_id into x_po_head_id from po_headers_all where segment1 = \'&ponumber\' and org_id = &org_id; update po_headers_all set authorization_status = \'APPROVED\', approved_flag = \'Y\', approved_date = sysdate, last_update_date= sysdate where po_header_id = x_po_head_id; update po_line_locations_all set approved_flag = \'Y\' where po_header_id = x_po_head_id ; commit; end; NOTE:You can only use this script at