APPS.EGO_USER_ATTRS_DATA_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 11005: FROM mtl_system_items_b msib

11001: x_style_item_id OUT NOCOPY NUMBER) IS
11002:
11003: CURSOR c IS
11004: SELECT msib.style_item_flag, msib.style_item_id
11005: FROM mtl_system_items_b msib
11006: WHERE msib.organization_id = p_organization_id
11007: AND msib.inventory_item_id = p_inventory_item_id;
11008:
11009:

Line 11028: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;

11024: p_pkcol_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY)
11025: RETURN EGO_COL_NAME_VALUE_PAIR_ARRAY IS
11026:
11027: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
11028: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
11029: l_organization_id mtl_system_items_b.organization_id%TYPE;
11030: l_style_item_flag mtl_system_items_b.style_item_flag%TYPE;
11031: l_style_item_id mtl_system_items_b.style_item_id%TYPE;
11032: l_defaulting ego_attr_group_dl.defaulting%TYPE;

Line 11029: l_organization_id mtl_system_items_b.organization_id%TYPE;

11025: RETURN EGO_COL_NAME_VALUE_PAIR_ARRAY IS
11026:
11027: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
11028: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
11029: l_organization_id mtl_system_items_b.organization_id%TYPE;
11030: l_style_item_flag mtl_system_items_b.style_item_flag%TYPE;
11031: l_style_item_id mtl_system_items_b.style_item_id%TYPE;
11032: l_defaulting ego_attr_group_dl.defaulting%TYPE;
11033:

Line 11030: l_style_item_flag mtl_system_items_b.style_item_flag%TYPE;

11026:
11027: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
11028: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
11029: l_organization_id mtl_system_items_b.organization_id%TYPE;
11030: l_style_item_flag mtl_system_items_b.style_item_flag%TYPE;
11031: l_style_item_id mtl_system_items_b.style_item_id%TYPE;
11032: l_defaulting ego_attr_group_dl.defaulting%TYPE;
11033:
11034: BEGIN

Line 11031: l_style_item_id mtl_system_items_b.style_item_id%TYPE;

11027: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
11028: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
11029: l_organization_id mtl_system_items_b.organization_id%TYPE;
11030: l_style_item_flag mtl_system_items_b.style_item_flag%TYPE;
11031: l_style_item_id mtl_system_items_b.style_item_id%TYPE;
11032: l_defaulting ego_attr_group_dl.defaulting%TYPE;
11033:
11034: BEGIN
11035: Debug_msg('get_itmmgmt_pkcol: ' || ' Entering method');