DBA Data[Home] [Help]

APPS.CSI_ML_UTIL_PVT dependencies on CSI_I_EXTENDED_ATTRIBS

Line 469: FROM csi_i_extended_attribs

465: CLOSE iea_intf_cur;
466:
467: UPDATE csi_iea_value_interface a
468: SET a.attribute_id=(SELECT attribute_id
469: FROM csi_i_extended_attribs
470: WHERE attribute_level = a.attribute_level
471: AND attribute_code = a.attribute_code)
472: WHERE a.attribute_level = 'GLOBAL'
473: AND a.inst_interface_id IN (SELECT inst_interface_id

Line 488: FROM csi_i_extended_attribs

484: AND a.attribute_code IS NOT NULL;
485:
486: UPDATE csi_iea_value_interface a
487: SET a.attribute_id = (SELECT attribute_id
488: FROM csi_i_extended_attribs
489: WHERE attribute_level = a.attribute_level
490: AND attribute_code = a.attribute_code
491: AND inventory_item_id = a.inventory_item_id
492: AND a.attribute_id IS NULL

Line 992: FROM csi_i_extended_attribs

988: CLOSE iea_intf_cur;
989:
990: UPDATE csi_iea_value_interface a
991: SET a.attribute_id=(SELECT attribute_id
992: FROM csi_i_extended_attribs
993: WHERE attribute_level = a.attribute_level
994: AND attribute_code = a.attribute_code)
995: WHERE a.attribute_level = 'GLOBAL'
996: AND a.inst_interface_id IN (SELECT inst_interface_Id

Line 1011: FROM csi_i_extended_attribs

1007: AND a.attribute_code IS NOT NULL;
1008:
1009: UPDATE csi_iea_value_interface a
1010: SET a.attribute_id=(SELECT attribute_id
1011: FROM csi_i_extended_attribs
1012: WHERE attribute_level = a.attribute_level
1013: AND attribute_code = a.attribute_code
1014: AND inventory_item_id = a.inventory_item_id
1015: AND master_organization_id = a.master_organization_id

Line 1378: FROM csi_i_extended_attribs

1374: AND ip_account3_id IS NULL;
1375:
1376: UPDATE csi_iea_value_interface a
1377: SET attribute_id =(SELECT attribute_id
1378: FROM csi_i_extended_attribs
1379: WHERE attribute_level = a.attribute_level
1380: AND attribute_code = a.attribute_code)
1381: WHERE a.inst_interface_id IN (SELECT inst_interface_id
1382: FROM csi_instance_interface cii

Line 1390: FROM csi_i_extended_attribs

1386: AND attribute_id IS NULL;
1387:
1388: UPDATE csi_iea_value_interface a
1389: SET attribute_id=(SELECT attribute_id
1390: FROM csi_i_extended_attribs
1391: WHERE attribute_level = a.attribute_level
1392: AND attribute_code = a.attribute_code
1393: AND inventory_item_id = a.inventory_item_id
1394: AND master_organization_id = a.master_organization_id