APPS.INV_KANBAN_PVT dependencies on MTL_KANBAN_CARDS

Line 750: FROM MTL_KANBAN_CARDS

746: --OR cancel status
747: BEGIN
748: SELECT kanban_card_id
749: INTO l_temp
750: FROM MTL_KANBAN_CARDS
751: WHERE kanban_card_id = p_kanban_Card_Id
752: FOR UPDATE NOWAIT;
753: mydebug('Lock accuired for kanban card');
754: EXCEPTION

Line 1112: FROM MTL_KANBAN_CARDS

1108: BEGIN
1109:
1110: Select 'x'
1111: INTO l_dummy
1112: FROM MTL_KANBAN_CARDS
1113: WHERE pull_sequence_id = p_pull_sequence_id
1114: AND (card_status = INV_Kanban_PVT.G_Card_Status_Active or
1115: card_status = INV_Kanban_PVT.G_Card_Status_Hold);
1116: Raise Too_Many_Rows;

Line 1161: FROM MTL_KANBAN_CARDS

1157: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1158: BEGIN
1159: Select 'x'
1160: INTO l_dummy
1161: FROM MTL_KANBAN_CARDS
1162: WHERE pull_sequence_id = p_pull_sequence_id
1163: AND (card_status = INV_Kanban_PVT.G_Card_Status_Active or
1164: card_status = INV_Kanban_PVT.G_Card_Status_Hold)
1165: -- AND nvl(p_kanban_size,-1) > 0

Line 1190: FROM MTL_KANBAN_CARDS

1186: When No_data_found Then
1187: begin
1188: Select 'x'
1189: INTO l_dummy
1190: FROM MTL_KANBAN_CARDS
1191: WHERE pull_sequence_id = p_pull_sequence_id
1192: AND (card_status = INV_Kanban_PVT.G_Card_Status_Active or
1193: card_status = INV_Kanban_PVT.G_Card_Status_Hold)
1194: AND nvl(p_kanban_size,-1) > 0

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

1365: select subinventory_name, nvl(locator_id,0), inventory_item_id,
1366: organization_id, source_type, supply_status
1367: into l_subinventory, l_loc_id, l_item_id,
1368: l_org_id, l_source_type, l_supply_status
1369: from mtl_kanban_cards
1370: where kanban_card_id = p_kanban_id;
1371: exception
1372: When NO_DATA_FOUND then
1373: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_CARD_NOT_FOUND');

Line 3332: From Mtl_Kanban_Cards

3328: Select Kanban_card_Id,kanban_size,
3329: NULL lot_item_id,null lot_number,NULL lot_item_revision,
3330: NULL lot_subinventory_code,NULL lot_location_id,NULL lot_quantity,
3331: NULL replenish_quantity
3332: From Mtl_Kanban_Cards
3333: Where Pull_Sequence_Id = p_Kanban_Card_Rec.Pull_Sequence_Id
3334: -- And Card_Status = INV_Kanban_PVT.G_Card_Status_Active
3335: And Supply_Status = INV_Kanban_PVT.G_Supply_Status_Wait
3336: And Nvl(Supplier_Id,-1) = Nvl(p_Kanban_Card_Rec.Supplier_Id,-1)

Line 3442: Update Mtl_Kanban_Cards

3438: X_Current_Replenish_Cycle_Id := l_Current_Replenish_Cycle_Id;
3439:
3440: For l_card_Count in 2..l_Kanban_card_Tbl.Count
3441: Loop
3442: Update Mtl_Kanban_Cards
3443: Set Supply_Status = p_card_supply_status,
3444: Current_Replnsh_Cycle_Id = l_Current_Replenish_Cycle_Id,
3445: Last_Update_Date = SYSDATE,
3446: Last_Updated_By = FND_GLOBAL.USER_ID

Line 3556: FROM mtl_kanban_cards

3552: IS
3553: l_kanban_card_rec INV_Kanban_PVT.kanban_card_rec_type;
3554: CURSOR get_kanban_card_ids IS
3555: SELECT kanban_card_id
3556: FROM mtl_kanban_cards
3557: WHERE pull_sequence_id = p_pull_sequence_id ;
3558:
3559: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3560: BEGIN