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 777: FROM mtl_system_items_kfv

773: v_item_name VARCHAR2(240);
774: BEGIN
775:
776: SELECT concatenated_segments INTO v_item_name
777: FROM mtl_system_items_kfv
778: WHERE inventory_item_id = p_inventory_item_id
779: AND organization_id = p_organization_id;
780:
781: RETURN v_item_name;

Line 833: FROM mtl_system_items

829: v_planner_code VARCHAR2(10);
830: BEGIN
831:
832: SELECT planner_code INTO v_planner_code
833: FROM mtl_system_items
834: WHERE inventory_item_id = p_inventory_item_id
835: AND organization_id = p_organization_id;
836:
837: RETURN v_planner_code;

Line 863: FROM mtl_system_items_b msi, per_people_f he

859: v_buyer_name VARCHAR2(240);
860: BEGIN
861:
862: SELECT he.full_name INTO v_buyer_name
863: FROM mtl_system_items_b msi, per_people_f he
864: WHERE msi.organization_id = p_organization_id
865: AND msi.inventory_item_id = p_inventory_item_id
866: AND msi.buyer_id = he.person_id ;
867:

Line 935: FROM mtl_system_items

931: v_uom_code VARCHAR2(3);
932: BEGIN
933:
934: SELECT primary_uom_code INTO v_uom_code
935: FROM mtl_system_items
936: WHERE inventory_item_id = p_inventory_item_id
937: AND organization_id = p_organization_id;
938:
939: RETURN v_uom_code;