APPS.PO_DATATEMPLATE_PKG dependencies on ICX_CAT_AGREEMENT_ATTRS_V

Line 109: from icx_cat_agreement_attrs_v ICA where

105: FUNCTION GET_LINE_ATTRIBUTE_VAL_XML(p_categoryId NUMBER, p_lineId NUMBER)
106: RETURN XMLType IS
107: CURSOR C_ATTR_KEY IS
108: SELECT ICA.ATTRIBUTE_ID, ICA.RT_CATEGORY_ID, REPLACE(ICA.KEY, ' ', '_') KEY, ICA.STORED_IN_TABLE, ICA.STORED_IN_COLUMN
109: from icx_cat_agreement_attrs_v ICA where
110: (ICA.rt_category_id = p_categoryId
111: or (ICA.rt_category_id =0 and ICA.attribute_id> 1000)
112: or ICA.key in ('LONG_DESCRIPTION','SUPPLIER_URL', 'MANUFACTURER', 'MANUFACTURER_URL', 'MANUFACTURER_PART_NUM',
113: 'ATTACHMENT_URL', 'UNSPSC', 'PICTURE', 'THUMBNAIL_IMAGE', 'LEAD_TIME', 'AVAILABILITY', 'COMMENTS', 'ALIAS'

Line 143: from icx_cat_agreement_attrs_v ICA where

139: FUNCTION GET_LINE_ATTR_VAL_DRAFT_XML(p_categoryId NUMBER, p_lineId NUMBER, p_draftId NUMBER)
140: RETURN XMLType IS
141: CURSOR C_ATTR_KEY IS
142: SELECT ICA.ATTRIBUTE_ID, ICA.RT_CATEGORY_ID, REPLACE(ICA.KEY, ' ', '_') KEY, ICA.STORED_IN_TABLE, ICA.STORED_IN_COLUMN
143: from icx_cat_agreement_attrs_v ICA where
144: (ICA.rt_category_id = p_categoryId
145: or (ICA.rt_category_id =0 and ICA.attribute_id> 1000)
146: or ICA.key in ('LONG_DESCRIPTION','SUPPLIER_URL', 'MANUFACTURER', 'MANUFACTURER_URL', 'MANUFACTURER_PART_NUM',
147: 'ATTACHMENT_URL', 'UNSPSC', 'PICTURE', 'THUMBNAIL_IMAGE', 'LEAD_TIME', 'AVAILABILITY', 'COMMENTS', 'ALIAS'