DBA Data[Home] [Help]

APPS.INV_MINMAX_PVT dependencies on PER_ALL_PEOPLE_F

Line 26: , buyer per_all_people_f.full_name%TYPE

22: , variable_lead_time mtl_system_items.variable_lead_time%TYPE
23: , postprocessing_lead_time mtl_system_items.postprocessing_lead_time%TYPE
24: , buying_lead_time mtl_system_items.full_lead_time%TYPE
25: , planner mtl_system_items.planner_code%TYPE
26: , buyer per_all_people_f.full_name%TYPE
27: , category VARCHAR2(800)
28: , category_id mtl_categories.category_id%TYPE
29: , item_id mtl_system_items.inventory_item_id%TYPE
30: , lot_ctl mtl_system_items.lot_control_code%TYPE

Line 475: per_all_people_f v

471: FROM mtl_categories b,
472: mtl_item_categories a,
473: mtl_system_items_vl c,
474: mtl_parameters p,
475: per_all_people_f v
476: WHERE b.category_id = a.category_id
477: AND b.structure_id = :mcat_struct_id
478: AND c.inventory_item_flag = ''Y''
479: AND p.organization_id = :org_id

Line 568: per_all_people_f v

564: mtl_system_items_vl c,
565: mtl_parameters p,
566: mtl_secondary_inventories m,
567: mtl_item_sub_inventories s,
568: per_all_people_f v
569: WHERE b.category_id = a.category_id
570: AND b.structure_id = :mcat_struct_id
571: AND c.inventory_item_flag = ''Y''
572: AND p.organization_id = :org_id