APPS.INVKBCGN dependencies on MTL_KANBAN_CARDS

Line 1318: FROM MTL_KANBAN_CARDS

1314:
1315: Cursor get_cards_to_update(p_pull_sequence_id NUMBER)
1316: Is
1317: SELECT kanban_card_id
1318: FROM MTL_KANBAN_CARDS
1319: WHERE card_status =INV_Kanban_PVT.G_Card_Status_Planned
1320: AND pull_sequence_id = p_pull_sequence_id;
1321: BEGIN
1322: l_pull_seq_rec.pull_sequence_id := X_pull_sequence_id;

Line 1395: FROM MTL_KANBAN_CARDS

1391: END IF;
1392: IF nvl(X_PLAN_CARD_FLAG,INVKBCGN.flm_ekb_no) =INVKBCGN.flm_ekb_yes THEN
1393: SELECT COUNT(*)
1394: INTO l_no_of_existing_cards
1395: FROM MTL_KANBAN_CARDS
1396: WHERE pull_sequence_id = X_Pull_sequence_id
1397: AND (card_status = INV_Kanban_PVT.G_Card_Status_Active or
1398: card_status = INV_Kanban_PVT.G_Card_Status_Hold)
1399: AND max_replenishments is null

Line 1404: UPDATE MTL_KANBAN_CARDS SET

1400: AND disable_date is null
1401: AND kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable;
1402:
1403: v_kanban_card.delete;
1404: UPDATE MTL_KANBAN_CARDS SET
1405: card_status=INV_Kanban_PVT.G_Card_Status_Active,
1406: last_update_date = sysdate,
1407: last_updated_by = fnd_global.user_id
1408: WHERE card_status =INV_Kanban_PVT.G_Card_Status_Planned

Line 1425: UPDATE MTL_KANBAN_CARDS SET

1421: end loop;
1422: end if;
1423:
1424: v_kanban_card.delete;
1425: UPDATE MTL_KANBAN_CARDS SET
1426: card_status=INV_Kanban_PVT.G_Card_Status_Active,
1427: last_update_date = sysdate,
1428: last_updated_by = fnd_global.user_id
1429: WHERE card_status =INV_Kanban_PVT.G_Card_Status_Planned

Line 1450: FROM MTL_KANBAN_CARDS

1446: END IF;
1447: IF nvl(X_CREATE_CARD_FLAG,INVKBCGN.flm_ekb_yes) =INVKBCGN.flm_ekb_yes THEN
1448: SELECT COUNT(*)
1449: INTO l_no_of_existing_cards
1450: FROM MTL_KANBAN_CARDS
1451: WHERE pull_sequence_id = X_Pull_sequence_id
1452: AND (card_status = INV_Kanban_PVT.G_Card_Status_Active or
1453: card_status = INV_Kanban_PVT.G_Card_Status_Hold)
1454: /*Added these 2 where clauses by javakat to fix 11829018*/