APPS.INV_KANBAN_PVT dependencies on MTL_PARAMETERS

Line 91: from mtl_system_items_kfv a , mtl_parameters b,

87: Select concatenated_segments,organization_code,
88: subinventory_name,locator_id,pull.organization_id
89: into x_item_name,x_org_code,x_subinventory,l_locator_id,
90: l_organization_id
91: from mtl_system_items_kfv a , mtl_parameters b,
92: mtl_kanban_pull_sequences pull
93: where a.inventory_item_id = pull.inventory_item_id
94: and a.organization_id = Pull.organization_id
95: and b.organization_id = Pull.organization_id

Line 376: from mtl_system_items_kfv a , mtl_parameters b

372: Then
373:
374: Select concatenated_segments,organization_code
375: into l_item_name,l_org_code
376: from mtl_system_items_kfv a , mtl_parameters b
377: where a.inventory_item_id =
378: l_Pull_Sequence_Rec.inventory_item_id
379: and a.organization_id =
380: l_Pull_Sequence_Rec.organization_id

Line 1316: from mtl_system_items_kfv a , mtl_parameters b, mtl_kanban_cards card

1312: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1313: Begin
1314: Select concatenated_segments,organization_code,kanban_card_number
1315: into x_item_name,x_org_code,x_kanban_num
1316: from mtl_system_items_kfv a , mtl_parameters b, mtl_kanban_cards card
1317: where a.inventory_item_id = p_item_id
1318: and a.organization_id = p_org_id
1319: and b.organization_id = p_org_id
1320: and card.kanban_card_id = p_kanban_id;

Line 1716: FROM mtl_parameters

1712: l_project_accounting_context := null;
1713:
1714: SELECT NVL(project_reference_enabled,2)
1715: INTO l_project_reference_enabled
1716: FROM mtl_parameters
1717: WHERE organization_id = p_kanban_card_rec_tbl(1).organization_id;
1718:
1719: IF (l_project_reference_enabled = 1)THEN
1720: IF (p_kanban_card_rec_tbl(1).locator_id IS NOT NULL)THEN

Line 1949: from mtl_parameters

1945: and secondary_inventory_name = p_kanban_card_rec_tbl(1).subinventory_name;
1946:
1947: select stock_locator_control_code
1948: into l_org_locator_control_code
1949: from mtl_parameters
1950: where organization_id = p_kanban_card_rec_tbl(1).organization_id;
1951:
1952: if l_org_locator_control_code = 1 then
1953: p_kanban_card_rec_tbl(1).source_locator_id := null;

Line 2165: FROM mtl_parameters

2161: LOOP
2162:
2163: SELECT NVL(project_reference_enabled,2)
2164: INTO l_project_reference_enabled
2165: FROM mtl_parameters
2166: WHERE organization_id = p_kanban_card_rec_tbl(1).organization_id;
2167:
2168: IF (l_project_reference_enabled = 1)THEN
2169: IF (p_kanban_card_rec_tbl(1).locator_id IS NOT NULL)THEN

Line 2346: FROM mtl_parameters

2342: if ( l_order_count = 1 ) THEN
2343:
2344: SELECT NVL(project_reference_enabled,2)
2345: INTO l_project_reference_enabled
2346: FROM mtl_parameters
2347: WHERE organization_id = p_kanban_card_rec_tbl(1).organization_id;
2348:
2349: IF (l_project_reference_enabled = 1)THEN
2350: IF (p_kanban_card_rec_tbl(1).locator_id IS NOT NULL)THEN

Line 3067: mtl_Parameters org,

3063: l_Process_lead_Time,
3064: l_PostProcess_lead_Time,
3065: l_Revision_qty_control_code
3066: From Mtl_System_Items msi,
3067: mtl_Parameters org,
3068: mtl_secondary_inventories mss
3069: Where Msi.Organization_Id = l_kanban_card_Rec_Tbl(1).Organization_id
3070: And Msi.Inventory_Item_Id = l_kanban_card_Rec_Tbl(1).Inventory_Item_Id
3071: And org.Organization_Id = l_kanban_card_Rec_Tbl(1).Organization_Id

Line 3109: from mtl_parameters o,

3105: ELSE
3106: l_sql_stmt_no := 30;
3107: select c1.calendar_date
3108: into l_need_by_date
3109: from mtl_parameters o,
3110: bom_calendar_dates c1,
3111: bom_calendar_dates c
3112: where o.organization_id = l_kanban_card_Rec_Tbl(1).Organization_id
3113: and c1.calendar_code = c.calendar_code