APPS.PQH_GEN_FORM dependencies on PQH_TXN_CATEGORY_ATTRIBUTES

Line 188: , pqh_txn_category_attributes c

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
192: and c.transaction_category_id = p_transaction_category_id

Line 865: pqh_txn_category_attributes tca,

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
869: where sat.txn_category_attribute_id = tca.txn_category_attribute_id

Line 891: , pqh_txn_category_attributes c

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'
895: and s.attribute_type_cd = 'DISPLAY'

Line 954: pqh_txn_category_attributes tca,

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
958: and tca.select_flag = 'Y'

Line 1027: pqh_txn_category_attributes tc,

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
1031: and st.attribute_type_cd in ('SEGMENT','DISPLAY')

Line 1179: pqh_txn_category_attributes tca,

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
1183: and att.master_table_route_id = v_table_route_id

Line 1195: pqh_txn_category_attributes tca,

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
1199: and tca.select_flag = 'Y'

Line 1221: pqh_txn_category_attributes tca,

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

Line 2052: , pqh_txn_category_attributes c

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
2056: and tr.table_route_id <> cat.master_table_route_id

Line 2588: ,pqh_txn_category_attributes c

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
2592: and a.enable_flag = 'Y'