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_GEN_FORM dependencies on PQH_GENERIC

Line 179: , pqh_generic.get_alias(a.column_name) alias

175: cursor c_sat (p_attribute_type_cd varchar2
176: ,p_transaction_category_id number) is
177: select upper(a.column_name ) column_name
178: , a.column_type
179: , pqh_generic.get_alias(a.column_name) alias
180: , decode(column_type,'D', 'fnd_date.date_to_canonical('|| substr(a.column_name,1,instr(a.column_name||' ', ' ',1)-1) ||')'||' '||pqh_generic.get_alias(column_name)
181: , column_name ) col_dt_name
182: , a.width
183: , upper(s.ddf_column_name ) ddf_column_name

Line 180: , decode(column_type,'D', 'fnd_date.date_to_canonical('|| substr(a.column_name,1,instr(a.column_name||' ', ' ',1)-1) ||')'||' '||pqh_generic.get_alias(column_name)

176: ,p_transaction_category_id number) is
177: select upper(a.column_name ) column_name
178: , a.column_type
179: , pqh_generic.get_alias(a.column_name) alias
180: , decode(column_type,'D', 'fnd_date.date_to_canonical('|| substr(a.column_name,1,instr(a.column_name||' ', ' ',1)-1) ||')'||' '||pqh_generic.get_alias(column_name)
181: , column_name ) col_dt_name
182: , a.width
183: , upper(s.ddf_column_name ) ddf_column_name
184: , upper(s.ddf_value_column_name ) ddf_value_column_name

Line 859: select upper(pqh_generic.get_alias(att.column_name)) column_alias,

855: and result_type_cd = 'SOURCE'
856: for update of copy_entity_result_id;
857: --
858: cursor c_attrib(v_table_route_id in number) is
859: select upper(pqh_generic.get_alias(att.column_name)) column_alias,
860: upper(sat.ddf_column_name) ddf_column_name,
861: upper(sat1.ddf_column_name) changeable_column_name,
862: sat.context context, -- application_id
863: sat1.context context_s1 -- application_id

Line 1176: substr(pqh_generic.get_alias(column_name)

1172: l_ac_seg FND_FLEX_EXT.SegmentArray ;
1173:
1174: cursor c_sat(v_table_route_id number) is
1175: select sat.ddf_column_name ddf_column_name,
1176: substr(pqh_generic.get_alias(column_name)
1177: ,instr(upper(pqh_generic.get_alias(column_name)),'SEGMENT')+7) seg_no
1178: from pqh_special_attributes sat,
1179: pqh_txn_category_attributes tca,
1180: pqh_attributes att

Line 1177: ,instr(upper(pqh_generic.get_alias(column_name)),'SEGMENT')+7) seg_no

1173:
1174: cursor c_sat(v_table_route_id number) is
1175: select sat.ddf_column_name ddf_column_name,
1176: substr(pqh_generic.get_alias(column_name)
1177: ,instr(upper(pqh_generic.get_alias(column_name)),'SEGMENT')+7) seg_no
1178: from pqh_special_attributes sat,
1179: pqh_txn_category_attributes tca,
1180: pqh_attributes att
1181: where sat.txn_category_attribute_id = tca.txn_category_attribute_id

Line 1189: order by to_number(substr(pqh_generic.get_alias(column_name)

1185: and att.enable_flag = 'Y'
1186: and sat.attribute_type_cd = 'SEGMENT'
1187: and sat.flex_code = p_flex
1188: and sat.context = pqh_gen_form.g_gbl_context
1189: order by to_number(substr(pqh_generic.get_alias(column_name)
1190: ,instr(upper(pqh_generic.get_alias(column_name)),'SEGMENT')+7)) ;
1191:
1192: cursor c_flex is
1193: select ddf_column_name

Line 1190: ,instr(upper(pqh_generic.get_alias(column_name)),'SEGMENT')+7)) ;

1186: and sat.attribute_type_cd = 'SEGMENT'
1187: and sat.flex_code = p_flex
1188: and sat.context = pqh_gen_form.g_gbl_context
1189: order by to_number(substr(pqh_generic.get_alias(column_name)
1190: ,instr(upper(pqh_generic.get_alias(column_name)),'SEGMENT')+7)) ;
1191:
1192: cursor c_flex is
1193: select ddf_column_name
1194: from pqh_special_attributes sat,