[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
3883: SELECT x.cost_type_id,
3884: x.period_id,
3885: x.legal_entity_id
3886: FROM gmf_period_statuses x,
3887: cm_mthd_mst y,
3888: cm_cldr_hdr_b z,
3889: gl_plcy_mst w
3890: WHERE y.cost_mthd_code = a.cost_mthd_code
3891: AND x.cost_type_id = y.cost_type_id
4229: UPDATE gmf_lot_costs a
4230: SET a.cost_type_id
4231: = (
4232: SELECT x.cost_Type_id
4233: FROM cm_mthd_mst x
4234: WHERE x.cost_mthd_code = a.cost_mthd_code
4235: ),
4236: (
4237: a.organization_id,
4730: UPDATE gmf_lot_costed_items a
4731: SET a.cost_type_id
4732: = (
4733: SELECT x.cost_Type_id
4734: FROM cm_mthd_mst x
4735: WHERE x.cost_mthd_code = a.cost_mthd_code
4736: ),
4737: a.legal_entity_id
4738: = (
4978: UPDATE gmf_lot_cost_adjustments a
4979: SET a.cost_type_id
4980: = (
4981: SELECT x.cost_Type_id
4982: FROM cm_mthd_mst x
4983: WHERE x.cost_mthd_code = a.cost_mthd_code
4984: ),
4985: a.legal_entity_id
4986: = (
5416:
5417: UPDATE gmf_material_lot_cost_txns a
5418: SET a.cost_type_id = (
5419: SELECT x.cost_Type_id
5420: FROM cm_mthd_mst x
5421: WHERE x.cost_mthd_code = a.cost_type_code
5422: ),
5423: a.cost_trans_um = (
5424: SELECT x.uom_Code
5600: UPDATE gmf_lot_cost_burdens a
5601: SET a.cost_type_id
5602: = (
5603: SELECT x.cost_Type_id
5604: FROM cm_mthd_mst x
5605: WHERE x.cost_mthd_code = a.cost_mthd_code
5606: ),
5607: a.item_uom
5608: = (
11189: =
11190: (
11191: select gps.legal_entity_id, gps.period_id, gps.cost_type_id
11192: from gmf_period_statuses gps,
11193: cm_mthd_mst cmm,
11194: cm_cldr_hdr_b cch,
11195: gl_plcy_mst gpm
11196: where gps.calendar_code = cac.calendar_code
11197: and cch.calendar_code = cac.calendar_code
11383: SELECT gps.legal_entity_id,
11384: gps.period_id,
11385: gps.cost_type_id
11386: FROM gmf_period_statuses gps,
11387: cm_mthd_mst cmm,
11388: cm_cldr_hdr_b cch,
11389: gl_plcy_mst gpm
11390: WHERE gps.calendar_code = crc.calendar_code
11391: AND cch.calendar_code = crc.calendar_code
11694: =
11695: (
11696: select gps.legal_entity_id, gps.period_id, gps.cost_type_id
11697: from gmf_period_statuses gps,
11698: cm_mthd_mst cmm,
11699: gl_plcy_mst gpm
11700: where gps.calendar_code = ccc.calendar_code
11701: and gpm.co_code = ccc.co_code
11702: and gps.period_code = ccc.period_code
11899: cmm.cost_type_id,
11900: dcmm.cost_mthd_code default_lot_cost_mthd_code,
11901: cmm.default_lot_cost_type_id,
11902: gfp.cost_basis
11903: from cm_mthd_mst cmm,
11904: cm_mthd_mst dcmm,
11905: gl_plcy_mst gpm,
11906: gmf_fiscal_policies gfp,
11907: xle_entity_profiles xep
11900: dcmm.cost_mthd_code default_lot_cost_mthd_code,
11901: cmm.default_lot_cost_type_id,
11902: gfp.cost_basis
11903: from cm_mthd_mst cmm,
11904: cm_mthd_mst dcmm,
11905: gl_plcy_mst gpm,
11906: gmf_fiscal_policies gfp,
11907: xle_entity_profiles xep
11908: where gpm.co_code = a.co_code
11924: =
11925: (
11926: select gps.cost_type_id , gps.period_id
11927: from gmf_period_statuses gps,
11928: cm_mthd_mst cmm
11929: where gps.calendar_code = gss.crev_curr_calendar
11930: and gps.period_code = gss.crev_curr_period
11931: and cmm.cost_mthd_code = gss.crev_curr_mthd
11932: and gps.legal_entity_id = gss.legal_entity_id
11939: =
11940: (
11941: select gps.cost_type_id , gps.period_id
11942: from gmf_period_statuses gps,
11943: cm_mthd_mst cmm
11944: where gps.calendar_code = gss.crev_prev_calendar
11945: and gps.period_code = gss.crev_prev_period
11946: and cmm.cost_mthd_code = gss.crev_prev_mthd
11947: and gps.legal_entity_id = gss.legal_entity_id