APPS.INV_KANBAN_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

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 1337: from mtl_system_items_kfv a , mtl_parameters b, mtl_kanban_cards card

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;

Line 3201: from MTL_SYSTEM_ITEMS_KFV

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