APPS.PON_AUCTION_INTERFACE_PKG dependencies on ICX_CAT_AGREEMENT_ATTRS_V

Line 1372: FROM icx_cat_agreement_attrs_v

1368: IP_DESCRIPTOR_ID -- IP_DESCRIPTOR_ID
1369: FROM
1370: (SELECT attribute_name descriptor_name, decode(type, 1, 'NUM', 'TXT') datatype,
1371: rt_category_id ip_category_id, attribute_id ip_descriptor_id
1372: FROM icx_cat_agreement_attrs_v
1373: WHERE ((rt_category_id = 0 and v_ip_attr_default_option in ('ALL', 'BASE')) or
1374: (rt_category_id = v_ip_category_id and v_ip_attr_default_option in ('ALL', 'CATEGORY'))) and language = userenv('LANG')
1375: ORDER BY nvl(sequence, v_max_seq_number) asc);
1376: