[Home] [Help]
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
192: and c.transaction_category_id = p_transaction_category_id
193: and s.attribute_type_cd = p_attribute_type_cd
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
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
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
958: and tca.select_flag = 'Y'
959: and att.enable_flag = 'Y'
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
1031: and st.attribute_type_cd in ('SEGMENT','DISPLAY')
1032: and st.context = pqh_gen_form.g_gbl_context
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
1183: and att.master_table_route_id = v_table_route_id
1184: and tca.select_flag = 'Y'
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
1199: and tca.select_flag = 'Y'
1200: and att.enable_flag = 'Y'
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
1225: and tca.attribute_id = att.attribute_id
1226: and tca.select_flag = 'Y'
2047: --
2048: cursor c_tab is
2049: select distinct tr.table_route_id, tr.display_name
2050: from pqh_table_route tr
2051: , pqh_attributes_vl a
2052: , pqh_txn_category_attributes c
2053: , pqh_transaction_categories cat
2054: where a.master_table_route_id = tr.table_route_id
2055: and a.attribute_id = c.attribute_id
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
2592: and a.enable_flag = 'Y'
2593: and c.select_flag = 'Y'