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 1098: TYPE t_tbl_data_type IS TABLE OF ALL_TAB_COLUMNS.column_name%TYPE;

1094: , p_column_name_tbl IN PO_TBL_VARCHAR30 DEFAULT NULL
1095: )
1096: IS
1097:
1098: TYPE t_tbl_data_type IS TABLE OF ALL_TAB_COLUMNS.column_name%TYPE;
1099: TYPE t_tbl_varchar IS TABLE OF VARCHAR2(4000);
1100: TYPE t_ref_csr IS REF CURSOR;
1101:
1102: l_column_name_tbl po_tbl_varchar30;

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

1133: -- Ideas for refactoring:
1134: -- Get the current schema via SYS_CONTEXT('USERENV','CURRENT_SCHEMA').
1135: -- Use all_synonyms to find the base table / view.
1136: -- (maybe just use user_synonyms, if login is always APPS, regardless of current_schema)
1137: -- Use all_tab_columns to get column names.
1138: --
1139:
1140: IF d_stmt THEN
1141:

Line 1172: ALL_TAB_COLUMNS tab,

1168: BULK COLLECT INTO
1169: l_column_name_tbl
1170: , l_data_type_tbl
1171: FROM
1172: ALL_TAB_COLUMNS tab,
1173: ALL_SYNONYMS syn
1174: WHERE tab.TABLE_NAME = syn.table_name
1175: AND tab.owner=syn.owner
1176: AND tab.owner = l_table_owner