DBA Data[Home] [Help]

APPS.GMPPSRP dependencies on MTL_SYSTEM_ITEMS_B

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: