APPS.AS_FOUNDATION_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 579: From mtl_system_items_kfv

575: Primary_Unit_of_Measure,
576: inventory_item_status_code,
577: product_family_item_id,
578: bom_item_type
579: From mtl_system_items_kfv
580: Where inventory_item_id = p_inventory_item_id
581: And (description like NVL(p_description, '%')
582: Or description is NULL)
583: And (concatenated_segments like NVL(p_concatenated_segments, '%')

Line 610: From mtl_system_items_kfv

606: Primary_Unit_of_Measure,
607: inventory_item_status_code,
608: product_family_item_id,
609: bom_item_type
610: From mtl_system_items_kfv
611: Where (description like p_description)
612: And (concatenated_segments like NVL(p_concatenated_segments, '%')
613: Or concatenated_segments is NULL)
614: And organization_id = p_organization_id

Line 634: From mtl_system_items_kfv

630: Primary_Unit_of_Measure,
631: inventory_item_status_code,
632: product_family_item_id,
633: bom_item_type
634: From mtl_system_items_kfv
635: Where (description is NULL)
636: And (concatenated_segments like NVL(p_concatenated_segments, '%')
637: Or concatenated_segments is NULL)
638: And organization_id = p_organization_id

Line 899: From mtl_system_items_kfv

895:
896: Cursor Get_One_Item(p_inventory_item_id Number,
897: p_organization_id Number) IS
898: Select Concatenated_Segments
899: From mtl_system_items_kfv
900: Where inventory_item_id = p_inventory_item_id And
901: organization_id = p_organization_id;
902:
903: l_Concatenated_Segments VARCHAR2(50);