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_SPECIAL_ATTRIBUTES

Line 187: from pqh_special_attributes s

183: , upper(s.ddf_column_name ) ddf_column_name
184: , upper(s.ddf_value_column_name ) ddf_value_column_name
185: , c.value_set_id
186: , s.context -- application_id a
187: from pqh_special_attributes s
188: , pqh_txn_category_attributes c
189: , pqh_attributes a
190: where s.txn_category_attribute_id = c.txn_category_attribute_id
191: and c.attribute_id = a.attribute_id

Line 570: l_txn_category_attribute_id pqh_special_attributes.txn_category_attribute_id%type;

566: , p_lf2 varchar2 default null
567: , p_ln2 varchar2 default null
568: , p_batch_status out nocopy varchar2 ) is
569: --
570: l_txn_category_attribute_id pqh_special_attributes.txn_category_attribute_id%type;
571: l_replacement_type_cd pqh_copy_entity_txns.replacement_type_cd%type ;
572: l_start_with pqh_copy_entity_txns.start_with%type;
573: l_increment_by pqh_copy_entity_txns.increment_by%type;
574: l_mast_trt_id pqh_transaction_categories.master_table_route_id%type;

Line 864: from pqh_special_attributes sat,

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
864: from pqh_special_attributes sat,
865: pqh_txn_category_attributes tca,
866: pqh_transaction_categories tct,
867: pqh_attributes att,
868: pqh_special_attributes sat1

Line 868: pqh_special_attributes sat1

864: from pqh_special_attributes sat,
865: pqh_txn_category_attributes tca,
866: pqh_transaction_categories tct,
867: pqh_attributes att,
868: pqh_special_attributes sat1
869: where sat.txn_category_attribute_id = tca.txn_category_attribute_id
870: and tca.attribute_id = att.attribute_id
871: and tct.master_table_route_id = v_table_route_id
872: and tct.transaction_category_id = tca.transaction_category_id

Line 881: (select txn_category_attribute_id from pqh_special_attributes

877: and att.enable_flag = 'Y'
878: and sat.attribute_type_cd in ('DISPLAY')
879: and sat1.attribute_type_cd = 'CHANGEABLE'
880: and sat.txn_category_attribute_id not in
881: (select txn_category_attribute_id from pqh_special_attributes
882: where context = pqh_gen_form.g_gbl_context
883: and attribute_type_cd = 'KEY_FLEX');
884: --
885: cursor c_id (p_transaction_category_id in number) is

Line 890: from pqh_special_attributes s

886: select upper(s.ddf_column_name ) ddf_column_name
887: , upper(s.ddf_value_column_name ) ddf_value_column_name
888: , c.value_set_id
889: , s.context context -- application_id
890: from pqh_special_attributes s
891: , pqh_txn_category_attributes c
892: where s.txn_category_attribute_id = c.txn_category_attribute_id
893: and c.transaction_category_id = p_transaction_category_id
894: and s.ddf_column_name <> 'INFORMATION1'

Line 953: from pqh_special_attributes sat,

949: --
950: cursor c_sat is
951: select sat.ddf_column_name ddf_column_name,
952: to_number(substr(column_name,instr(upper(column_name),'SEGMENT')+7,2)) nos
953: from pqh_special_attributes sat,
954: pqh_txn_category_attributes tca,
955: pqh_attributes att
956: where sat.txn_category_attribute_id = tca.txn_category_attribute_id
957: and tca.attribute_id = att.attribute_id

Line 1026: from pqh_special_attributes st,

1022: , tc.value_set_id
1023: , upper(st.ddf_value_column_name) ddf_value_column_name
1024: , st.attribute_type_cd, st.flex_code
1025: , pqh_gen_form.get_segment(ata.column_name) segment
1026: from pqh_special_attributes st,
1027: pqh_txn_category_attributes tc,
1028: pqh_attributes ata
1029: where st.txn_category_attribute_id = tc.txn_category_attribute_id
1030: and ata.attribute_id = tc.attribute_id

Line 1037: from pqh_special_attributes sat

1033: and tc.select_flag = 'Y'
1034: and ata.enable_flag = 'Y'
1035: and st.txn_category_attribute_id in
1036: (select sat.txn_category_attribute_id
1037: from pqh_special_attributes sat
1038: where sat.context = pqh_gen_form.g_gbl_context
1039: and sat.attribute_type_cd = 'CHANGEABLE'
1040: and sat.txn_category_attribute_id = p_txn_category_attribute_id ); -- special_attribute
1041: --

Line 1056: select ddf_column_name from pqh_special_attributes

1052: and display_flag = 'Y'
1053: order by segment_num);
1054: --
1055: cursor c_col (p_flex in varchar2) is
1056: select ddf_column_name from pqh_special_attributes
1057: where flex_code = p_flex
1058: and context = pqh_gen_form.g_gbl_context
1059: and attribute_type_cd = 'KEY_FLEX' ;
1060: begin

Line 1178: from pqh_special_attributes sat,

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
1182: and tca.attribute_id = att.attribute_id

Line 1194: from pqh_special_attributes sat,

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,
1195: pqh_txn_category_attributes tca,
1196: pqh_attributes att
1197: where sat.txn_category_attribute_id = tca.txn_category_attribute_id
1198: and tca.attribute_id = att.attribute_id

Line 1219: from pqh_special_attributes sat,

1215: order by segment_num;
1216:
1217: cursor c_change is
1218: select sat2.ddf_column_name ch_col, sat.ddf_column_name ac_col
1219: from pqh_special_attributes sat,
1220: pqh_special_attributes sat2,
1221: pqh_txn_category_attributes tca,
1222: pqh_attributes att
1223: where sat.txn_category_attribute_id = tca.txn_category_attribute_id

Line 1220: pqh_special_attributes sat2,

1216:
1217: cursor c_change is
1218: select sat2.ddf_column_name ch_col, sat.ddf_column_name ac_col
1219: from pqh_special_attributes sat,
1220: pqh_special_attributes sat2,
1221: pqh_txn_category_attributes tca,
1222: pqh_attributes att
1223: where sat.txn_category_attribute_id = tca.txn_category_attribute_id
1224: and sat.txn_category_attribute_id = sat2.txn_category_attribute_id

Line 2587: from Pqh_special_attributes s

2583: l_upd boolean := true;
2584: l_updt boolean := true;
2585: cursor c_dt (p_type in varchar2) is
2586: select ddf_column_name, ddf_value_column_name
2587: from Pqh_special_attributes s
2588: ,pqh_txn_category_attributes c
2589: ,pqh_attributes a
2590: where a.attribute_id = c.attribute_id
2591: and c.txn_category_attribute_id = s.txn_category_attribute_id