APPS.PQH_GENERIC dependencies on PQH_ATTRIBUTES

Line 121: from pqh_attributes att

117: cursor c_attribs(v_copy_entity_txn_id number,v_table_route_id number,v_attribute_type varchar2) is
118: select upper(att.column_name) column_name
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

Line 146: from pqh_attributes att

142: , upper(att.column_type) column_type
143: , upper(sat1.ddf_column_name) ddf_column_name
144: , sat1.context context
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

Line 185: ,pqh_attributes a

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'
189: and c.select_flag = 'Y'

Line 791: from pqh_attributes pa

787: , 'N' ,'L_'||get_alias(pa.column_name)||' NUMBER' ||decode(pa.width,'0','','('||pa.width||')')
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