APPS.FLM_KANBAN_CONSOLIDATION dependencies on MTL_PARAMETERS

Line 55: FROM mtl_parameters

51: l_Kanban_Card_Rec_Tbl := p_kanban_card_rec_tbl;
52:
53: SELECT NVL(project_reference_enabled,2)
54: INTO l_project_reference_enabled
55: FROM mtl_parameters
56: WHERE organization_id = l_Kanban_Card_Rec_Tbl(1).organization_id;
57:
58: l_Current_Replenish_Cycle_Id := Get_Next_Replenish_Cycle_Id;
59: l_group_code := l_Kanban_Card_Rec_Tbl(1).pull_sequence_id||

Line 266: from mtl_parameters

262: and secondary_inventory_name = l_Kanban_Card_Rec_Tbl(l_order_count).subinventory_name;
263:
264: select stock_locator_control_code
265: into l_org_locator_control_code
266: from mtl_parameters
267: where organization_id = l_Kanban_Card_Rec_Tbl(l_order_count).organization_id;
268:
269: if l_org_locator_control_code = 1 then
270: l_Kanban_Card_Rec_Tbl(l_order_count).source_locator_id := null;

Line 499: mtl_Parameters org,

495: l_Process_lead_Time,
496: l_PostProcess_lead_Time,
497: l_Revision_qty_control_code
498: From Mtl_System_Items msi,
499: mtl_Parameters org,
500: mtl_secondary_inventories mss
501: Where Msi.Organization_Id = l_kanban_card_Rec_Tbl(1).Organization_id
502: And Msi.Inventory_Item_Id = l_kanban_card_Rec_Tbl(1).Inventory_Item_Id
503: And org.Organization_Id = l_kanban_card_Rec_Tbl(1).Organization_Id

Line 539: from mtl_parameters o,

535: ELSE
536: l_sql_stmt_no := 30;
537: select c1.calendar_date
538: into l_need_by_date
539: from mtl_parameters o,
540: bom_calendar_dates c1,
541: bom_calendar_dates c
542: where o.organization_id = l_kanban_card_Rec_Tbl(1).Organization_id
543: and c1.calendar_code = c.calendar_code