APPS.CSI_T_TXN_ATTRIBS_PVT dependencies on CSI_I_EXTENDED_ATTRIBS

Line 1081: 'from csi_i_extended_attribs '||

1077: ' active_end_date, context, attribute1, attribute2, attribute3,'||
1078: ' attribute4, attribute5, attribute6, attribute7, attribute8,'||
1079: ' attribute9, attribute10, attribute11, attribute12, attribute13,'||
1080: ' attribute14, attribute15, object_version_number '||
1081: 'from csi_i_extended_attribs '||
1082: 'where attribute_level = ''GLOBAL'' '||
1083: 'union '||
1084: 'select attribute_id, attribute_level, master_organization_id,'||
1085: ' inventory_item_id, item_category_id, instance_id, attribute_code,'||

Line 1091: 'from csi_i_extended_attribs '||

1087: ' active_end_date, context, attribute1, attribute2, attribute3,'||
1088: ' attribute4, attribute5, attribute6, attribute7, attribute8,'||
1089: ' attribute9, attribute10, attribute11, attribute12, attribute13,'||
1090: ' attribute14, attribute15, object_version_number '||
1091: 'from csi_i_extended_attribs '||
1092: 'where (inventory_item_id, master_organization_id) in '||
1093: ' (select inventory_item_id,inv_organization_id '||
1094: ' from csi_t_txn_line_details'||
1095: ' where txn_line_detail_id = :line_dtl_id '||

Line 1107: 'from csi_i_extended_attribs '||

1103: ' active_end_date, context, attribute1, attribute2, attribute3,'||
1104: ' attribute4, attribute5, attribute6, attribute7, attribute8,'||
1105: ' attribute9, attribute10, attribute11, attribute12, attribute13,'||
1106: ' attribute14, attribute15, object_version_number '||
1107: 'from csi_i_extended_attribs '||
1108: 'where instance_id = :instance_id';
1109:
1110: IF p_instance_id is not null THEN
1111: l_select_stmt := l_select_stmt||l_inst_based_stmt;

Line 1485: FROM csi_i_extended_attribs a

1481:
1482: CURSOR get_global_attrib_cur (c_attribute_code IN VARCHAR2)
1483: IS
1484: SELECT attribute_id
1485: FROM csi_i_extended_attribs a
1486: WHERE attribute_level = 'GLOBAL'
1487: AND attribute_code = c_attribute_code
1488: AND (a.active_end_date is NULL OR
1489: trunc(a.active_end_date) > l_sysdate) ;

Line 1494: FROM csi_i_extended_attribs a ,

1490:
1491: CURSOR get_item_attrib_cur (c_attribute_code IN VARCHAR2)
1492: IS
1493: SELECT a.attribute_id, b.inventory_item_id, b.inv_organization_id
1494: FROM csi_i_extended_attribs a ,
1495: csi_t_txn_line_details b,
1496: mtl_parameters mtp -- Added for bug 4118180
1497: WHERE a.attribute_level = 'ITEM'
1498: AND a.attribute_code = c_attribute_code

Line 1511: FROM csi_i_extended_attribs a,

1507: IS
1508: --FOR non-CZ
1509: SELECT a.attribute_id, b.inventory_item_id, b.inv_organization_id
1510: , a.instance_id
1511: FROM csi_i_extended_attribs a,
1512: csi_t_txn_line_details b
1513: WHERE a.attribute_level = 'INSTANCE'
1514: AND a.attribute_code = c_attribute_code
1515: AND b.config_inst_hdr_id IS NULL

Line 1524: FROM csi_i_extended_attribs a,

1520: UNION
1521: ---FOR CZ
1522: SELECT a.attribute_id, b.inventory_item_id, b.inv_organization_id
1523: , c.instance_id
1524: FROM csi_i_extended_attribs a,
1525: csi_t_txn_line_details b,
1526: csi_item_instances c
1527: WHERE a.attribute_level = 'INSTANCE'
1528: AND a.attribute_code = c_attribute_code

Line 1544: csi_i_extended_attribs csie ,

1540: ctld.inventory_item_id, ctld.inv_organization_id
1541: FROM mtl_item_categories mti,
1542: mtl_categories_b mtc ,
1543: --csi_install_parameters csii,
1544: csi_i_extended_attribs csie ,
1545: csi_t_txn_line_details ctld
1546: WHERE mti.organization_id = ctld.inv_organization_id -- Bug 4306650. Typo:inv_orgn and item_id swap
1547: AND mti.inventory_item_id = ctld.inventory_item_id -- Bug 4306650. Typo:inv_orgn and item_id swap
1548: AND mti.category_set_id = c_category_set_id -- csii.category_set_id

Line 1689: x_source_table := 'CSI_I_EXTENDED_ATTRIBS' ;

1685:
1686: l_loop_count := 0 ;
1687: IF l_instance_id IS NULL
1688: THEN
1689: x_source_table := 'CSI_I_EXTENDED_ATTRIBS' ;
1690: ELSE
1691: FOR iea_values_rec IN iea_values_cur(l_instance_id , x_attribute_id)
1692: LOOP
1693: l_attribute_value_id := iea_values_rec.attribute_value_id ;

Line 1708: x_source_table := 'CSI_I_EXTENDED_ATTRIBS' ;

1704: THEN
1705: x_source_table := 'CSI_IEA_VALUES' ;
1706: x_attribute_id := l_attribute_value_id ;
1707: ELSE
1708: x_source_table := 'CSI_I_EXTENDED_ATTRIBS' ;
1709: END IF ; --l_attribute_value_id
1710: END IF ; --l_instance_id
1711: ELSE
1712: l_attrib_param := 'Item ID:'||l_inv_item_id||' Orgn ID:'||l_inv_orgn_id||'Category ID: '||l_item_category||'Instance ID: '||l_instance_id;