Package to get Description /Name of the GL Code Combination Segments

SELECT GCC.CONCATENATED_SEGMENTS ACCOUNT,
       GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION (GCC.CHART_OF_ACCOUNTS_ID,
                                                 GCC.CODE_COMBINATION_ID)
          DESCRIPTION
  FROM GL_CODE_COMBINATIONS_KFV GCC

Oracle Live EBS Vision Instance

1. Biztech.com
2. Infosemantics.com
3. Solutionit.com

Oracle Row Level Security

Since version 8i, Oracle Database has a functionality to restrict data from a table based on some configuration. Beauty of this functionality is that it is 

seamlessly applied i.e., user has not to worry in reading the security definition and applying it in all of the queries. It is applied automatically by database engine.

/*

    Test Case :

  

    Environment : R12T (Vision Instance)

  

    Scenario checked by using the purchasing responsibility

        

    Parameters

    user    : OPERATIONS

    Resp.   : PURCHASING_OPERATIONS

  

*/

-- Total Records

SELECT COUNT(0) FROM PO_HEADERS_ALL

--23992 row found

-- Before script exection available records to apps user

SELECT COUNT(0) FROM PO_HEADERS

-- 0 rows found

            

-- To get the user and responsability info 

SELECT US.USER_ID, US.USER_NAME, RM.RESPONSIBILITY_ID, RM.RESPONSIBILITY_KEY, RM.RESPONSIBILITY_NAME, RESPONSIBILITY_APPLICATION_ID, APS.APPLICATION_SHORT_NAME

FROM FND_USER_RESP_GROUPS_DIRECT RS    ,FND_USER US    ,fnd_responsibility_vl RM, FND_APPLICATION APS

WHERE RS.USER_ID = US.USER_ID

AND   RS.RESPONSIBILITY_ID  = RM.RESPONSIBILITY_ID

AND   RS.RESPONSIBILITY_APPLICATION_ID  =   APS.APPLICATION_ID

AND US.USER_NAME = 'OPERATIONS'

AND RM.RESPONSIBILITY_KEY = 'PURCHASING_OPERATIONS'

--AND RM.RESPONSIBILITY_NAME = 'Purchasing'

--AND APS.APPLICATION_SHORT_NAME = 'PO'

AND RM.START_DATE <= TRUNC(SYSDATE)  

AND (RM.END_DATE IS NULL OR RM.END_DATE >= TRUNC(SYSDATE))

AND US.START_DATE <= TRUNC(SYSDATE)  AND (US.END_DATE IS NULL OR US.END_DATE >= TRUNC(SYSDATE))

;

-- Initialize global values

BEGIN FND_GLOBAL.APPS_INITIALIZE(1318, 50578, 201); END; 

-- Initialize and set allowed organization into global temp table mo_glob_org_access_tmp

BEGIN MO_GLOBAL.INIT('PO'); END;

-- After script exection available records for the apps user

SELECT COUNT(0) FROM PO_HEADERS            

-- show count of allowed data access set depending upon security profile

--** EXCEPTION 

-- Wrong Res. id , User id, Apps id

BEGIN FND_GLOBAL.APPS_INITIALIZE(3333331013595, 33333350578, 333333201); END ;

----------------------------

-- In case of any exception call to reset org_id

BEGIN MO_GLOBAL.INIT('PO'); END;

BEGIN MO_GLOBAL.INIT('S',NULL); END;

-------------------------------------------

SELECT COUNT(0) FROM PO_HEADERS

--EXEC MO_GLOBAL.SET_POLICY_CONTEXT('M',202);

--EXEC FND_GLOBAL.INITIALIZE

-- select count(0) from mo_glob_org_access_tmp 

TOAD SQL Editor

Predefined Shortcuts

Keyboard shortcuts are one of the features that make TOAD so powerful and easy to use. TOAD comes with a host of predefined shortcuts. These shortcuts save keystrokes and mouse actions and perform a variety of tasks such as issuing a describe on the current highlighted object, or find (find next, find previous, and so on). The shortcuts differ slightly between the SQL Editor and the PL/SQL Editor (covered in Chapter 4). This section focuses on the shortcuts for the SQL Editor only.

Table 3.1 shows all the shortcuts in keystroke order and Table 3.2 shows all the shortcuts in description order. The third column refers you to the figure in this chapter where the shortcut is illustrated.

Table 3.1 SQL Editor Shortcuts by Keystroke

