eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FLM_KANBAN_PLANNING_UTIL dependencies on MTL_KANBAN_PULL_SEQUENCES

Line 177: where descriptive_flexfield_name = 'MTL_KANBAN_PULL_SEQUENCES'

173: procedure set_flexfields_prompt
174: is
175: cursor flexfield_defn is
176: select application_column_name col_name,form_left_prompt prompt from FND_DESCR_FLEX_COL_USAGE_TL
177: where descriptive_flexfield_name = 'MTL_KANBAN_PULL_SEQUENCES'
178: and language = userenv('LANG')
179: and descriptive_flex_context_code = 'Global Data Elements';
180: Begin
181:

Line 357: select MTL_KANBAN_PULL_SEQUENCES_S.NEXTVAL into l_pull_seq_id from dual;

353: x_pull_sequence_id out nocopy number )
354: is
355: l_pull_seq_id Number;
356: Begin
357: select MTL_KANBAN_PULL_SEQUENCES_S.NEXTVAL into l_pull_seq_id from dual;
358:
359: INSERT INTO MTL_KANBAN_PULL_SEQUENCES
360: (Pull_sequence_id,
361: Inventory_item_id,

Line 359: INSERT INTO MTL_KANBAN_PULL_SEQUENCES

355: l_pull_seq_id Number;
356: Begin
357: select MTL_KANBAN_PULL_SEQUENCES_S.NEXTVAL into l_pull_seq_id from dual;
358:
359: INSERT INTO MTL_KANBAN_PULL_SEQUENCES
360: (Pull_sequence_id,
361: Inventory_item_id,
362: Organization_id,
363: Subinventory_name,

Line 438: from MTL_KANBAN_PULL_SEQUENCES

434: Attribute15,
435: FUTURE_NO_OF_CARDS,
436: FUTURE_CARD_SIZE,
437: PLANNING_EFFECTIVITY
438: from MTL_KANBAN_PULL_SEQUENCES
439: where pull_sequence_id = p_pull_sequence_id;
440:
441: x_pull_sequence_id := l_pull_seq_id;
442: Exception

Line 515: update MTL_KANBAN_PULL_SEQUENCES

511: l_org_id Number;
512: l_new_date Date;
513: Begin
514:
515: update MTL_KANBAN_PULL_SEQUENCES
516: set Number_of_cards = decode(Calculate_Kanban_flag,2,FLM_KANBAN_PLANNING_UTIL.GET_CALCULATED_CARDS(PULL_SEQUENCE_ID,CALCULATE_KANBAN_FLAG,
517: KANBAN_SIZE,AVG_DEPENDENT_DEMAND,ALLOCATION_PERCENT,REPLENISHMENT_LEAD_TIME,SAFETY_STOCK_DAYS,
518: MINIMUM_ORDER_QUANTITY,FIXED_LOT_MULTIPLIER),number_of_cards ),
519: Kanban_size = decode(Calculate_Kanban_flag,1,FLM_KANBAN_PLANNING_UTIL.GET_CALCULATED_SIZE(PULL_SEQUENCE_ID,CALCULATE_KANBAN_FLAG,NUMBER_OF_CARDS,

Line 533: from FLM_EKB_HORIZONTAL_PLAN_TEMP HP,MTL_KANBAN_PULL_SEQUENCES PS

529: where UPDATED_FLAG = p_request_id;
530:
531: select min(HP.plan_date),max(HP.plan_date), min(HP.organization_id)
532: into l_plan_start_date,l_plan_end_date, l_org_id
533: from FLM_EKB_HORIZONTAL_PLAN_TEMP HP,MTL_KANBAN_PULL_SEQUENCES PS
534: where HP.PULL_SEQUENCE_ID = PS.PULL_SEQUENCE_ID
535: and PS.UPDATED_FLAG = p_request_id;
536:
537: v_exp_date.delete;

Line 562: mtl_kanban_pull_sequences mkps,

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
566: and mkps.subinventory_name = plan.subinventory_name

Line 563: mtl_kanban_pull_sequences plan

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
566: and mkps.subinventory_name = plan.subinventory_name
567: and nvl(mkps.locator_id,-100) = nvl(plan.locator_id,-100)

Line 598: MTL_KANBAN_PULL_SEQUENCES PS

594: nvl(ceil(PS.REPLENISHMENT_LEAD_TIME),0) REPLENISHMENT_LEAD_TIME,decode( nvl(PS.KANBAN_SIZE,0),0,1,PS.KANBAN_SIZE),
595: trunc(HP.PLAN_DATE),0 CARDS_REPLENISHED
596: bulk collect into v_planning_temp_tbl
597: from FLM_EKB_HORIZONTAL_PLAN_TEMP HP,
598: MTL_KANBAN_PULL_SEQUENCES PS
599: where HP.PULL_SEQUENCE_ID = PS.PULL_SEQUENCE_ID
600: and PS.UPDATED_FLAG = p_request_id
601: order by HP.PULL_SEQUENCE_ID,HP.plan_date;
602:

Line 610: from mtl_kanban_pull_sequences mkps

606: while l_counter <= v_planning_temp_tbl.last loop
607: if nvl(l_prev_pull_seq,0) <> v_planning_temp_tbl(l_counter).PULL_SEQUENCE_ID then
608: select decode(nvl(kanban_size,0),0,1,kanban_size),decode(nvl(number_of_cards,0),0,1,number_of_cards),kanban_plan_id
609: into l_kanban_size,l_no_of_cards,l_kanban_plan_id
610: from mtl_kanban_pull_sequences mkps
611: where PULL_SEQUENCE_ID = v_planning_temp_tbl(l_counter).PULL_SEQUENCE_ID;
612: end if;
613: if nvl(v_planning_temp_tbl(l_counter).DAILY_DEMAND,-1) <> nvl(v_planning_temp_tbl(l_counter).AVG_DEPENDENT_DEMAND,-2) and
614: nvl(v_planning_temp_tbl(l_counter).AVG_DEPENDENT_DEMAND,-1) <> 0 and l_kanban_plan_id = 0 then

Line 735: delete from MTL_KANBAN_PULL_SEQUENCES

731: Begin
732:
733: if p_kanban_plan = -1 then
734:
735: delete from MTL_KANBAN_PULL_SEQUENCES
736: where inventory_item_id = p_item_id and
737: organization_id = p_org_id and
738: Subinventory_name = p_subinv and
739: Locator_id = p_locator and

Line 842: exists (select 1 from mtl_kanban_pull_sequences mkps

838: and (organization_id = p_organization_id or
839: organization_code = (select mp.organization_code
840: from mtl_parameters mp
841: where mp.organization_id = p_organization_id) or
842: exists (select 1 from mtl_kanban_pull_sequences mkps
843: where mkps.organization_id = p_organization_id and
844: mkps.pull_sequence_id = fedi.pull_sequence_id and rownum = 1 ));
845:
846: open running_intf_records(p_organization_id);

Line 953: from mtl_kanban_pull_sequences where pull_sequence_id = l_flm_kanban_demand_intf(l_counter).PULL_SEQUENCE_ID

949: into l_flm_kanban_demand_intf(l_counter).organization_id,
950: l_flm_kanban_demand_intf(l_counter).inventory_item_id,
951: l_flm_kanban_demand_intf(l_counter).subinventory,
952: l_flm_kanban_demand_intf(l_counter).locator_id
953: from mtl_kanban_pull_sequences where pull_sequence_id = l_flm_kanban_demand_intf(l_counter).PULL_SEQUENCE_ID
954: and organization_id = l_flm_kanban_demand_intf(l_counter).organization_id
955: and kanban_plan_id = -1;
956: exception
957: when others then

Line 1048: FROM mtl_kanban_pull_sequences

1044: end;
1045: end if;
1046: begin
1047: select pull_sequence_id into l_flm_kanban_demand_intf(l_counter).PULL_SEQUENCE_ID
1048: FROM mtl_kanban_pull_sequences
1049: WHERE organization_id = l_flm_kanban_demand_intf(l_counter).organization_id
1050: AND inventory_item_id = l_flm_kanban_demand_intf(l_counter).inventory_item_id
1051: and subinventory_name = l_flm_kanban_demand_intf(l_counter).subinventory
1052: and nvl(locator_id,-1) = nvl(l_flm_kanban_demand_intf(l_counter).locator_id,-1)

Line 1196: select MTL_KANBAN_PULL_SEQUENCES_S.NEXTVAL

1192: Return Number
1193: is
1194: l_next_pull_seq_id Number;
1195: Begin
1196: select MTL_KANBAN_PULL_SEQUENCES_S.NEXTVAL
1197: into l_next_pull_seq_id
1198: from dual;
1199:
1200: return l_next_pull_seq_id;

Line 1323: l_sql := 'delete from MTL_KANBAN_PULL_SEQUENCES mkps1 where mkps1.Kanban_Plan_id = 0 and mkps1.pull_sequence_id in'||

1319: l_new_date Date;
1320: Begin
1321: l_value := trunc(dbms_random.value(0,999999999999));
1322: if p_kanban_plan_id = -1 then
1323: l_sql := 'delete from MTL_KANBAN_PULL_SEQUENCES mkps1 where mkps1.Kanban_Plan_id = 0 and mkps1.pull_sequence_id in'||
1324: '(select syspullseq.pull_sequence_id from MTL_KANBAN_PULL_SEQUENCES syspullseq, MTL_KANBAN_PULL_SEQUENCES prodpullSeq'||
1325: ' where syspullseq.kanban_plan_id = 0 and prodpullSeq.kanban_plan_id = -1 '||
1326: ' and syspullseq.organization_id = prodpullSeq.organization_id '||
1327: ' and syspullseq.inventory_item_id = prodpullSeq.inventory_item_id '||

Line 1324: '(select syspullseq.pull_sequence_id from MTL_KANBAN_PULL_SEQUENCES syspullseq, MTL_KANBAN_PULL_SEQUENCES prodpullSeq'||

1320: Begin
1321: l_value := trunc(dbms_random.value(0,999999999999));
1322: if p_kanban_plan_id = -1 then
1323: l_sql := 'delete from MTL_KANBAN_PULL_SEQUENCES mkps1 where mkps1.Kanban_Plan_id = 0 and mkps1.pull_sequence_id in'||
1324: '(select syspullseq.pull_sequence_id from MTL_KANBAN_PULL_SEQUENCES syspullseq, MTL_KANBAN_PULL_SEQUENCES prodpullSeq'||
1325: ' where syspullseq.kanban_plan_id = 0 and prodpullSeq.kanban_plan_id = -1 '||
1326: ' and syspullseq.organization_id = prodpullSeq.organization_id '||
1327: ' and syspullseq.inventory_item_id = prodpullSeq.inventory_item_id '||
1328: ' and syspullseq.Subinventory_name = prodpullSeq.Subinventory_name '||

Line 1334: l_sql := 'INSERT INTO MTL_KANBAN_PULL_SEQUENCES (Pull_sequence_id,Inventory_item_id,Organization_id,Subinventory_name,Kanban_Plan_id,'||

1330: ' and prodpullSeq.pull_sequence_id in ( '|| p_pull_seq_ids || ' )) ';
1331: execute immediate l_sql;
1332: l_kanban_plan_id := 0;
1333:
1334: l_sql := 'INSERT INTO MTL_KANBAN_PULL_SEQUENCES (Pull_sequence_id,Inventory_item_id,Organization_id,Subinventory_name,Kanban_Plan_id,'||
1335: 'Source_type,Last_Update_Date,Last_Updated_By,Creation_Date,Created_By,Last_Update_Login,Locator_id,Calculate_Kanban_flag,'||
1336: 'Kanban_size,Number_of_cards,Minimum_order_quantity,Allocation_Percent,Replenishment_lead_time,Fixed_Lot_multiplier,'||
1337: 'Safety_Stock_Days,Attribute_Category,Attribute1,Attribute2,Attribute3,Attribute4,Attribute5,Attribute6,Attribute7,Attribute8,'||
1338: 'Attribute9,Attribute10,Attribute11,Attribute12,Attribute13,Attribute14,Attribute15,'||

Line 1340: 'select MTL_KANBAN_PULL_SEQUENCES_S.NEXTVAL,Inventory_item_id,Organization_id,Subinventory_name,0,'||

1336: 'Kanban_size,Number_of_cards,Minimum_order_quantity,Allocation_Percent,Replenishment_lead_time,Fixed_Lot_multiplier,'||
1337: 'Safety_Stock_Days,Attribute_Category,Attribute1,Attribute2,Attribute3,Attribute4,Attribute5,Attribute6,Attribute7,Attribute8,'||
1338: 'Attribute9,Attribute10,Attribute11,Attribute12,Attribute13,Attribute14,Attribute15,'||
1339: 'PLANNING_EFFECTIVITY,UPDATED_FLAG, RELEASE_KANBAN_FLAG,AVG_DEPENDENT_DEMAND,FUTURE_CARD_SIZE,FUTURE_NO_OF_CARDS)'||
1340: 'select MTL_KANBAN_PULL_SEQUENCES_S.NEXTVAL,Inventory_item_id,Organization_id,Subinventory_name,0,'||
1341: 'Source_type,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.login_id,Locator_id,Calculate_Kanban_flag,'||
1342: 'decode(Calculate_Kanban_flag,1,FLM_KANBAN_PLANNING_UTIL.GET_CALCULATED_SIZE(PULL_SEQUENCE_ID,CALCULATE_KANBAN_FLAG,NUMBER_OF_CARDS,'||
1343: 'nvl(FLM_KANBAN_PLANNING_UTIL.get_average_demand(Organization_id,0,Inventory_item_id,Subinventory_name,Locator_id),nvl(AVG_DEPENDENT_DEMAND,0)),ALLOCATION_PERCENT,'||
1344: 'REPLENISHMENT_LEAD_TIME,SAFETY_STOCK_DAYS,MINIMUM_ORDER_QUANTITY,FIXED_LOT_MULTIPLIER),Kanban_size),'||

Line 1359: ' from MTL_KANBAN_PULL_SEQUENCES where pull_sequence_id in ('||p_pull_seq_ids||')' ;

1355: 'ALLOCATION_PERCENT,REPLENISHMENT_LEAD_TIME,SAFETY_STOCK_DAYS,MINIMUM_ORDER_QUANTITY,FIXED_LOT_MULTIPLIER),Kanban_size),'||
1356: 'decode(Calculate_Kanban_flag,2,FLM_KANBAN_PLANNING_UTIL.GET_CALCULATED_CARDS(PULL_SEQUENCE_ID,CALCULATE_KANBAN_FLAG,KANBAN_SIZE,'||
1357: 'nvl(FLM_KANBAN_PLANNING_UTIL.get_average_demand(Organization_id,0,Inventory_item_id,Subinventory_name,Locator_id),nvl(AVG_DEPENDENT_DEMAND,0)),'||
1358: 'ALLOCATION_PERCENT,REPLENISHMENT_LEAD_TIME,SAFETY_STOCK_DAYS,MINIMUM_ORDER_QUANTITY,FIXED_LOT_MULTIPLIER),Number_of_cards)'||
1359: ' from MTL_KANBAN_PULL_SEQUENCES where pull_sequence_id in ('||p_pull_seq_ids||')' ;
1360: else
1361: l_kanban_plan_id := p_kanban_plan_id;
1362: l_sql := 'update MTL_KANBAN_PULL_SEQUENCES set UPDATED_FLAG = '||l_value||
1363: ',FUTURE_NO_OF_CARDS = Number_of_cards,FUTURE_CARD_SIZE= Kanban_size where pull_sequence_id in ('||p_pull_seq_ids||')';

Line 1362: l_sql := 'update MTL_KANBAN_PULL_SEQUENCES set UPDATED_FLAG = '||l_value||

1358: 'ALLOCATION_PERCENT,REPLENISHMENT_LEAD_TIME,SAFETY_STOCK_DAYS,MINIMUM_ORDER_QUANTITY,FIXED_LOT_MULTIPLIER),Number_of_cards)'||
1359: ' from MTL_KANBAN_PULL_SEQUENCES where pull_sequence_id in ('||p_pull_seq_ids||')' ;
1360: else
1361: l_kanban_plan_id := p_kanban_plan_id;
1362: l_sql := 'update MTL_KANBAN_PULL_SEQUENCES set UPDATED_FLAG = '||l_value||
1363: ',FUTURE_NO_OF_CARDS = Number_of_cards,FUTURE_CARD_SIZE= Kanban_size where pull_sequence_id in ('||p_pull_seq_ids||')';
1364: end if;
1365: execute immediate l_sql;
1366: -- Generate Horizontal Plan Data.

Line 1373: mtl_kanban_pull_sequences mkps

1369: mkps.Safety_Stock_Days,decode(nvl(mkps.Kanban_size,0),0,1,mkps.Kanban_size) Kanban_size,decode(nvl(mkps.Number_of_cards,0),0,1,Number_of_cards) Number_of_cards,
1370: mkps.avg_dependent_demand,nvl(sum(nvl(moqd.primary_transaction_quantity,0)),0),nvl(ceil(mkps.replenishment_lead_time),0)
1371: bulk collect into v_plan_pull_seq_tbl
1372: FROM mtl_onhand_quantities_detail moqd,
1373: mtl_kanban_pull_sequences mkps
1374: WHERE moqd.inventory_item_id(+) = mkps.inventory_item_id
1375: AND moqd.organization_id(+) = mkps.organization_id
1376: AND moqd.subinventory_code(+) = mkps.subinventory_name
1377: and nvl(moqd.locator_id(+),-100) = nvl(mkps.locator_id,-100)

Line 1425: mtl_kanban_pull_sequences mkps,

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
1429: and mkps.subinventory_name = plan.subinventory_name

Line 1426: mtl_kanban_pull_sequences plan

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
1429: and mkps.subinventory_name = plan.subinventory_name
1430: and nvl(mkps.locator_id,-100) = nvl(plan.locator_id,-100)

Line 1465: mtl_kanban_pull_sequences plan

1461: bulk collect into v_dem_pull_seq_id,
1462: v_demand_date,
1463: v_demand_qty
1464: from mrp_kanban_demand mkd,
1465: mtl_kanban_pull_sequences plan
1466: where mkd.kanban_plan_id = l_kanban_plan_id
1467: and mkd.organization_id = plan.organization_id
1468: and mkd.inventory_item_id = plan.inventory_item_id
1469: and mkd.subinventory = plan.subinventory_name

Line 1701: 'from mtl_kanban_pull_sequences plan,mtl_kanban_pull_sequences prod '||

1697: 'plan.LAST_IMPLEMENTED_PLAN,plan.plan_start_date,plan.plan_end_date,prod.pull_sequence_id, '||
1698: 'plan.avg_dependent_demand,plan.minimum_order_quantity,plan.allocation_percent,plan.replenishment_lead_time,plan.fixed_lot_multiplier,plan.safety_stock_days, '||
1699: 'plan.attribute1,plan.attribute2,plan.attribute3,plan.attribute4,plan.attribute5,plan.attribute6,plan.attribute7,plan.attribute8, '||
1700: 'plan.attribute9,plan.attribute10,plan.attribute11,plan.attribute12,plan.attribute13,plan.attribute14,plan.attribute15,prod.release_kanban_flag '||
1701: 'from mtl_kanban_pull_sequences plan,mtl_kanban_pull_sequences prod '||
1702: 'where plan.pull_sequence_id in ( '||p_plan_pull_seq_ids||' ) '||
1703: 'and plan.organization_id = prod.organization_id '||
1704: 'and plan.inventory_item_id = prod.inventory_item_id '||
1705: 'and plan.subinventory_name = prod.subinventory_name '||

Line 1808: update mtl_kanban_pull_sequences

1804: l_card_size := null;
1805: end if;
1806:
1807: -- Update Planning Pull sequence
1808: update mtl_kanban_pull_sequences
1809: set future_no_of_cards = Number_of_cards,
1810: future_card_size = Kanban_size,
1811: planning_effectivity = null,
1812: no_of_temp_cards = null,

Line 1818: update mtl_kanban_pull_sequences

1814: temp_expiry_date = null
1815: where pull_sequence_id = l_plan_pull_seq_id;
1816:
1817: -- Update Production pull sequence
1818: update mtl_kanban_pull_sequences
1819: set number_of_cards = decode(Calculate_Kanban_flag,2,nvl(l_no_of_cards,number_of_cards),number_of_cards),
1820: future_no_of_cards = decode(l_eff_date,null,null,nvl(l_future_cards,number_of_cards)),
1821: kanban_size = decode(Calculate_Kanban_flag,1,nvl(l_card_size,kanban_size),kanban_size),
1822: future_card_size = decode(l_eff_date,null,null,nvl(l_future_size,kanban_size)),

Line 1877: FROM MTL_KANBAN_PULL_SEQUENCES

1873: if l_curr_card_count < l_calculate_card_count then
1874:
1875: SELECT INVENTORY_ITEM_ID,ORGANIZATION_ID,SUBINVENTORY_NAME,SOURCE_TYPE,LOCATOR_ID,SOURCE_ORGANIZATION_ID,SOURCE_SUBINVENTORY,SOURCE_LOCATOR_ID,WIP_LINE_ID
1876: INTO l_item_id,l_org_id,l_subinv,l_src_type,l_locator,l_src_org_id,l_src_subinv,l_src_locator,l_wip_line_id
1877: FROM MTL_KANBAN_PULL_SEQUENCES
1878: WHERE PULL_SEQUENCE_ID = l_prod_pull_seq_id;
1879:
1880: while (l_card_count < (l_calculate_card_count - l_curr_card_count))
1881: loop

Line 2237: from mtl_kanban_pull_sequences plan,mtl_kanban_pull_sequences prod

2233: into l_plan_pull_seq_id,l_no_of_cards,l_card_size,l_calc_flag,l_eff_date,l_no_of_temp_cards,l_no_of_cycles,
2234: l_temp_exp_date,l_imp_plan,l_plan_st_dt,l_plan_end_dt,l_prod_pull_seq_id, l_avg_demand, l_moq, l_alloc_perc,
2235: l_lead_time,l_lot_multiplier,l_safety_stock, l_attr_1, l_attr_2, l_attr_3, l_attr_4, l_attr_5, l_attr_6, l_attr_7,
2236: l_attr_8, l_attr_9, l_attr_10, l_attr_11, l_attr_12, l_attr_13, l_attr_14, l_attr_15,l_release_kanban_flag
2237: from mtl_kanban_pull_sequences plan,mtl_kanban_pull_sequences prod
2238: where plan.pull_sequence_id = p_plan_pull_seq_id
2239: and plan.organization_id = prod.organization_id
2240: and plan.inventory_item_id = prod.inventory_item_id
2241: and plan.subinventory_name = prod.subinventory_name

Line 2270: update mtl_kanban_pull_sequences

2266:
2267: end if;
2268:
2269: -- Update Planning Pull sequence
2270: update mtl_kanban_pull_sequences
2271: set future_no_of_cards = Number_of_cards,
2272: future_card_size = Kanban_size,
2273: planning_effectivity = null,
2274: no_of_temp_cards = null,

Line 2280: update mtl_kanban_pull_sequences

2276: temp_expiry_date = null
2277: where pull_sequence_id = l_plan_pull_seq_id;
2278:
2279: -- Update Production pull sequence
2280: update mtl_kanban_pull_sequences
2281: set number_of_cards = decode(Calculate_Kanban_flag,2,nvl(l_no_of_cards,number_of_cards),number_of_cards),
2282: future_no_of_cards = decode(l_eff_date,null,null,nvl(l_future_cards,number_of_cards)),
2283: kanban_size = decode(Calculate_Kanban_flag,1,nvl(l_card_size,kanban_size),kanban_size),
2284: future_card_size = decode(l_eff_date,null,null,nvl(l_future_size,kanban_size)),

Line 2340: FROM MTL_KANBAN_PULL_SEQUENCES

2336: if l_curr_card_count < l_calculate_card_count then
2337:
2338: SELECT INVENTORY_ITEM_ID,ORGANIZATION_ID,SUBINVENTORY_NAME,SOURCE_TYPE,LOCATOR_ID,SOURCE_ORGANIZATION_ID,SOURCE_SUBINVENTORY,SOURCE_LOCATOR_ID,WIP_LINE_ID
2339: INTO l_item_id,l_org_id,l_subinv,l_src_type,l_locator,l_src_org_id,l_src_subinv,l_src_locator,l_wip_line_id
2340: FROM MTL_KANBAN_PULL_SEQUENCES
2341: WHERE PULL_SEQUENCE_ID = l_prod_pull_seq_id;
2342: while (l_card_count < (l_calculate_card_count - l_curr_card_count))
2343: loop
2344: l_card_count := l_card_count+1;