[Home] [Help]
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
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
1333: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1334: Begin
1335: Select concatenated_segments,organization_code,kanban_card_number
1336: into x_item_name,x_org_code,x_kanban_num
1337: from mtl_system_items_kfv a , mtl_parameters b, mtl_kanban_cards card
1338: where a.inventory_item_id = p_item_id
1339: and a.organization_id = p_org_id
1340: and b.organization_id = p_org_id
1341: and card.kanban_card_id = p_kanban_id;
1990: l_project_accounting_context := null;
1991:
1992: SELECT NVL(project_reference_enabled,2)
1993: INTO l_project_reference_enabled
1994: FROM mtl_parameters
1995: WHERE organization_id = p_kanban_card_rec_tbl(1).organization_id;
1996:
1997: IF (l_project_reference_enabled = 1)THEN
1998: IF (p_kanban_card_rec_tbl(1).locator_id IS NOT NULL)THEN
2244: and secondary_inventory_name = p_kanban_card_rec_tbl(1).subinventory_name;
2245:
2246: select stock_locator_control_code
2247: into l_org_locator_control_code
2248: from mtl_parameters
2249: where organization_id = p_kanban_card_rec_tbl(1).organization_id;
2250:
2251: if l_org_locator_control_code = 1 then
2252: p_kanban_card_rec_tbl(1).source_locator_id := null;
2502: end if;
2503:
2504: SELECT NVL(project_reference_enabled,2)
2505: INTO l_project_reference_enabled
2506: FROM mtl_parameters
2507: WHERE organization_id = p_kanban_card_rec_tbl(1).organization_id;
2508:
2509: IF (l_project_reference_enabled = 1)THEN
2510: IF (p_kanban_card_rec_tbl(1).locator_id IS NOT NULL)THEN
2544: l_pre_proc_lead_time := get_preprocessing_lead_time(p_kanban_card_rec_tbl(1).organization_id , p_kanban_card_rec_tbl(1).inventory_item_id);
2545: BEGIN
2546: SELECT c1.calendar_date
2547: INTO l_first_unit_start_date
2548: FROM mtl_parameters o ,
2549: bom_calendar_dates c1,
2550: bom_calendar_dates c
2551: WHERE o.organization_id = p_kanban_card_rec_tbl(1).organization_id
2552: AND c1.calendar_code = c.calendar_code
2712: if ( l_order_count = 1 ) THEN
2713:
2714: SELECT NVL(project_reference_enabled,2)
2715: INTO l_project_reference_enabled
2716: FROM mtl_parameters
2717: WHERE organization_id = p_kanban_card_rec_tbl(1).organization_id;
2718:
2719: IF (l_project_reference_enabled = 1)THEN
2720: IF (p_kanban_card_rec_tbl(1).locator_id IS NOT NULL)THEN
3462: l_Process_lead_Time,
3463: l_PostProcess_lead_Time,
3464: l_Revision_qty_control_code
3465: From Mtl_System_Items msi,
3466: mtl_Parameters org,
3467: mtl_secondary_inventories mss
3468: Where Msi.Organization_Id = l_kanban_card_Rec_Tbl(1).Organization_id
3469: And Msi.Inventory_Item_Id = l_kanban_card_Rec_Tbl(1).Inventory_Item_Id
3470: And org.Organization_Id = l_kanban_card_Rec_Tbl(1).Organization_Id
3504: ELSE
3505: l_sql_stmt_no := 30;
3506: select c1.calendar_date
3507: into l_need_by_date
3508: from mtl_parameters o,
3509: bom_calendar_dates c1,
3510: bom_calendar_dates c
3511: where o.organization_id = l_kanban_card_Rec_Tbl(1).Organization_id
3512: and c1.calendar_code = c.calendar_code