DBA Data[Home] [Help]

APPS.ENGPKIMP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 607: FROM mtl_system_items_kfv

603: WHERE revised_item_sequence_id = p_change_line_id;
604: -- Get the item details
605: SELECT item_catalog_group_id, lifecycle_id, current_phase_id , concatenated_segments
606: INTO l_item_catalog_cat_id, l_item_lifecycle_id, l_item_current_phase_id, l_concatenated_segments
607: FROM mtl_system_items_kfv
608: WHERE inventory_item_id = l_inventory_item_id
609: AND organization_id = l_org_id;
610:
611: -- Check whether there are any change policies for the current phase of item at any level which are not allowed

Line 2694: FROM mtl_system_items_kfv

2690:
2691: CURSOR mfgitem_already_exists(p_tomfg_item IN VARCHAR2)
2692: IS
2693: SELECT 1
2694: FROM mtl_system_items_kfv
2695: WHERE concatenated_segments = p_tomfg_item;
2696:
2697: CURSOR Get_starting_revision (p_org_id IN NUMBER)
2698: IS