DBA Data[Home] [Help]

APPS.INV_KANBAN_PVT dependencies on MTL_SYSTEM_ITEMS

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 1931: from mtl_system_items

1927: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
1928:
1929: select location_control_code
1930: into l_item_locator_control_code
1931: from mtl_system_items
1932: where organization_id = p_kanban_card_rec_tbl(1).organization_id
1933: and inventory_item_id = p_kanban_card_rec_tbl(1).inventory_item_id;
1934:
1935: select locator_type

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

Line 2850: (SELECT 1 FROM mtl_system_items

2846:
2847: BEGIN
2848: SELECT 'Y' INTO l_is_lot_control
2849: FROM dual WHERE exists
2850: (SELECT 1 FROM mtl_system_items
2851: WHERE
2852: organization_id = p_kanban_card_rec_tbl(1).organization_id
2853: AND inventory_item_id = p_kanban_card_rec_tbl(1).inventory_item_id
2854: AND lot_control_code = 2);

Line 2944: (SELECT 1 FROM mtl_system_items

2940:
2941: BEGIN
2942: SELECT 'Y' INTO l_is_lot_control
2943: FROM dual WHERE exists
2944: (SELECT 1 FROM mtl_system_items
2945: WHERE
2946: organization_id = p_kanban_card_rec_tbl(1).organization_id
2947: AND inventory_item_id = p_kanban_card_rec_tbl(1).inventory_item_id
2948: AND lot_control_code = 2);

Line 3066: From Mtl_System_Items msi,

3062: l_PreProcess_lead_Time,
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

Line 3681: from MTL_SYSTEM_ITEMS

3677: select
3678: Nvl(repetitive_planning_flag,'N'), lot_control_code
3679: into
3680: l_rep_flag, l_lot_control
3681: from MTL_SYSTEM_ITEMS
3682: where
3683: inventory_item_id = l_assembly_item_id AND
3684: organization_id = l_organization_id;
3685: EXCEPTION

Line 3969: FROM mtl_system_items

3965:
3966: /* Check whether item is serial controlled or not */
3967: SELECT DECODE(serial_number_control_code,1,'F','T')
3968: INTO l_serial_control_code
3969: FROM mtl_system_items
3970: WHERE inventory_item_id = l_mo_line_rec.inventory_item_id
3971: AND organization_id = l_mo_line_rec.organization_id;
3972:
3973: INV_Replenish_Detail_PUB.Line_Details_PUB (