APPS.INVPOPIF dependencies on MTL_SYSTEM_ITEMS_B

Line 1931: FROM mtl_system_items_b_kfv

1927:
1928: CURSOR c_item_exists(cp_item_id NUMBER,
1929: cp_org_id NUMBER) IS
1930: SELECT 1 ,concatenated_segments
1931: FROM mtl_system_items_b_kfv
1932: WHERE inventory_item_id = cp_item_id
1933: --Bug 4964023 - Adding the org id clause for org assign case
1934: AND organization_id = cp_org_id;
1935:

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

1932: WHERE inventory_item_id = cp_item_id
1933: --Bug 4964023 - Adding the org id clause for org assign case
1934: AND organization_id = cp_org_id;
1935:
1936: CURSOR c_fetch_by_item_number(cp_item_number MTL_SYSTEM_ITEMS_B_KFV.CONCATENATED_SEGMENTS%TYPE,
1937: cp_org_id NUMBER) IS
1938: SELECT inventory_item_id
1939: FROM mtl_system_items_b_kfv
1940: WHERE concatenated_segments = cp_item_number

Line 1939: FROM mtl_system_items_b_kfv

1935:
1936: CURSOR c_fetch_by_item_number(cp_item_number MTL_SYSTEM_ITEMS_B_KFV.CONCATENATED_SEGMENTS%TYPE,
1937: cp_org_id NUMBER) IS
1938: SELECT inventory_item_id
1939: FROM mtl_system_items_b_kfv
1940: WHERE concatenated_segments = cp_item_number
1941: AND organization_id = cp_org_id;
1942:
1943: /* Bug 6200383 Added one more AND condition on organization_id */

Line 1961: l_item_id mtl_system_items_b.inventory_item_id%TYPE;

1957: l_item_exist NUMBER(10) := 0;
1958: l_err_text VARCHAR2(200);
1959: l_rev_exist NUMBER(10) := 0;
1960: l_status NUMBER(10):= 0;
1961: l_item_id mtl_system_items_b.inventory_item_id%TYPE;
1962: l_item_number MTL_SYSTEM_ITEMS_B_KFV.CONCATENATED_SEGMENTS%TYPE;
1963: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;
1964: dumm_status NUMBER;
1965: l_updateable_item_number varchar2(10);

Line 1962: l_item_number MTL_SYSTEM_ITEMS_B_KFV.CONCATENATED_SEGMENTS%TYPE;

1958: l_err_text VARCHAR2(200);
1959: l_rev_exist NUMBER(10) := 0;
1960: l_status NUMBER(10):= 0;
1961: l_item_id mtl_system_items_b.inventory_item_id%TYPE;
1962: l_item_number MTL_SYSTEM_ITEMS_B_KFV.CONCATENATED_SEGMENTS%TYPE;
1963: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;
1964: dumm_status NUMBER;
1965: l_updateable_item_number varchar2(10);
1966: LOGGING_ERR EXCEPTION;