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.CZ_PB_MGR dependencies on ALL_TAB_COLUMNS

Line 871: FROM all_tab_columns

867:
868: CURSOR col_name_cur(par_table_name VARCHAR2)
869: IS
870: SELECT column_name
871: FROM all_tab_columns
872: WHERE table_name = UPPER(LTRIM(RTRIM(par_table_name))) AND owner = 'CZ';
873:
874: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE
875: INDEX BY BINARY_INTEGER;

Line 874: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE

870: SELECT column_name
871: FROM all_tab_columns
872: WHERE table_name = UPPER(LTRIM(RTRIM(par_table_name))) AND owner = 'CZ';
873:
874: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE
875: INDEX BY BINARY_INTEGER;
876:
877: col_list col_name_table;
878: i BINARY_INTEGER := 1;

Line 1051: FROM all_tab_columns

1047:
1048: CURSOR col_name_cur(par_table_name VARCHAR2)
1049: IS
1050: SELECT column_name
1051: FROM all_tab_columns
1052: WHERE table_name = UPPER(LTRIM(RTRIM(par_table_name))) AND owner = 'CZ';
1053:
1054: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE
1055: INDEX BY BINARY_INTEGER;

Line 1054: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE

1050: SELECT column_name
1051: FROM all_tab_columns
1052: WHERE table_name = UPPER(LTRIM(RTRIM(par_table_name))) AND owner = 'CZ';
1053:
1054: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE
1055: INDEX BY BINARY_INTEGER;
1056:
1057: col_list col_name_table;
1058: i BINARY_INTEGER := 1;

Line 1555: FROM all_tab_columns

1551:
1552: CURSOR col_name_cur(par_table_name VARCHAR2)
1553: IS
1554: SELECT column_name
1555: FROM all_tab_columns
1556: WHERE table_name = UPPER(LTRIM(RTRIM(par_table_name))) AND owner = 'CZ';
1557:
1558: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE
1559: INDEX BY BINARY_INTEGER;

Line 1558: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE

1554: SELECT column_name
1555: FROM all_tab_columns
1556: WHERE table_name = UPPER(LTRIM(RTRIM(par_table_name))) AND owner = 'CZ';
1557:
1558: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE
1559: INDEX BY BINARY_INTEGER;
1560:
1561: col_list col_name_table;
1562: i BINARY_INTEGER := 1;

Line 1676: FROM all_tab_columns

1672:
1673: CURSOR col_name_cur(par_table_name VARCHAR2)
1674: IS
1675: SELECT column_name
1676: FROM all_tab_columns
1677: WHERE table_name = UPPER(LTRIM(RTRIM(par_table_name))) AND owner = 'CZ';
1678:
1679: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE
1680: INDEX BY BINARY_INTEGER;

Line 1679: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE

1675: SELECT column_name
1676: FROM all_tab_columns
1677: WHERE table_name = UPPER(LTRIM(RTRIM(par_table_name))) AND owner = 'CZ';
1678:
1679: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE
1680: INDEX BY BINARY_INTEGER;
1681:
1682: col_list col_name_table;
1683: i BINARY_INTEGER := 1;

Line 1796: FROM all_tab_columns

1792:
1793: CURSOR col_name_cur(par_table_name VARCHAR2)
1794: IS
1795: SELECT column_name
1796: FROM all_tab_columns
1797: WHERE table_name = UPPER(LTRIM(RTRIM(par_table_name))) AND owner = 'CZ';
1798:
1799: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE
1800: INDEX BY BINARY_INTEGER;

Line 1799: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE

1795: SELECT column_name
1796: FROM all_tab_columns
1797: WHERE table_name = UPPER(LTRIM(RTRIM(par_table_name))) AND owner = 'CZ';
1798:
1799: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE
1800: INDEX BY BINARY_INTEGER;
1801:
1802: col_list col_name_table;
1803: i BINARY_INTEGER := 1;

Line 1915: FROM all_tab_columns

1911:
1912: CURSOR col_name_cur(par_table_name VARCHAR2)
1913: IS
1914: SELECT column_name
1915: FROM all_tab_columns
1916: WHERE table_name = UPPER(LTRIM(RTRIM(par_table_name))) AND owner = 'CZ';
1917:
1918: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE
1919: INDEX BY BINARY_INTEGER;

Line 1918: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE

1914: SELECT column_name
1915: FROM all_tab_columns
1916: WHERE table_name = UPPER(LTRIM(RTRIM(par_table_name))) AND owner = 'CZ';
1917:
1918: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE
1919: INDEX BY BINARY_INTEGER;
1920:
1921: col_list col_name_table;
1922: i BINARY_INTEGER := 1;

Line 2031: FROM all_tab_columns

2027:
2028: CURSOR col_name_cur(par_table_name VARCHAR2)
2029: IS
2030: SELECT column_name
2031: FROM all_tab_columns
2032: WHERE table_name = UPPER(LTRIM(RTRIM(par_table_name))) AND owner = 'CZ';
2033:
2034: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE
2035: INDEX BY BINARY_INTEGER;

Line 2034: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE

2030: SELECT column_name
2031: FROM all_tab_columns
2032: WHERE table_name = UPPER(LTRIM(RTRIM(par_table_name))) AND owner = 'CZ';
2033:
2034: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE
2035: INDEX BY BINARY_INTEGER;
2036:
2037: col_list col_name_table;
2038: i BINARY_INTEGER := 1;

Line 2147: FROM all_tab_columns

2143:
2144: CURSOR col_name_cur(par_table_name VARCHAR2)
2145: IS
2146: SELECT column_name
2147: FROM all_tab_columns
2148: WHERE table_name = UPPER(LTRIM(RTRIM(par_table_name))) AND owner = 'CZ';
2149:
2150: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE
2151: INDEX BY BINARY_INTEGER;

Line 2150: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE

2146: SELECT column_name
2147: FROM all_tab_columns
2148: WHERE table_name = UPPER(LTRIM(RTRIM(par_table_name))) AND owner = 'CZ';
2149:
2150: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE
2151: INDEX BY BINARY_INTEGER;
2152:
2153: col_list col_name_table;
2154: i BINARY_INTEGER := 1;

Line 2265: FROM all_tab_columns

2261:
2262: CURSOR col_name_cur(par_table_name VARCHAR2)
2263: IS
2264: SELECT column_name
2265: FROM all_tab_columns
2266: WHERE table_name = UPPER(LTRIM(RTRIM(par_table_name))) AND owner = 'CZ';
2267:
2268: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE
2269: INDEX BY BINARY_INTEGER;

Line 2268: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE

2264: SELECT column_name
2265: FROM all_tab_columns
2266: WHERE table_name = UPPER(LTRIM(RTRIM(par_table_name))) AND owner = 'CZ';
2267:
2268: TYPE col_name_table IS TABLE OF all_tab_columns.column_name%TYPE
2269: INDEX BY BINARY_INTEGER;
2270:
2271: col_list col_name_table;
2272: i BINARY_INTEGER := 1;