DBA Data[Home] [Help]

APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on ICX_CAT_AGREEMENT_ATTRS_V

Line 1608: FROM icx_cat_agreement_attrs_v

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

Line 1738: FROM icx_cat_agreement_attrs_v

1734: ip_descriptor_id -- IP_DESCRIPTOR_ID
1735: FROM
1736: (SELECT attribute_name, decode(type, 1, 'NUM', 'TXT') datatype,
1737: rt_category_id ip_category_id, attribute_id ip_descriptor_id
1738: FROM icx_cat_agreement_attrs_v
1739: WHERE rt_category_id = line.ip_category_id and
1740: language = userenv('LANG') and
1741: upper(attribute_name) not in (select upper(attribute_name)
1742: from pon_auc_attributes_interface