[Home] [Help]
2193: BEGIN
2194: UPDATE gmf_fiscal_policies a
2195: SET a.cost_type_id = (
2196: SELECT x.cost_type_id
2197: FROM cm_mthd_mst x
2198: WHERE x.cost_mthd_code = a.gl_cost_mthd
2199: )
2200: WHERE a.cost_type_id IS NULL AND a.gl_cost_mthd IS NOT NULL;
2201:
2376: * Migrate_Cost_Methods *
2377: * *
2378: * DESCRIPTION: *
2379: * This PL/SQL procedure is used to transform the Cost Methods *
2380: * data in CM_MTHD_MST *
2381: * *
2382: * PARAMETERS: *
2383: * P_migration_run_id - id to use to right to migration log *
2384: * x_exception_count - Number of exceptions occurred. *
2410:
2411: BEGIN
2412:
2413: G_Migration_run_id := P_migration_run_id;
2414: G_Table_name := 'CM_MTHD_MST';
2415: G_Context := 'Cost Types Migration';
2416: X_failure_count := 0;
2417:
2418: /********************************
2433: /*****************************************
2434: * Update rows For Cost Type Identifier *
2435: *****************************************/
2436:
2437: UPDATE cm_mthd_mst
2438: SET cost_type_id = gmf_cost_type_id_s.NEXTVAL
2439: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL);
2440:
2441: /**********************************************
2443: **********************************************/
2444:
2445: SELECT count(*)
2446: INTO x_failure_count
2447: FROM cm_mthd_mst
2448: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL);
2449:
2450: IF nvl(x_failure_count,0) > 0 THEN
2451:
2538: * Migrate_Lot_Cost_Methods *
2539: * *
2540: * DESCRIPTION: *
2541: * This PL/SQL procedure is used to transform the Lot Cost Methods *
2542: * data in CM_MTHD_MST *
2543: * *
2544: * PARAMETERS: *
2545: * P_migration_run_id - id to use to right to migration log *
2546: * x_exception_count - Number of exceptions occurred. *
2576:
2577: BEGIN
2578:
2579: G_Migration_run_id := P_migration_run_id;
2580: G_Table_name := 'CM_MTHD_MST';
2581: G_Context := 'Lot Cost Types Migration';
2582: X_failure_count := 0;
2583:
2584: /********************************
2596: p_app_short_name => 'GMA'
2597: );
2598:
2599: /*********************************************
2600: * Update a row in cm_mthd_mst for Lot Costs *
2601: *********************************************/
2602: BEGIN
2603:
2604: UPDATE cm_mthd_mst a
2600: * Update a row in cm_mthd_mst for Lot Costs *
2601: *********************************************/
2602: BEGIN
2603:
2604: UPDATE cm_mthd_mst a
2605: SET a.default_lot_cost_type_id = (
2606: SELECT x.cost_type_id
2607: FROM cm_mthd_mst x
2608: WHERE x.cost_mthd_code = a.default_lot_cost_mthd
2603:
2604: UPDATE cm_mthd_mst a
2605: SET a.default_lot_cost_type_id = (
2606: SELECT x.cost_type_id
2607: FROM cm_mthd_mst x
2608: WHERE x.cost_mthd_code = a.default_lot_cost_mthd
2609: ),
2610: a.cost_type = 6,
2611: a.lot_actual_cost = NULL
2659: **********************************************/
2660:
2661: SELECT count(*)
2662: INTO x_failure_count
2663: FROM cm_mthd_mst
2664: WHERE (
2665: (default_lot_cost_type_id IS NULL AND default_lot_cost_mthd IS NOT NULL)
2666: OR (cost_type = 1 AND nvl(lot_actual_cost,-1) = 1)
2667: );
2860: a.text_code,
2861: a.delete_mark
2862: FROM cm_cldr_hdr_b a,
2863: gl_plcy_mst b,
2864: cm_mthd_mst c
2865: WHERE a.cost_mthd_code IS NOT NULL
2866: AND a.co_code IS NOT NULL
2867: AND b.legal_entity_id IS NOT NULL
2868: AND c.cost_type_id IS NOT NULL
2947: g.last_update_login,
2948: g.text_code,
2949: 1
2950: FROM cm_cldr_hdr_b g,
2951: cm_mthd_mst h,
2952: gl_plcy_mst i
2953: WHERE g.co_code IS NOT NULL
2954: AND i.legal_entity_id IS NOT NULL
2955: AND g.cost_mthd_code <> h.cost_mthd_code
3087: g.last_update_login,
3088: g.text_code,
3089: 1
3090: FROM cm_cldr_hdr_b g,
3091: cm_mthd_mst h,
3092: gl_plcy_mst i,
3093: sy_orgn_mst j,
3094: cm_rsrc_dtl k
3095: WHERE g.co_code IS NOT NULL
3183: g.last_update_login,
3184: g.text_code,
3185: 1
3186: FROM cm_cldr_hdr_b g,
3187: cm_mthd_mst h,
3188: gl_plcy_mst i,
3189: sy_orgn_mst j,
3190: cm_brdn_dtl k
3191: WHERE g.co_code IS NOT NULL
3279: g.last_update_login,
3280: g.text_code,
3281: 1
3282: FROM cm_cldr_hdr_b g,
3283: cm_mthd_mst h,
3284: gl_plcy_mst i,
3285: sy_orgn_mst j,
3286: cm_cmpt_dtl k,
3287: ic_whse_mst l
3377: g.last_update_login,
3378: g.text_code,
3379: 1
3380: FROM cm_cldr_hdr_b g,
3381: cm_mthd_mst h,
3382: gl_plcy_mst i,
3383: sy_orgn_mst j,
3384: cm_adjs_dtl k,
3385: ic_whse_mst l
3880: SELECT x.cost_type_id,
3881: x.period_id,
3882: x.legal_entity_id
3883: FROM gmf_period_statuses x,
3884: cm_mthd_mst y,
3885: cm_cldr_hdr_b z,
3886: gl_plcy_mst w
3887: WHERE y.cost_mthd_code = a.cost_mthd_code
3888: AND x.cost_type_id = y.cost_type_id
4206: UPDATE gmf_lot_costs a
4207: SET a.cost_type_id
4208: = (
4209: SELECT x.cost_Type_id
4210: FROM cm_mthd_mst x
4211: WHERE x.cost_mthd_code = a.cost_mthd_code
4212: ),
4213: (
4214: a.organization_id,
4707: UPDATE gmf_lot_costed_items a
4708: SET a.cost_type_id
4709: = (
4710: SELECT x.cost_Type_id
4711: FROM cm_mthd_mst x
4712: WHERE x.cost_mthd_code = a.cost_mthd_code
4713: ),
4714: a.legal_entity_id
4715: = (
4955: UPDATE gmf_lot_cost_adjustments a
4956: SET a.cost_type_id
4957: = (
4958: SELECT x.cost_Type_id
4959: FROM cm_mthd_mst x
4960: WHERE x.cost_mthd_code = a.cost_mthd_code
4961: ),
4962: a.legal_entity_id
4963: = (
5393:
5394: UPDATE gmf_material_lot_cost_txns a
5395: SET a.cost_type_id = (
5396: SELECT x.cost_Type_id
5397: FROM cm_mthd_mst x
5398: WHERE x.cost_mthd_code = a.cost_type_code
5399: ),
5400: a.cost_trans_um = (
5401: SELECT x.uom_Code
5577: UPDATE gmf_lot_cost_burdens a
5578: SET a.cost_type_id
5579: = (
5580: SELECT x.cost_Type_id
5581: FROM cm_mthd_mst x
5582: WHERE x.cost_mthd_code = a.cost_mthd_code
5583: ),
5584: a.item_uom
5585: = (
10858: =
10859: (
10860: select gps.legal_entity_id, gps.period_id, gps.cost_type_id
10861: from gmf_period_statuses gps,
10862: cm_mthd_mst cmm,
10863: cm_cldr_hdr_b cch,
10864: gl_plcy_mst gpm
10865: where gps.calendar_code = cac.calendar_code
10866: and cch.calendar_code = cac.calendar_code
11052: SELECT gps.legal_entity_id,
11053: gps.period_id,
11054: gps.cost_type_id
11055: FROM gmf_period_statuses gps,
11056: cm_mthd_mst cmm,
11057: cm_cldr_hdr_b cch,
11058: gl_plcy_mst gpm
11059: WHERE gps.calendar_code = crc.calendar_code
11060: AND cch.calendar_code = crc.calendar_code
11363: =
11364: (
11365: select gps.legal_entity_id, gps.period_id, gps.cost_type_id
11366: from gmf_period_statuses gps,
11367: cm_mthd_mst cmm,
11368: gl_plcy_mst gpm
11369: where gps.calendar_code = ccc.calendar_code
11370: and gpm.co_code = ccc.co_code
11371: and gps.period_code = ccc.period_code
11568: cmm.cost_type_id,
11569: dcmm.cost_mthd_code default_lot_cost_mthd_code,
11570: cmm.default_lot_cost_type_id,
11571: gfp.cost_basis
11572: from cm_mthd_mst cmm,
11573: cm_mthd_mst dcmm,
11574: gl_plcy_mst gpm,
11575: gmf_fiscal_policies gfp,
11576: xle_entity_profiles xep
11569: dcmm.cost_mthd_code default_lot_cost_mthd_code,
11570: cmm.default_lot_cost_type_id,
11571: gfp.cost_basis
11572: from cm_mthd_mst cmm,
11573: cm_mthd_mst dcmm,
11574: gl_plcy_mst gpm,
11575: gmf_fiscal_policies gfp,
11576: xle_entity_profiles xep
11577: where gpm.co_code = a.co_code
11593: =
11594: (
11595: select gps.cost_type_id , gps.period_id
11596: from gmf_period_statuses gps,
11597: cm_mthd_mst cmm
11598: where gps.calendar_code = gss.crev_curr_calendar
11599: and gps.period_code = gss.crev_curr_period
11600: and cmm.cost_mthd_code = gss.crev_curr_mthd
11601: and gps.legal_entity_id = gss.legal_entity_id
11608: =
11609: (
11610: select gps.cost_type_id , gps.period_id
11611: from gmf_period_statuses gps,
11612: cm_mthd_mst cmm
11613: where gps.calendar_code = gss.crev_prev_calendar
11614: and gps.period_code = gss.crev_prev_period
11615: and cmm.cost_mthd_code = gss.crev_prev_mthd
11616: and gps.legal_entity_id = gss.legal_entity_id