DBA Data[Home] [Help]

APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on ICX_CAT_AGREEMENT_ATTRS_V

Line 1613: FROM icx_cat_agreement_attrs_v

1609: ip_descriptor_id -- IP_DESCRIPTOR_ID
1610: FROM
1611: (SELECT attribute_name, decode(type, 1, 'NUM', 'TXT') datatype,
1612: rt_category_id ip_category_id, attribute_id ip_descriptor_id
1613: FROM icx_cat_agreement_attrs_v
1614: WHERE ((rt_category_id = 0 and p_ip_attr_default_option in ('ALL', 'BASE')) or
1615: (rt_category_id = line.ip_category_id and p_ip_attr_default_option in ('ALL', 'CATEGORY'))) and language = userenv('LANG') and
1616: upper(attribute_name) not in (select upper(attribute_name)
1617: from pon_auc_attributes_interface

Line 1743: FROM icx_cat_agreement_attrs_v

1739: ip_descriptor_id -- IP_DESCRIPTOR_ID
1740: FROM
1741: (SELECT attribute_name, decode(type, 1, 'NUM', 'TXT') datatype,
1742: rt_category_id ip_category_id, attribute_id ip_descriptor_id
1743: FROM icx_cat_agreement_attrs_v
1744: WHERE rt_category_id = line.ip_category_id and
1745: language = userenv('LANG') and
1746: upper(attribute_name) not in (select upper(attribute_name)
1747: from pon_auc_attributes_interface