APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on MTL_CATEGORY_SETS_B

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

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

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

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

Line 4790: ,mtl_category_sets_b mcs

4786: ,muom.unit_of_measure_tl uom
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)