Shortcut	Description	Illustration
F1	Windows Help File
F2	Toggle Output Window	Figure 3.2
Shift+F2	Toggle Data Grid Window
F3	Find Next Occurrence
Shift+F3	Find Previous Occurrence
F4	Describe Table, View, Procedure, Function	Figure 3.26
F5	Execute SQL as a script	Figure 3.34
F6	Toggle between SQL Editor and Results Panel	Figure 3.1
F7	Clear All Text
F8	Recall Previous SQL Statement
F9	Execute Statement	Figure 3.33
Ctrl+F9	Set Code Execution Parameters	Figure 3.33
Shift+F9	Execute Current SQL statement at Cursor
F10 or right-click	Pop-up Menu	Figures 3.4, 3.10
Ctrl+F12	External Editor, Pass Contents	Figures 3.5, 3.6
Ctrl+A	Select All Text
Ctrl+C	Copy
Ctrl+E	Execute Explain Plan on the Current Statement	Figure 3.41
Ctrl+F	Find Text
Ctrl+G	Goto Line
Ctrl+L	Convert Text to Lowercase
Ctrl+M	Make Code Statement
Ctrl+N	Recall Named SQL Statement
Ctrl+O	Open a Text File
Ctrl+P	Strip Code Statement
Ctrl+R	Find and Replace
Ctrl+S	Save File
Shift+Ctrl+S	Save File As	Figure 3.18
Ctrl+T	Columns Drop-down
Shift+Ctrl+R	Alias Replacement
Shift+Ctrl+T	Columns Drop-Down no alias	Figure 3.19
Ctrl+Spacebar	Code Templates	Figure 3.30
Ctrl+U	Converts Text to Uppercase
Ctrl+V	Paste
Ctrl+X	Cut
Ctrl+Z	Undo Last Change
Ctrl+.	Display Pop-up List of Matching Table Names	Figure 3.16
Shift+Ctrl+Z	Redo Last Undo
Alt+Up Arrow	Display Previous Statement	Figure 3.7
Alt+Down Arrow	Display Next Statement (After Alt+Up Arrow)	Figure 3.7
Ctrl+Home	In the data grid: goes to the top of the record set
Ctrl+End	In the data grid: goes to the end of the record set
Ctrl+Tab	Cycles through the Collection of MDI Child Windows

TIP

The competent TOAD user makes use of Shift+F9 to execute SQL statements one at a time out of a script, and F8 to recall the previous SQL statement. The TOAD user also makes use of cut and paste to move code between TOAD windows.

Shift+F9 executes single SQL statements.

F8 recalls the previous SQL statement.

Table 3.2 SQL Editor Shortcuts by Description

Description	Shortcut	Illustration
Alias Replacement	Shift+Ctrl+R
Clear All Text	F7
Code Templates	Ctrl+Spacebar	Figure 3.30
Columns Drop-down	Ctrl+T	Figure 3.18
Columns Drop-down no alias	Shift+Ctrl+T	Figure 3.19
Convert Text to Lowercase	Ctrl+L
Convert Text to Uppercase	Ctrl+U
Copy	Ctrl+C
Cut	Ctrl+X
Cycles through the Collection of MDI Child Windows	Ctrl+Tab
Describe Table, View, Procedure, Function, or Package	F4
Display Next Statement (After Alt+Up Arrow)	Alt+Down Arrow	Figure 3.7
Display Previous Statement	Alt+Up Arrow	Figure 3.7
Display Pop-up List of Matching Table Names	Ctrl+.	Figure 3.16
Execute Current SQL Statement at Cursor	Shift+F9
Execute SQL as a Script	F5	Figure 3.35
Execute Explain Plan on the Current SQL Statement	Ctrl+E	Figure 3.41
Execute SQL Statement	F9	Figure 3.34
External Editor, Pass Contents	Ctrl+F12	Figure 3.5
Find and Replace	Ctrl+R
Find Next Occurrence	F3
Find Previous Occurrence	Shift+F3
Find Text	Ctrl+F
Goto Line	Ctrl+G
In the data grid: goes to the end of the record set	Ctrl+End
In the data grid: goes to the top of the record set	Ctrl+Home
Make Code Statement	Ctrl+M
Open a Text File	Ctrl+O
Paste	Ctrl+V
Pop-up Menu	F10 or RT-Mouse	Figures 3.4, 3.10
Recall Named SQL	Ctrl+N
Recall Previous SQL Statement	F8
Redo Last Undo	Shift+Ctrl+Z
Save File	Ctrl+S
Save File As	Shift+Ctrl+S
Select All Text	Ctrl+A
Strip Code Statement	Ctrl+P
Toggle between SQL Editor and Results Panel	F6	Figure 3.1
Toggle Full Screen Editor	F2	Figure 3.2
Undo Last Change	Ctrl+Z
Verify Statement Without Execution (Parse)	Ctrl+F9
Windows Help File	F1

Reference : http://www.informit.com/articles/article.aspx?p=31544&seqNum=2