[Home] [Help]
344:
345: --=================== Net Change Mode: Delete ==================
346: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
347:
348: MSC_CL_PULL.v_table_name:= 'MSC_ST_BOMS';
349: MSC_CL_PULL.v_view_name := 'MRP_AD_BOMS_V';
350:
351: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
352: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
354: v_temp_sql := NULL;
355: END IF;
356:
357: v_sql_stmt:=
358: ' insert into MSC_ST_BOMS'
359: ||' ( BILL_SEQUENCE_ID,'
360: ||' DELETED_FLAG,'
361: ||' REFRESH_ID,'
362: ||' SR_INSTANCE_ID)'
375:
376: END IF;
377:
378:
379: MSC_CL_PULL.v_table_name:= 'MSC_ST_BOMS';
380: MSC_CL_PULL.v_view_name := 'MRP_AP_BOMS_V';
381:
382: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
383:
406: END IF;
407:
408:
409: v_sql_stmt:=
410: ' insert into MSC_ST_BOMS'
411: ||' ( BILL_SEQUENCE_ID,'
412: ||' ORGANIZATION_ID,'
413: ||' ASSEMBLY_ITEM_ID,'
414: ||' ASSEMBLY_TYPE,'
2555: wsc.split,
2556: decode(nvl(wsc.primary_flag,''N''),''N'',2,1) primary_flag,
2557: bom.rowid
2558: from wsm_Co_products'||MSC_CL_PULL.v_dblink||' wsc,
2559: msc_st_boms bom
2560: where wsc.bill_sequence_id is not null
2561: and wsc.split > 0 -- Added this for bug:2208074
2562: and wsc.bill_Sequence_id*2 = bom.bill_Sequence_id';
2563:
2587: decode(nvl(wsc.primary_flag,''N''),''N'',2,1) primary_flag,
2588: bom.rowid
2589: from wsm_Co_products'||MSC_CL_PULL.v_dblink||' wsc,
2590: wsm_coproduct_split_perc'||MSC_CL_PULL.v_dblink||' perc,
2591: msc_st_boms bom
2592: where wsc.bill_sequence_id is not null
2593: and wsc.bill_Sequence_id*2 = bom.bill_Sequence_id
2594: and perc.co_product_group_id = wsc.co_product_group_id
2595: and perc.co_product_id = wsc.co_product_id
2700: and rownum = 1;
2701:
2702: End loop;
2703:
2704: update msc_st_boms
2705: set assembly_quantity = (l_split/100)
2706: where rowid = l_rowid;
2707:
2708: ENd loop;