DBA Data[Home] [Help]

APPS.CSP_MINMAX_PVT dependencies on PER_ALL_PEOPLE_F

Line 21: , buyer per_all_people_f.full_name%TYPE

17: , variable_lead_time mtl_system_items.variable_lead_time%TYPE
18: , postprocessing_lead_time mtl_system_items.postprocessing_lead_time%TYPE
19: , buying_lead_time mtl_system_items.full_lead_time%TYPE
20: , planner mtl_system_items.planner_code%TYPE
21: , buyer per_all_people_f.full_name%TYPE
22: , category VARCHAR2(800)
23: , category_id mtl_categories.category_id%TYPE
24: , item_id mtl_system_items.inventory_item_id%TYPE
25: , lot_ctl mtl_system_items.lot_control_code%TYPE

Line 449: per_all_people_f v

445: FROM mtl_categories b,
446: mtl_item_categories a,
447: mtl_system_items c,
448: mtl_parameters p,
449: per_all_people_f v
450: WHERE b.category_id = a.category_id
451: AND b.structure_id = :mcat_struct_id
452: AND c.inventory_item_flag = ''Y''
453: AND p.organization_id = :org_id

Line 536: per_all_people_f v

532: mtl_system_items c,
533: mtl_parameters p,
534: mtl_secondary_inventories m,
535: mtl_item_sub_inventories s,
536: per_all_people_f v
537: WHERE b.category_id = a.category_id
538: AND b.structure_id = :mcat_struct_id
539: AND c.inventory_item_flag = ''Y''
540: AND p.organization_id = :org_id