[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,'
2609: perc.effectivity_date, -- Added for BUG 14133049/13530488
2610: decode(nvl(wsc.primary_flag,''N''),''N'',2,1) primary_flag,
2611: bom.rowid
2612: from wsm_Co_products'||MSC_CL_PULL.v_dblink||' wsc,
2613: msc_st_boms bom
2614: where wsc.bill_sequence_id is not null
2615: and wsc.split > 0 -- Added this for bug:2208074
2616: and wsc.bill_Sequence_id*2 = bom.bill_Sequence_id';
2617:
2645: decode(nvl(wsc.primary_flag,''N''),''N'',2,1) primary_flag,
2646: bom.rowid
2647: from wsm_Co_products'||MSC_CL_PULL.v_dblink||' wsc,
2648: wsm_coproduct_split_perc'||MSC_CL_PULL.v_dblink||' perc,
2649: msc_st_boms bom
2650: where wsc.bill_sequence_id is not null
2651: and wsc.bill_Sequence_id*2 = bom.bill_Sequence_id
2652: and perc.co_product_group_id = wsc.co_product_group_id
2653: and perc.co_product_id = wsc.co_product_id
2751: and rownum = 1;
2752:
2753: End loop;
2754:
2755: update msc_st_boms
2756: set assembly_quantity = (l_split/100)
2757: where rowid = l_rowid;
2758:
2759: ENd loop;