DBA Data[Home] [Help]

APPS.OZF_FUNDS_PUB dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 2023: FROM mtl_system_items_b_kfv

2019: WHERE fund_id = p_prod_used_by;
2020:
2021: CURSOR c_inv_id_exists (p_inventory_id IN NUMBER, p_org_id IN NUMBER) IS
2022: SELECT 1
2023: FROM mtl_system_items_b_kfv
2024: WHERE organization_id = p_org_id
2025: AND inventory_item_id = p_inventory_id;
2026:
2027: CURSOR c_inv_name_exists (p_inventory_name IN VARCHAR2, p_org_id IN NUMBER) IS

Line 2029: FROM mtl_system_items_b_kfv

2025: AND inventory_item_id = p_inventory_id;
2026:
2027: CURSOR c_inv_name_exists (p_inventory_name IN VARCHAR2, p_org_id IN NUMBER) IS
2028: SELECT inventory_item_id
2029: FROM mtl_system_items_b_kfv
2030: WHERE organization_id = p_org_id
2031: AND concatenated_segments = p_inventory_name;
2032:
2033: CURSOR c_cat_id_exists (p_category_id IN NUMBER) IS