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.PQH_GENERIC_PURGE dependencies on PQH_SPECIAL_ATTRIBUTES

Line 60: , pqh_special_attributes sat

56: CURSOR csr_col_name(p_table_route_id IN NUMBER,
57: p_col_type_cd IN VARCHAR2) IS
58: SELECT upper(att.column_name) column_name
59: FROM pqh_attributes att
60: , pqh_special_attributes sat
61: , pqh_txn_category_attributes tca
62: WHERE att.attribute_id = tca.attribute_id
63: AND att.master_table_route_id = p_table_route_id
64: AND tca.transaction_category_id = g_purge_txn_catg_id

Line 643: , pqh_special_attributes sat

639: CURSOR
640: csr_err_col_name(p_table_route_id IN pqh_table_route.table_route_id%TYPE) IS
641: SELECT upper(att.column_name) column_name
642: FROM pqh_attributes att
643: , pqh_special_attributes sat
644: , pqh_txn_category_attributes tca
645: WHERE att.attribute_id = tca.attribute_id
646: and att.master_table_route_id = p_table_route_id
647: and tca.transaction_category_id = g_purge_txn_catg_id