APPS.EAM_OPERATIONS_JSP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 2339: and moq.inventory_item_id = (select inventory_item_id from mtl_system_items_kfv

2335: where moq.organization_id=msinv.organization_id
2336: and nvl(msinv.disable_date, sysdate+2) > sysdate
2337: and moq.subinventory_code = msinv.secondary_inventory_name
2338: and msinv.organization_id = p_organization_id
2339: and moq.inventory_item_id = (select inventory_item_id from mtl_system_items_kfv
2340: where organization_id = p_organization_id
2341: and concatenated_segments =p_concatenated_segments)
2342: group by msinv.secondary_inventory_name, moq.inventory_item_id, msinv.organization_id, msinv.description, msinv.locator_type
2343: order by msinv.secondary_inventory_name;

Line 2610: from mtl_system_items_kfv

2606:
2607: -- Get Inventory Item Id
2608: select inventory_item_id
2609: into l_inventory_item_id
2610: from mtl_system_items_kfv
2611: where concatenated_segments = p_concatenated_segments
2612: and organization_id = p_organization_id;
2613:
2614: begin

Line 2618: from wip_requirement_operations wro, mtl_system_items_kfv msikfv

2614: begin
2615:
2616: select 1, wro.operation_seq_num,wro.department_id,msikfv.description
2617: into l_material_exists, l_existing_operation, l_existing_department, l_existing_description
2618: from wip_requirement_operations wro, mtl_system_items_kfv msikfv
2619: where wro.inventory_item_id = l_inventory_item_id
2620: and wro.organization_id = p_organization_id
2621: and wro.wip_entity_id = p_wip_entity_id
2622: and wro.organization_id = msikfv.organization_id

Line 3078: from mtl_system_items_kfv

3074:
3075: -- Get Inventory Item Id
3076: select inventory_item_id
3077: into l_inventory_item_id
3078: from mtl_system_items_kfv
3079: where concatenated_segments = p_concatenated_segments
3080: and organization_id = p_organization_id;
3081:
3082: begin

Line 3086: from wip_requirement_operations wro, mtl_system_items_kfv msikfv

3082: begin
3083:
3084: select 1, wro.operation_seq_num,wro.department_id,msikfv.description
3085: into l_material_exists, l_existing_operation, l_existing_department, l_existing_description
3086: from wip_requirement_operations wro, mtl_system_items_kfv msikfv
3087: where wro.inventory_item_id = l_inventory_item_id
3088: and wro.organization_id = p_organization_id
3089: and wro.wip_entity_id = p_wip_entity_id
3090: and wro.organization_id = msikfv.organization_id