APPS.PQH_GENERIC dependencies on PQH_TXN_CATEGORY_ATTRIBUTES

Line 123: , pqh_txn_category_attributes tca

119: , upper(att.column_type) column_type
120: , upper(sat.ddf_column_name) ddf_column_name
121: from pqh_attributes att
122: , pqh_special_attributes sat
123: , pqh_txn_category_attributes tca
124: , pqh_copy_entity_txns cet
125: where att.attribute_id = tca.attribute_id
126: and att.master_table_route_id = v_table_route_id
127: and tca.txn_category_attribute_id = sat.txn_category_attribute_id

Line 149: , pqh_txn_category_attributes tca

145: , sat.context context_s
146: from pqh_attributes att
147: , pqh_special_attributes sat
148: , pqh_special_attributes sat1
149: , pqh_txn_category_attributes tca
150: , pqh_copy_entity_txns cet
151: where att.attribute_id = tca.attribute_id
152: and att.master_table_route_id = v_table_route_id
153: and tca.txn_category_attribute_id = sat.txn_category_attribute_id

Line 184: ,pqh_txn_category_attributes c

180: --
181: cursor c_dt is
182: select ddf_column_name
183: from pqh_special_attributes s
184: ,pqh_txn_category_attributes c
185: ,pqh_attributes a
186: where a.attribute_id = c.attribute_id
187: and c.txn_category_attribute_id = s.txn_category_attribute_id
188: and a.enable_flag = 'Y'

Line 792: , pqh_txn_category_attributes tca

788: , 'L' ,'L_'||get_alias(pa.column_name)||' LONG'
789: , 'B' ,'L_'||get_alias(pa.column_name)||' BOOLEAN'
790: , 'L_'||get_alias(pa.column_name)||' '||pa.column_type||'('||pa.width||')') var_def
791: from pqh_attributes pa
792: , pqh_txn_category_attributes tca
793: , pqh_copy_entity_txns cet
794: , pqh_special_attributes sat
795: where pa.master_table_route_id = p_table_route_id
796: and pa.attribute_id = tca.attribute_id