Sreekanth Reddy Pothula's Oracle ERP Blog

SELECT ROWNUM , pax.supervisor_id , pax.person_id , ppx.employee_number , mgx.employee_number supervisor_staff_number , REPLACE (ppx.full_name, '''', ' ') full_name , REPLACE (mgx.full_name, '''', ' ') supervisor_full_name , pj.NAME job_name , pj.attribute5 cbs_role FROM per_assignments_x pax , per_people_x ppx , per_people_x mgx , per_jobs pj WHERE ppx.person_id = pax.person_id AND ppx.current_employee_flag = 'Y' AND mgx.person_id = pax.supervisor_id AND pj.job_id = pax.job_id START WITH ppx.employee_number = '<emp_num>' CONNECT BY NOCYCLE PRIOR mgx.employee_number = ppx.employee_number

Link Between IBY_CREDITCARD and AP_CARDS_ALL      select * from apps.iby_creditcard ibc, apps.ap_cards_all aca where  ibc.instrid = aca.card_id 

The reason the users are getting these is because a configuration on the Workflow Mailer called "Send e-mails for canceled notifications" is enabled. The way that feature works is if a Notification is sent to a user at 11:00 AM today for example to approve a Purchase Order, but that notification is closed or cancelled (maybe they responded via their worklist for example or someone else processed it via Forward Documents form, etc.) then this notification that is confusing them is sent, that the previous email can be ignored.   To disable this feature please do the following : 1) Login to Oracle Application Manager (OAM) via System Administrator > Oracle Application Manager > Workflow   2) Edit the Workflow Notification Mailer service by clicking on the Edit button. 3) Navigate to the Message Generation stage and will see this parameter called :  "Send e-mails for canceled notifications" 4) Uncheck the "Send e-mails for canceled notifications...

The  best method  is to use dbms_metadata package: SELECT  dbms_metadata.get_ddl( UPPER ( '&OBJ_TYPE' ), UPPER ( '&OBJ_NAME' ), UPPER ( '&OWNER' )) FROM  dual; Additional methods  could be also used: Source text of the package SELECT  text FROM  dba_source WHERE   UPPER (name)  LIKE   UPPER ( '&which_object' ) ORDER   BY  line ; Use $ORACLE_HOME/bin/wrap utility to encrypt the package (there is no unwrap) (Well, actually,  there is unwrap  – just look in the search machine for the words unwrap10 or rewrap…) Source text of the views SET   LONG   5000 col text  FOR  a80 SELECT  text  FROM  dba_views  WHERE  view_name =  UPPER ( '&which_view' ); SELECT  query  FROM  DBA_mviews  WHERE  mview_name =  UPPER ( '&which_view' ); SELECT  view_definition  FROM  v$fixed_view...

SELECT   fi . app_short_name ,           fi . subdir   filename ,           version ,           version_segment4   FROM     apps . ad_files   fi ,           apps . ad_file_versions   ve   WHERE    Upper ( filename )   LIKE   Upper ( 'DataMappingHelper.class%' )           AND   ve . file_id   =   fi . file_id           AND   file_version_id   =   ( SELECT   Max   ( file_version_id )                                  FROM     apps . ad_file_versions   ven    ...

SELECT   variable_name ,           value   FROM     apps . fnd_env_context   WHERE    variable_name   LIKE   '%PO_TOP'   ESCAPE   '\'           AND   concurrent_process_id   =   ( SELECT   Max ( concurrent_process_id )                                        FROM     apps . fnd_env_context )   ORDER    BY  1 ;  

SELECT   do . owner ,           do . object_name ,           do . object_type ,           dl . session_id ,           vs . serial# ,           vs . program ,           vs . machine ,           vs . osuser   FROM     dba_locks   dl ,           dba_objects   do ,           v$session   vs   WHERE    do . object_name   LIKE   'WF%'           AND   do . object_type   =   'TABLE'           AND   dl . lock_id1   =   do . object_id     ...