[Home] [Help]
557: case when trunc(mkca.creation_date+mkps.replenishment_lead_time) < l_plan_start_date then l_plan_start_date
558: else trunc(mkca.creation_date+mkps.replenishment_lead_time) end )) expected_date,
559: min(mrp_calendar.NEXT_WORK_DAY(mkps.organization_id,1,trunc(mkca.creation_date))) replenished_date
560: from mtl_kanban_card_activity mkca,
561: mtl_kanban_cards mkc,
562: mtl_kanban_pull_sequences mkps,
563: mtl_kanban_pull_sequences plan
564: where mkps.organization_id = plan.organization_id
565: and mkps.inventory_item_id = plan.inventory_item_id
1206: l_temp_count number;
1207: Begin
1208: select count(1)
1209: into l_temp_count
1210: from mtl_kanban_cards
1211: where pull_sequence_id = p_pull_sequence_id and
1212: card_status in (1,2) and ( disable_date is not null or max_replenishments is not null);
1213:
1214: return l_temp_count;
1420: case when trunc(mkca.creation_date+mkps.replenishment_lead_time) < l_start_date then l_start_date
1421: else trunc(mkca.creation_date+mkps.replenishment_lead_time) end)) expected_date,
1422: min(mrp_calendar.NEXT_WORK_DAY(mkps.organization_id,1,trunc(mkca.creation_date))) replenished_date
1423: from mtl_kanban_card_activity mkca,
1424: mtl_kanban_cards mkc,
1425: mtl_kanban_pull_sequences mkps,
1426: mtl_kanban_pull_sequences plan
1427: where mkps.organization_id = plan.organization_id
1428: and mkps.inventory_item_id = plan.inventory_item_id
1861: -- Generate Plan cards as required.
1862: if l_calc_flag = 2 then -- Calculate cards. Also exclude Temporary cards.
1863: select count(1)
1864: into l_curr_card_count
1865: from mtl_kanban_cards
1866: where pull_sequence_id = l_prod_pull_seq_id
1867: and max_replenishments is null
1868: and disable_date is null
1869: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable
1970: -- Convert Plan cards into Active if needed.
1971: if l_eff_date is null then
1972: select count(1)
1973: into l_curr_card_count
1974: from mtl_kanban_cards
1975: where pull_sequence_id = l_prod_pull_seq_id
1976: and max_replenishments is null
1977: and disable_date is null
1978: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable
2072: , l_kanban_card_rec.replenishment_count
2073: , l_kanban_card_rec.max_replenishments
2074: , l_kanban_card_rec.disable_date
2075: , l_kanban_card_rec.replacement_flag
2076: from mtl_kanban_cards
2077: where pull_sequence_id = l_prod_pull_seq_id
2078: and card_status = INV_Kanban_PVT.G_Card_Status_Planned
2079: and max_replenishments is null
2080: and disable_date is null
2324: -- Generate Plan cards as required. Also exclude Temporary cards.
2325: if l_calc_flag = 2 then -- Calculate cards
2326: select count(1)
2327: into l_curr_card_count
2328: from mtl_kanban_cards
2329: where pull_sequence_id = l_prod_pull_seq_id
2330: and max_replenishments is null
2331: and disable_date is null
2332: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable
2431: -- Convert Plan cards into Active if needed.
2432: if l_eff_date is null then
2433: select count(1)
2434: into l_curr_card_count
2435: from mtl_kanban_cards
2436: where pull_sequence_id = l_prod_pull_seq_id
2437: and max_replenishments is null
2438: and disable_date is null
2439: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable
2532: , l_kanban_card_rec.replenishment_count
2533: , l_kanban_card_rec.max_replenishments
2534: , l_kanban_card_rec.disable_date
2535: , l_kanban_card_rec.replacement_flag
2536: from mtl_kanban_cards
2537: where pull_sequence_id = l_prod_pull_seq_id
2538: and card_status = INV_Kanban_PVT.G_Card_Status_Planned
2539: and max_replenishments is null
2540: and disable_date is null