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.

[Home] [Help]

APPS.PQH_GENERIC_PURGE dependencies on PQH_TXN_CATEGORY_ATTRIBUTES

Line 61: , pqh_txn_category_attributes tca

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
65: AND tca.txn_category_attribute_id = sat.txn_category_attribute_id

Line 644: , pqh_txn_category_attributes tca

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
648: and tca.txn_category_attribute_id = sat.txn_category_attribute_id