APPS.EAM_ASSETNUMBER_PUB dependencies on MTL_SYSTEM_ITEMS

Line 123: from mtl_system_items where inventory_item_id = p_inventory_item_id

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

Line 525: from mtl_system_items where inventory_item_id = p_inventory_item_id

521:
522: -- Check the item type (Asset Group or Rebuildable)
523: begin
524: select eam_item_type into l_eam_item_type
525: from mtl_system_items where inventory_item_id = p_inventory_item_id
526: and organization_id = p_CURRENT_ORGANIZATION_ID;
527: exception
528: when no_data_found then
529: add_error('EAM_GEN_INVALID_ITEM_TYPE');

Line 836: from mtl_system_items

832:
833: begin
834: select eam_item_type
835: into l_eam_item_type
836: from mtl_system_items
837: where inventory_item_id = p_INVENTORY_ITEM_ID
838: and organization_id = p_CURRENT_ORGANIZATION_ID;
839:
840: BEGIN

Line 1129: FROM MTL_SYSTEM_ITEMS_B

1125: end if;
1126:
1127: -- Check that the equipment item belongs to the prod org
1128: SELECT count(*) INTO l_count
1129: FROM MTL_SYSTEM_ITEMS_B
1130: WHERE inventory_item_id = l_prod_inventory_item_id
1131: AND organization_id = l_prod_organization_id;
1132: if (l_count = 0) then
1133: x_reason_failed:='EAM_INVALID_EQP_ITEM';

Line 1141: FROM MTL_SYSTEM_ITEMS_B

1137: end if;
1138:
1139: -- Check that the equipment type of the eqp item is 1
1140: SELECT equipment_type INTO l_prod_equipment_type
1141: FROM MTL_SYSTEM_ITEMS_B
1142: WHERE inventory_item_id = l_prod_inventory_item_id
1143: AND organization_id = l_prod_organization_id;
1144:
1145: if (l_prod_equipment_type is null) then