[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;
2226: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
2227:
2228: select location_control_code,secondary_uom_code
2229: into l_item_locator_control_code,l_secondary_uom_code
2230: from mtl_system_items
2231: where organization_id = p_kanban_card_rec_tbl(1).organization_id
2232: and inventory_item_id = p_kanban_card_rec_tbl(1).inventory_item_id;
2233:
2234: select locator_type
3197: begin
3198: select nvl(repetitive_planning_flag,'N'), nvl(fixed_lead_time,0),
3199: nvl(variable_lead_time,0)
3200: into v_rep_flag, v_fixed_lead_time, v_var_lead_time
3201: from MTL_SYSTEM_ITEMS_KFV
3202: where
3203: inventory_item_id = p_kanban_card_rec_tbl(1).inventory_item_id AND
3204: organization_id = p_kanban_card_rec_tbl(1).organization_id;
3205: exception
3242:
3243: BEGIN
3244: SELECT 'Y' INTO l_is_lot_control
3245: FROM dual WHERE exists
3246: (SELECT 1 FROM mtl_system_items
3247: WHERE
3248: organization_id = p_kanban_card_rec_tbl(1).organization_id
3249: AND inventory_item_id = p_kanban_card_rec_tbl(1).inventory_item_id
3250: AND lot_control_code = 2);
3336:
3337: BEGIN
3338: SELECT 'Y' INTO l_is_lot_control
3339: FROM dual WHERE exists
3340: (SELECT 1 FROM mtl_system_items
3341: WHERE
3342: organization_id = p_kanban_card_rec_tbl(1).organization_id
3343: AND inventory_item_id = p_kanban_card_rec_tbl(1).inventory_item_id
3344: AND lot_control_code = 2);
3461: l_PreProcess_lead_Time,
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
4078: select
4079: Nvl(repetitive_planning_flag,'N'), lot_control_code
4080: into
4081: l_rep_flag, l_lot_control
4082: from MTL_SYSTEM_ITEMS
4083: where
4084: inventory_item_id = l_assembly_item_id AND
4085: organization_id = l_organization_id;
4086: EXCEPTION
4382:
4383: /* Check whether item is serial controlled or not */
4384: SELECT DECODE(serial_number_control_code,1,'F','T')
4385: INTO l_serial_control_code
4386: FROM mtl_system_items
4387: WHERE inventory_item_id = l_mo_line_rec.inventory_item_id
4388: AND organization_id = l_mo_line_rec.organization_id;
4389:
4390: INV_Replenish_Detail_PUB.Line_Details_PUB (
4453: BEGIN
4454:
4455: SELECT NVL(preprocessing_lead_time,0)
4456: INTO l_preprocessing_lead_time
4457: FROM mtl_system_items_b
4458: WHERE inventory_item_id = p_inventory_item_id
4459: AND organization_id = p_organization_id ;
4460:
4461: mydebug('In get_preprocessing_lead_time : l_preprocessing_lead_time :'||l_preprocessing_lead_time);