APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on MTL_CATEGORIES_B_KFV

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

4215: l_item_num_from mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_num_from;
4216: l_item_num_to mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_num_to;
4217: l_category_set_id mtl_category_sets_b.category_set_id%TYPE :=p_category_set_id;
4218: l_structure_id mtl_category_sets_b.structure_id%TYPE :=p_category_structure_id;
4219: l_item_category_from mtl_categories_b_kfv.concatenated_segments%TYPE :=p_item_category_from;
4220: l_item_category_to mtl_categories_b_kfv.concatenated_segments%TYPE :=p_item_category_to;
4221: l_creation_date_from DATE;
4222: l_creation_date_to DATE;
4223: l_export_item_count NUMBER;

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

4216: l_item_num_to mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_num_to;
4217: l_category_set_id mtl_category_sets_b.category_set_id%TYPE :=p_category_set_id;
4218: l_structure_id mtl_category_sets_b.structure_id%TYPE :=p_category_structure_id;
4219: l_item_category_from mtl_categories_b_kfv.concatenated_segments%TYPE :=p_item_category_from;
4220: l_item_category_to mtl_categories_b_kfv.concatenated_segments%TYPE :=p_item_category_to;
4221: l_creation_date_from DATE;
4222: l_creation_date_to DATE;
4223: l_export_item_count NUMBER;
4224: l_item_name mtl_system_items_b.description%TYPE;

Line 4248: ,mtl_categories_b_kfv mc

4244: FROM
4245: mtl_system_items_b_kfv items
4246: ,mtl_item_categories mic
4247: ,mtl_category_sets_b mcs
4248: ,mtl_categories_b_kfv mc
4249: WHERE items.organization_id=l_master_org_id
4250: AND items.inventory_item_status_code=nvl(l_item_status,items.inventory_item_status_code)
4251: AND items.concatenated_segments>=nvl(l_item_num_from,items.concatenated_segments)
4252: AND items.concatenated_segments<=nvl(l_item_num_to,items.concatenated_segments)