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

Line 1072: TYPE t_tbl_data_type IS TABLE OF ALL_TAB_COLUMNS.column_name%TYPE;

1068: , p_column_name_tbl IN PO_TBL_VARCHAR30 DEFAULT NULL
1069: )
1070: IS
1071:
1072: TYPE t_tbl_data_type IS TABLE OF ALL_TAB_COLUMNS.column_name%TYPE;
1073: TYPE t_tbl_varchar IS TABLE OF VARCHAR2(4000);
1074: TYPE t_ref_csr IS REF CURSOR;
1075:
1076: l_column_name_tbl po_tbl_varchar30;

Line 1107: -- Use all_tab_columns to get column names.

1103: -- Ideas for refactoring:
1104: -- Get the current schema via SYS_CONTEXT('USERENV','CURRENT_SCHEMA').
1105: -- Use all_synonyms to find the base table / view.
1106: -- (maybe just use user_synonyms, if login is always APPS, regardless of current_schema)
1107: -- Use all_tab_columns to get column names.
1108: --
1109:
1110: IF d_stmt THEN
1111:

Line 1132: ALL_TAB_COLUMNS

1128: BULK COLLECT INTO
1129: l_column_name_tbl
1130: , l_data_type_tbl
1131: FROM
1132: ALL_TAB_COLUMNS
1133: WHERE table_name = l_table_name
1134: AND owner = l_table_owner
1135: ORDER BY column_id
1136: ;