APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on MTL_CATEGORY_SETS_B

Line 4217: l_category_set_id mtl_category_sets_b.category_set_id%TYPE :=p_category_set_id;

4213: l_org_id NUMBER :=p_org_id;
4214: l_master_org_id NUMBER :=p_master_org_id;
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;

Line 4218: l_structure_id mtl_category_sets_b.structure_id%TYPE :=p_category_structure_id;

4214: l_master_org_id NUMBER :=p_master_org_id;
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;

Line 4247: ,mtl_category_sets_b mcs

4243: ,items.primary_unit_of_measure uom
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)