DBA Data[Home] [Help]

APPS.ENGPKIMP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 679: FROM mtl_system_items_kfv

675: WHERE revised_item_sequence_id = p_change_line_id;
676: -- Get the item details
677: SELECT item_catalog_group_id, lifecycle_id, current_phase_id , concatenated_segments
678: INTO l_item_catalog_cat_id, l_item_lifecycle_id, l_item_current_phase_id, l_concatenated_segments
679: FROM mtl_system_items_kfv
680: WHERE inventory_item_id = l_inventory_item_id
681: AND organization_id = l_org_id;
682:
683: -- Check whether there are any change policies for the current phase of item at any level which are not allowed

Line 2825: FROM mtl_system_items_kfv

2821:
2822: CURSOR mfgitem_already_exists(p_tomfg_item IN VARCHAR2)
2823: IS
2824: SELECT 1
2825: FROM mtl_system_items_kfv
2826: WHERE concatenated_segments = p_tomfg_item;
2827:
2828: CURSOR Get_starting_revision (p_org_id IN NUMBER)
2829: IS