APPS.INV_KANBAN_PVT dependencies on MTL_KANBAN_CARDS

Line 764: FROM MTL_KANBAN_CARDS

760: --OR cancel status
761: BEGIN
762: SELECT kanban_card_id
763: INTO l_temp
764: FROM MTL_KANBAN_CARDS
765: WHERE kanban_card_id = p_kanban_Card_Id
766: FOR UPDATE NOWAIT;
767: mydebug('Lock accuired for kanban card');
768: EXCEPTION

Line 1133: FROM MTL_KANBAN_CARDS

1129: BEGIN
1130:
1131: Select 'x'
1132: INTO l_dummy
1133: FROM MTL_KANBAN_CARDS
1134: WHERE pull_sequence_id = p_pull_sequence_id
1135: AND (card_status = INV_Kanban_PVT.G_Card_Status_Active or
1136: card_status = INV_Kanban_PVT.G_Card_Status_Hold);
1137: Raise Too_Many_Rows;

Line 1182: FROM MTL_KANBAN_CARDS

1178: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1179: BEGIN
1180: Select 'x'
1181: INTO l_dummy
1182: FROM MTL_KANBAN_CARDS
1183: WHERE pull_sequence_id = p_pull_sequence_id
1184: AND (card_status = INV_Kanban_PVT.G_Card_Status_Active or
1185: card_status = INV_Kanban_PVT.G_Card_Status_Hold)
1186: -- AND nvl(p_kanban_size,-1) > 0

Line 1211: FROM MTL_KANBAN_CARDS

1207: When No_data_found Then
1208: begin
1209: Select 'x'
1210: INTO l_dummy
1211: FROM MTL_KANBAN_CARDS
1212: WHERE pull_sequence_id = p_pull_sequence_id
1213: AND (card_status = INV_Kanban_PVT.G_Card_Status_Active or
1214: card_status = INV_Kanban_PVT.G_Card_Status_Hold)
1215: AND nvl(p_kanban_size,-1) > 0

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 1390: from mtl_kanban_cards

1386: select subinventory_name, nvl(locator_id,0), inventory_item_id,
1387: organization_id, source_type, supply_status
1388: into l_subinventory, l_loc_id, l_item_id,
1389: l_org_id, l_source_type, l_supply_status
1390: from mtl_kanban_cards
1391: where kanban_card_id = p_kanban_id;
1392: exception
1393: When NO_DATA_FOUND then
1394: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_CARD_NOT_FOUND');

Line 1617: from mtl_kanban_cards

1613: IF (l_debug = 1 ) THEN
1614: INV_LOG_UTIL.TRACE('validating kanban_number','INV_KANBAN_PVT.Create_Kanban_Cards');
1615: END IF;
1616: select 1 into l_temp
1617: from mtl_kanban_cards
1618: where organization_id = p_Pull_Sequence_Rec.Organization_id
1619: and kanban_card_number = l_Kanban_Card_Number;
1620: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_EXISTS');
1621: fnd_message.set_token ('ATTRIBUTE', 'Kanban Card Number'||l_Kanban_Card_Number);

Line 3731: From Mtl_Kanban_Cards

3727: Select Kanban_card_Id,kanban_size,
3728: NULL lot_item_id,null lot_number,NULL lot_item_revision,
3729: NULL lot_subinventory_code,NULL lot_location_id,NULL lot_quantity,
3730: NULL replenish_quantity
3731: From Mtl_Kanban_Cards
3732: Where Pull_Sequence_Id = p_Kanban_Card_Rec.Pull_Sequence_Id
3733: -- And Card_Status = INV_Kanban_PVT.G_Card_Status_Active
3734: And Supply_Status = INV_Kanban_PVT.G_Supply_Status_Wait
3735: And Nvl(Supplier_Id,-1) = Nvl(p_Kanban_Card_Rec.Supplier_Id,-1)

Line 3835: Update Mtl_Kanban_Cards

3831: X_Current_Replenish_Cycle_Id := l_Current_Replenish_Cycle_Id;
3832:
3833: For l_card_Count in 2..l_Kanban_card_Tbl.Count
3834: Loop
3835: Update Mtl_Kanban_Cards
3836: Set Supply_Status = p_card_supply_status,
3837: Current_Replnsh_Cycle_Id = l_Current_Replenish_Cycle_Id,
3838: replenishment_count = nvl(replenishment_count,0)+1,
3839: Last_Update_Date = SYSDATE,

Line 3859: Update Mtl_Kanban_Cards

3855: l_Kanban_card_Tbl(l_Order_Count).Kanban_Size := l_Wait_Kanban_card_Tbl(l_Card_Count).Kanban_Size;
3856: End Loop;
3857:
3858: For l_card_Count in 2..l_Kanban_card_Tbl.Count Loop
3859: Update Mtl_Kanban_Cards
3860: Set Supply_Status = INV_Kanban_PVT.G_Supply_Status_Consolidate,
3861: Last_Update_Date = SYSDATE,
3862: Last_Updated_By = FND_GLOBAL.USER_ID
3863: Where Kanban_Card_Id = l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id;

Line 3957: FROM mtl_kanban_cards

3953: IS
3954: l_kanban_card_rec INV_Kanban_PVT.kanban_card_rec_type;
3955: CURSOR get_kanban_card_ids IS
3956: SELECT kanban_card_id
3957: FROM mtl_kanban_cards
3958: WHERE pull_sequence_id = p_pull_sequence_id ;
3959:
3960: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3961: BEGIN