APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on MTL_CATEGORIES_B_KFV

Line 4761: l_item_category_from mtl_categories_b_kfv.concatenated_segments%TYPE :=p_item_category_from;

4757: l_item_num_from mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_num_from;
4758: l_item_num_to mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_num_to;
4759: l_category_set_id mtl_category_sets_b.category_set_id%TYPE :=p_category_set_id;
4760: l_structure_id mtl_category_sets_b.structure_id%TYPE :=p_category_structure_id;
4761: l_item_category_from mtl_categories_b_kfv.concatenated_segments%TYPE :=p_item_category_from;
4762: l_item_category_to mtl_categories_b_kfv.concatenated_segments%TYPE :=p_item_category_to;
4763: l_creation_date_from DATE;
4764: l_creation_date_to DATE;
4765: l_export_item_count NUMBER;

Line 4762: l_item_category_to mtl_categories_b_kfv.concatenated_segments%TYPE :=p_item_category_to;

4758: l_item_num_to mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_num_to;
4759: l_category_set_id mtl_category_sets_b.category_set_id%TYPE :=p_category_set_id;
4760: l_structure_id mtl_category_sets_b.structure_id%TYPE :=p_category_structure_id;
4761: l_item_category_from mtl_categories_b_kfv.concatenated_segments%TYPE :=p_item_category_from;
4762: l_item_category_to mtl_categories_b_kfv.concatenated_segments%TYPE :=p_item_category_to;
4763: l_creation_date_from DATE;
4764: l_creation_date_to DATE;
4765: l_export_item_count NUMBER;
4766: l_item_name mtl_system_items_b.description%TYPE;

Line 4791: ,mtl_categories_b_kfv mc

4787: FROM
4788: mtl_system_items_b_kfv items
4789: ,mtl_item_categories mic
4790: ,mtl_category_sets_b mcs
4791: ,mtl_categories_b_kfv mc
4792: ,mtl_units_of_measure_tl muom --yao zhang add for bug 8339490
4793: WHERE items.organization_id=l_master_org_id
4794: AND items.inventory_item_status_code=nvl(l_item_status,items.inventory_item_status_code)
4795: AND items.concatenated_segments>=nvl(l_item_num_from,items.concatenated_segments)