APPS.EAM_ASSETATTR_VALUE_PUB dependencies on MTL_SYSTEM_ITEMS

Line 78: from mtl_system_items

74: begin
75:
76: if p_creation_organization_id is not null then -- added if and the org id clause query for bug13789036
77: select eam_item_type into l_eam_item_type
78: from mtl_system_items
79: where inventory_item_id=p_inventory_item_id
80: and organization_id= p_creation_organization_id
81: and rownum=1;
82: else

Line 84: from mtl_system_items

80: and organization_id= p_creation_organization_id
81: and rownum=1;
82: else
83: select eam_item_type into l_eam_item_type
84: from mtl_system_items
85: where inventory_item_id=p_inventory_item_id
86: and rownum=1;
87: end if;
88:

Line 115: FROM mtl_system_items MSI , csi_item_instances CII

111: IF (p_maintenance_object_type = 3) THEN
112: IF ( p_serial_number IS NOT NULL ) THEN
113:
114: SELECT count(*) INTO l_count_rec
115: FROM mtl_system_items MSI , csi_item_instances CII
116: WHERE cii.serial_number = p_serial_number
117: AND cii.instance_id = p_maintenance_object_id
118: AND CII.inventory_item_id = MSI.inventory_item_id
119: AND MSI.inventory_item_id = p_asset_group_id;

Line 127: FROM mtl_system_items

123: IF ((p_serial_number IS NULL) AND
124: (p_maintenance_object_id = p_asset_group_id)) THEN
125:
126: SELECT count(*) INTO l_count_rec
127: FROM mtl_system_items
128: WHERE inventory_item_id = p_asset_group_id;
129: END IF;
130:
131: END IF;

Line 180: from mtl_system_items

176: where instance_id=p_object_id;
177: elsif p_eam_item_type = 2
178: then
179: select count(*) into l_count
180: from mtl_system_items
181: where inventory_item_id=p_object_id
182: and organization_id=p_organization_id;
183: end if;
184:

Line 569: from mtl_system_items msi, csi_item_instances cii

565:
566: ELSE
567: begin
568: select msi.eam_item_type into l_item_type
569: from mtl_system_items msi, csi_item_instances cii
570: where cii.inventory_item_id = msi.inventory_item_id
571: and cii.last_vld_organization_id = msi.organization_id
572: and cii.instance_id = p_maintenance_object_id;
573:

Line 1104: from mtl_system_items msi, csi_item_instances cii

1100:
1101: ELSE
1102: begin
1103: select msi.eam_item_type into l_item_type
1104: from mtl_system_items msi, csi_item_instances cii
1105: where cii.inventory_item_id = msi.inventory_item_id
1106: and cii.last_vld_organization_id = msi.organization_id
1107: and cii.instance_id = p_maintenance_object_id;
1108: