DBA Data[Home] [Help]

APPS.PQH_REFRESH_DATA dependencies on PQH_ATTRIBUTES_VL

Line 281: FROM pqh_attributes_vl att, pqh_txn_category_attributes tca,

277: p_mas_tab_id IN pqh_table_route.table_route_id%TYPE) IS
278: SELECT att.refresh_col_name, nvl(tca.refresh_flag,'N') ,
279: att.column_type,
280: nvl(at2.attribute_name, att.attribute_name) attribute_name
281: FROM pqh_attributes_vl att, pqh_txn_category_attributes tca,
282: pqh_attributes_vl at2
283: WHERE att.attribute_id = tca.attribute_id
284: AND att.column_name = at2.column_name(+)
285: AND att.master_table_route_id = at2.master_table_route_id(+)

Line 282: pqh_attributes_vl at2

278: SELECT att.refresh_col_name, nvl(tca.refresh_flag,'N') ,
279: att.column_type,
280: nvl(at2.attribute_name, att.attribute_name) attribute_name
281: FROM pqh_attributes_vl att, pqh_txn_category_attributes tca,
282: pqh_attributes_vl at2
283: WHERE att.attribute_id = tca.attribute_id
284: AND att.column_name = at2.column_name(+)
285: AND att.master_table_route_id = at2.master_table_route_id(+)
286: AND at2.legislation_code(+) = l_legislation_code