DBA Data[Home] [Help]

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 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 2805: from MTL_SYSTEM_ITEMS_KFV

2801: begin
2802: select nvl(repetitive_planning_flag,'N'), nvl(fixed_lead_time,0),
2803: nvl(variable_lead_time,0)
2804: into v_rep_flag, v_fixed_lead_time, v_var_lead_time
2805: from MTL_SYSTEM_ITEMS_KFV
2806: where
2807: inventory_item_id = p_kanban_card_rec_tbl(1).inventory_item_id AND
2808: organization_id = p_kanban_card_rec_tbl(1).organization_id;
2809: exception