DBA Data[Home] [Help]

APPS.GMF_MIGRATION dependencies on CM_CLDR_HDR_B

Line 2762: * data in CM_CLDR_HDR_B AND CM_CLDR_DTL to GMF_CALENDAR_ASSIGNMENTS *

2758: * Migrate_Cost_Calendars *
2759: * *
2760: * DESCRIPTION: *
2761: * This PL/SQL procedure is used to transform the Cost Calendars *
2762: * data in CM_CLDR_HDR_B AND CM_CLDR_DTL to GMF_CALENDAR_ASSIGNMENTS *
2763: * and GMF_PERIOD_STATUSES *
2764: * *
2765: * PARAMETERS: *
2766: * P_migration_run_id - id to use to right to migration log *

Line 2862: FROM cm_cldr_hdr_b a,

2858: a.last_updated_by,
2859: a.last_update_login,
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

Line 2950: FROM cm_cldr_hdr_b g,

2946: g.last_updated_by,
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

Line 3090: FROM cm_cldr_hdr_b g,

3086: g.last_updated_by,
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

Line 3186: FROM cm_cldr_hdr_b g,

3182: g.last_updated_by,
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

Line 3282: FROM cm_cldr_hdr_b g,

3278: g.last_updated_by,
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,

Line 3380: FROM cm_cldr_hdr_b g,

3376: g.last_updated_by,
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,

Line 3563: cm_cldr_hdr_b h

3559: b.text_code,
3560: decode(a.delete_mark + b.delete_mark, 0, 0, 1)
3561: FROM gmf_calendar_assignments a,
3562: cm_cldr_dtl b,
3563: cm_cldr_hdr_b h
3564: WHERE a.calendar_code = b.calendar_code
3565: AND b.calendar_code = h.calendar_code
3566: AND h.co_code IS NOT NULL
3567: AND h.cost_mthd_code IS NOT NULL

Line 3885: cm_cldr_hdr_b z,

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
3889: AND x.calendar_code = a.calendar_code

Line 10863: cm_cldr_hdr_b cch,

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
10867: and cch.co_code = gpm.co_code

Line 11057: cm_cldr_hdr_b cch,

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
11061: AND cch.co_code = gpm.co_code