APPS.FLM_KANBAN_PUB dependencies on MTL_KANBAN_CARDS

Line 78: from mtl_kanban_cards

74: select kanban_card_id
75: ,kanban_card_number
76: into l_card_id
77: ,l_card_number
78: from mtl_kanban_cards
79: where pull_sequence_id = p_pull_sequence_id
80: and kanban_card_id = NVL(p_kanban_card_id,kanban_card_id)
81: and kanban_card_number = NVL(p_kanban_card_number,kanban_card_number);
82:

Line 1743: FROM MTL_KANBAN_CARDS MKC

1739: --Cursor to Kanban Card count
1740: CURSOR c_cards_cnt(p_pull_sequence_id IN NUMBER)
1741: IS
1742: SELECT COUNT(MKC.kanban_card_id)
1743: FROM MTL_KANBAN_CARDS MKC
1744: WHERE MKC.pull_sequence_id = p_pull_sequence_id
1745: AND MKC.card_status IN (INV_Kanban_PVT.G_Card_Status_Active, INV_Kanban_PVT.G_Card_Status_Hold);
1746:
1747: --Cursor to validate Kanban Card Id

Line 1753: FROM MTL_KANBAN_CARDS MTC

1749: IS
1750: SELECT kanban_card_id
1751: ,card_status
1752: ,supply_status
1753: FROM MTL_KANBAN_CARDS MTC
1754: WHERE MTC.kanban_card_id = p_kanban_card_id;
1755:
1756: -- Cursor to get the card count
1757:

Line 2273: FROM MTL_KANBAN_CARDS MKC

2269: ,r_kanban_card_rec.attribute13
2270: ,r_kanban_card_rec.attribute14
2271: ,r_kanban_card_rec.attribute15
2272: ,r_kanban_card_rec.last_print_date
2273: FROM MTL_KANBAN_CARDS MKC
2274: WHERE MKC.kanban_card_id = l_card_id;
2275: END IF;
2276:
2277: IF l_card_sts = INV_Kanban_PVT.G_Card_Status_Cancel THEN

Line 2658: from mtl_kanban_cards

2654: -- Also Validate VAlue from Hook.
2655: if r_kanban_card_rec.kanban_card_number is not null then
2656: Begin
2657: select 1 into l_temp
2658: from mtl_kanban_cards
2659: where organization_id = r_kanban_card_rec.organization_id
2660: and kanban_card_number = r_kanban_card_rec.kanban_card_number;
2661:
2662: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_EXISTS');

Line 2749: FROM MTL_KANBAN_CARDS MTC

2745: mydebug('Transaction Type UPDATE');
2746: SELECT MTC.supply_status
2747: ,MTC.card_status
2748: INTO l_supply_status, l_card_status
2749: FROM MTL_KANBAN_CARDS MTC
2750: WHERE MTC.kanban_card_id = r_kanban_card_rec.kanban_card_id;
2751:
2752: IF (SQL%NOTFOUND) THEN
2753: l_error_msg := 'Eror while fetching Card Details ';

Line 3625: UPDATE MTL_KANBAN_CARDS

3621: mydebug('l_ret_status='||l_ret_status);
3622:
3623: IF l_ret_status = FND_API.G_RET_STS_SUCCESS THEN
3624: -- Set replacement flag on cards when pull seq is updated.
3625: UPDATE MTL_KANBAN_CARDS
3626: SET replacement_flag = 1
3627: WHERE source_type <> l_pull_sequence_rec.source_type
3628: AND source_subinventory <> l_pull_sequence_rec.source_subinventory
3629: AND source_locator_id <> l_pull_sequence_rec.source_locator_id

Line 4501: FROM MTL_KANBAN_CARDS

4497: l_kanban_card_id number;
4498: begin
4499: SELECT kanban_card_id
4500: INTO l_kanban_card_id
4501: FROM MTL_KANBAN_CARDS
4502: WHERE pull_sequence_id = p_pull_sequence_id
4503: AND kanban_card_number = p_kanban_card_number;
4504:
4505: RETURN l_kanban_card_id;