APPS.EAM_ASSETNUMBER_PUB dependencies on MTL_SYSTEM_ITEMS

Line 125: from mtl_system_items where inventory_item_id = p_inventory_item_id

121: -- Check the item type (Asset Group or Rebuildable)
122: begin
123: select eam_item_type,serial_number_control_code
124: into l_eam_item_type, l_serial_number_control_code
125: from mtl_system_items where inventory_item_id = p_inventory_item_id
126: and organization_id = p_CURRENT_ORGANIZATION_ID;
127: exception
128: when no_data_found then
129: add_error('EAM_GEN_INVALID_ITEM_TYPE');

Line 545: from mtl_system_items where inventory_item_id = p_inventory_item_id

541:
542: -- Check the item type (Asset Group or Rebuildable)
543: begin
544: select eam_item_type into l_eam_item_type
545: from mtl_system_items where inventory_item_id = p_inventory_item_id
546: and organization_id = p_CURRENT_ORGANIZATION_ID;
547: exception
548: when no_data_found then
549: add_error('EAM_GEN_INVALID_ITEM_TYPE');

Line 868: from mtl_system_items

864:
865: begin
866: select eam_item_type
867: into l_eam_item_type
868: from mtl_system_items
869: where inventory_item_id = p_INVENTORY_ITEM_ID
870: and organization_id = p_CURRENT_ORGANIZATION_ID;
871:
872: BEGIN

Line 1161: FROM MTL_SYSTEM_ITEMS_B

1157: end if;
1158:
1159: -- Check that the equipment item belongs to the prod org
1160: SELECT count(*) INTO l_count
1161: FROM MTL_SYSTEM_ITEMS_B
1162: WHERE inventory_item_id = l_prod_inventory_item_id
1163: AND organization_id = l_prod_organization_id;
1164: if (l_count = 0) then
1165: x_reason_failed:='EAM_INVALID_EQP_ITEM';

Line 1173: FROM MTL_SYSTEM_ITEMS_B

1169: end if;
1170:
1171: -- Check that the equipment type of the eqp item is 1
1172: SELECT equipment_type INTO l_prod_equipment_type
1173: FROM MTL_SYSTEM_ITEMS_B
1174: WHERE inventory_item_id = l_prod_inventory_item_id
1175: AND organization_id = l_prod_organization_id;
1176:
1177: if (l_prod_equipment_type is null) then