APPS.INVPOPIF dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 2155: FROM mtl_system_items_b_kfv

2151:
2152: CURSOR c_item_exists(cp_item_id NUMBER,
2153: cp_org_id NUMBER) IS
2154: SELECT 1 ,concatenated_segments
2155: FROM mtl_system_items_b_kfv
2156: WHERE inventory_item_id = cp_item_id
2157: --Bug 4964023 - Adding the org id clause for org assign case
2158: AND organization_id = cp_org_id;
2159:

Line 2160: CURSOR c_fetch_by_item_number(cp_item_number MTL_SYSTEM_ITEMS_B_KFV.CONCATENATED_SEGMENTS%TYPE,

2156: WHERE inventory_item_id = cp_item_id
2157: --Bug 4964023 - Adding the org id clause for org assign case
2158: AND organization_id = cp_org_id;
2159:
2160: CURSOR c_fetch_by_item_number(cp_item_number MTL_SYSTEM_ITEMS_B_KFV.CONCATENATED_SEGMENTS%TYPE,
2161: cp_org_id NUMBER) IS
2162: SELECT inventory_item_id
2163: FROM mtl_system_items_b_kfv
2164: WHERE concatenated_segments = cp_item_number

Line 2163: FROM mtl_system_items_b_kfv

2159:
2160: CURSOR c_fetch_by_item_number(cp_item_number MTL_SYSTEM_ITEMS_B_KFV.CONCATENATED_SEGMENTS%TYPE,
2161: cp_org_id NUMBER) IS
2162: SELECT inventory_item_id
2163: FROM mtl_system_items_b_kfv
2164: WHERE concatenated_segments = cp_item_number
2165: AND organization_id = cp_org_id;
2166:
2167: /* Bug 6200383 Added one more AND condition on organization_id */

Line 2186: l_item_number MTL_SYSTEM_ITEMS_B_KFV.CONCATENATED_SEGMENTS%TYPE;

2182: l_err_text VARCHAR2(200);
2183: l_rev_exist NUMBER(10) := 0;
2184: l_status NUMBER(10):= 0;
2185: l_item_id mtl_system_items_b.inventory_item_id%TYPE;
2186: l_item_number MTL_SYSTEM_ITEMS_B_KFV.CONCATENATED_SEGMENTS%TYPE;
2187: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;
2188: dumm_status NUMBER;
2189: l_updateable_item_number varchar2(10);
2190: LOGGING_ERR EXCEPTION;