APPS.GMPPSRP dependencies on MTL_SYSTEM_ITEMS

Line 242: ' mtl_system_items_kfv msi, '||

238: x_select := x_select || ' mtl_categories_kfv mca, ';
239: END IF;
240:
241: x_select := x_select ||
242: ' mtl_system_items_kfv msi, '||
243: ' mtl_item_categories mic, '||
244: ' ps_schd_dtl psd, '||
245: ' mtl_category_sets mcs '||
246: ' WHERE '||

Line 447: SELECT primary_uom_code FROM mtl_system_items

443: X_row_count NUMBER;
444: X_uom_code VARCHAR2(3);
445:
446: CURSOR cur_get_item_uom IS
447: SELECT primary_uom_code FROM mtl_system_items
448: WHERE inventory_item_id = V_item_id
449: AND organization_id = V_organization_id;
450:
451: BEGIN

Line 817: FROM mtl_system_items_kfv

813: v_item_name VARCHAR2(240);
814: BEGIN
815:
816: SELECT concatenated_segments INTO v_item_name
817: FROM mtl_system_items_kfv
818: WHERE inventory_item_id = p_inventory_item_id
819: AND organization_id = p_organization_id;
820:
821: RETURN v_item_name;

Line 873: FROM mtl_system_items

869: v_planner_code VARCHAR2(10);
870: BEGIN
871:
872: SELECT planner_code INTO v_planner_code
873: FROM mtl_system_items
874: WHERE inventory_item_id = p_inventory_item_id
875: AND organization_id = p_organization_id;
876:
877: RETURN v_planner_code;

Line 903: FROM mtl_system_items_b msi, per_people_f he

899: v_buyer_name VARCHAR2(240);
900: BEGIN
901:
902: SELECT he.full_name INTO v_buyer_name
903: FROM mtl_system_items_b msi, per_people_f he
904: WHERE msi.organization_id = p_organization_id
905: AND msi.inventory_item_id = p_inventory_item_id
906: AND msi.buyer_id = he.person_id ;
907:

Line 975: FROM mtl_system_items

971: v_uom_code VARCHAR2(3);
972: BEGIN
973:
974: SELECT primary_uom_code INTO v_uom_code
975: FROM mtl_system_items
976: WHERE inventory_item_id = p_inventory_item_id
977: AND organization_id = p_organization_id;
978:
979: RETURN v_uom_code;