+ Write Article

Oracle Articles Examples, Tutorials and Articles

Published by
Query To Display Items which are not assigned to VAT Template

Code sql:
SELECT ood.organization_name
         ,msi.*
   FROM mtl_system_items_b msi
       ,org_organization_definitions ood
   WHERE 1=1
   AND msi.organization_id=ood.organization_id
   AND
...
Read More Read More
Published by
Introduction

Get information about concurrent programs without the need to query through forms.

The code

Code sql:
SELECT fcr.request_id, 
         fcpt.user_concurrent_program_name,
         fcr.phase_code,
         fcr.status_code,
...
Read More Read More
Published by
Introduction

Script to User and ADD responsibility from backend


The code

Code sql:
DECLARE
  v_user_name  VARCHAR2(30):=UPPER('&Enter_User_Name');
  v_password   VARCHAR2(30):='&Enter_Password';
  v_session_id INTEGER     := USERENV('sessionid');
...
Read More Read More 1 Comment
Published by
Query To Display Quarter for given date.....

Code sql:
SELECT sysdate
      ,(CASE WHEN to_char(given_date,'MON') IN ('JUN','JUL','AUG') THEN 'Q1' 
             WHEN to_char(given_date,'MON') IN ('SEP','OCT','NOV') THEN 'Q2' 
             WHEN to_char(given_date,'MON') IN ('DEC','JAN','FEB')
...
Read More Read More 1 Comment
Published by
Navigation
-----------

Fixed Assets Manager Resp-->Setup-->Asset System-->Asset categories

Code sql:
--Asset Category Listing
SELECT fct.segment1||'.'||fct.segment2||'.'||fct.segment3||'.'||fct.segment4||'.'||fct.segment5 category
      ,fct.enabled_flag
...
Read More Read More
Published by
Navigation
----------

Receivables Resp--> Oracle receivables-->Setup-->Receipts-->Receipt Classes

Code sql:
--Receipt Class and Bank Accounts attached to them
SELECT arc.name
      ,al.meaning creation_method
      ,nvl(al1.meaning,'No Remittance')
...
Read More Read More
Published by
Navigation
------------
Receivables Resp--> Oracle Receivables-->setup-->Receipts--> Receipt Sources
--Receipt Sources
------------------------------------------

Code sql:
SELECT hou.name operating_unit	
      ,absa.name	
      ,absa.description
...
Read More Read More
Published by
Navigation
-----------

Receivables Resp--> Oracle Receivables-->Setup-->Receipts-->Receivable Activities

--Receivable Activities
---------------------------------
Code sql:
SELECT hou.name operating_unit
      ,arta.name
      ,arta.description
...
Read More Read More
Published by
The following is a Query to display Transaction Types in Receivables R12

Code sql:
--Transaction Types in Receivables R12
SELECT hou.name operating_unit
      ,xep.name legal_entity
      ,rctt.name      
      ,rctt.description
      ,al.meaning class
...
Read More Read More
Published by
The following is a Query to display Responsibility wise profile Options and it's Values

Code sql:
SELECT fu.user_name
      ,fr.responsibility_name
      ,fpo.user_profile_option_name
      ,NVL(xxtest_sql(fpo.sql_validation,fpov.profile_option_value,
          fpo.profile_option_name),fpov.profile_option_value)
...
Read More Read More

Page 1 of 10 1 2 3 4 5 6 7