eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AW_GEN dependencies on DUAL

Line 1048: FROM dual;

1044: FUNCTION get_org_id RETURN NUMBER AS
1045: l_org_id NUMBER(15);
1046: CURSOR get_orgid IS
1047: SELECT NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),NULL)
1048: FROM dual;
1049: BEGIN
1050: -- Commented out NOCOPY by jbegum as part of Enh bug #2222272
1051: -- This code has been commented out NOCOPY to remove multi org functionality from OSS
1052: /* OPEN get_orgid;

Line 1812: FROM DUAL;

1808:
1809: --Cursor that will convert the String into a Number
1810: CURSOR cur_check_number IS
1811: SELECT TO_NUMBER(LTRIM(RTRIM(str)))
1812: FROM DUAL;
1813:
1814: BEGIN
1815:
1816: ret:=0;

Line 1940: SELECT 1 key_data, 'R' val_data from dual union all

1936: CURSOR c_rev_mapping (cp_mapped_value NUMBER)
1937: IS
1938: SELECT val_data FROM
1939: (
1940: SELECT 1 key_data, 'R' val_data from dual union all
1941: SELECT 2 key_data, 'D' val_data from dual union all
1942: SELECT 3 key_data, 'S' val_data from dual union all
1943: SELECT 4 key_data, 'F' val_data from dual
1944: ) MAPPING

Line 1941: SELECT 2 key_data, 'D' val_data from dual union all

1937: IS
1938: SELECT val_data FROM
1939: (
1940: SELECT 1 key_data, 'R' val_data from dual union all
1941: SELECT 2 key_data, 'D' val_data from dual union all
1942: SELECT 3 key_data, 'S' val_data from dual union all
1943: SELECT 4 key_data, 'F' val_data from dual
1944: ) MAPPING
1945: WHERE key_data = cp_mapped_value;

Line 1942: SELECT 3 key_data, 'S' val_data from dual union all

1938: SELECT val_data FROM
1939: (
1940: SELECT 1 key_data, 'R' val_data from dual union all
1941: SELECT 2 key_data, 'D' val_data from dual union all
1942: SELECT 3 key_data, 'S' val_data from dual union all
1943: SELECT 4 key_data, 'F' val_data from dual
1944: ) MAPPING
1945: WHERE key_data = cp_mapped_value;
1946: BEGIN

Line 1943: SELECT 4 key_data, 'F' val_data from dual

1939: (
1940: SELECT 1 key_data, 'R' val_data from dual union all
1941: SELECT 2 key_data, 'D' val_data from dual union all
1942: SELECT 3 key_data, 'S' val_data from dual union all
1943: SELECT 4 key_data, 'F' val_data from dual
1944: ) MAPPING
1945: WHERE key_data = cp_mapped_value;
1946: BEGIN
1947: OPEN c_process_status (