APPS.EAM_ASSETATTR_VALUE_PUB dependencies on MTL_SYSTEM_ITEMS

Line 76: from mtl_system_items

72: is
73: l_eam_item_type number;
74: begin
75: select eam_item_type into l_eam_item_type
76: from mtl_system_items
77: where inventory_item_id=p_inventory_item_id
78: and rownum=1;
79:
80: return l_eam_item_type;

Line 106: FROM mtl_system_items MSI , csi_item_instances CII

102: IF (p_maintenance_object_type = 3) THEN
103: IF ( p_serial_number IS NOT NULL ) THEN
104:
105: SELECT count(*) INTO l_count_rec
106: FROM mtl_system_items MSI , csi_item_instances CII
107: WHERE cii.serial_number = p_serial_number
108: AND cii.instance_id = p_maintenance_object_id
109: AND CII.inventory_item_id = MSI.inventory_item_id
110: AND MSI.inventory_item_id = p_asset_group_id;

Line 118: FROM mtl_system_items

114: IF ((p_serial_number IS NULL) AND
115: (p_maintenance_object_id = p_asset_group_id)) THEN
116:
117: SELECT count(*) INTO l_count_rec
118: FROM mtl_system_items
119: WHERE inventory_item_id = p_asset_group_id;
120: END IF;
121:
122: END IF;

Line 171: from mtl_system_items

167: where instance_id=p_object_id;
168: elsif p_eam_item_type = 2
169: then
170: select count(*) into l_count
171: from mtl_system_items
172: where inventory_item_id=p_object_id
173: and organization_id=p_organization_id;
174: end if;
175:

Line 560: from mtl_system_items msi, csi_item_instances cii

556:
557: ELSE
558: begin
559: select msi.eam_item_type into l_item_type
560: from mtl_system_items msi, csi_item_instances cii
561: where cii.inventory_item_id = msi.inventory_item_id
562: and cii.last_vld_organization_id = msi.organization_id
563: and cii.instance_id = p_maintenance_object_id;
564:

Line 1095: from mtl_system_items msi, csi_item_instances cii

1091:
1092: ELSE
1093: begin
1094: select msi.eam_item_type into l_item_type
1095: from mtl_system_items msi, csi_item_instances cii
1096: where cii.inventory_item_id = msi.inventory_item_id
1097: and cii.last_vld_organization_id = msi.organization_id
1098: and cii.instance_id = p_maintenance_object_id;
1099: