APPS.GMF_MIGRATION dependencies on GMF_BURDEN_PERCENTAGES

Line 3750: FROM gmf_burden_percentages a,

3746: organization_id
3747: FROM (
3748: SELECT a.item_id,
3749: nvl(DECODE(NVL(c.subinventory_ind_flag,'N'), 'Y', c.organization_id, c.mtl_organization_id), DECODE(NVL(b.subinventory_ind_flag,'N'), 'Y', b.organization_id, b.mtl_organization_id)) organization_id
3750: FROM gmf_burden_percentages a,
3751: ic_whse_mst b,
3752: ic_whse_mst c
3753: WHERE a.item_id IS NOT NULL
3754: AND b.orgn_code = a.orgn_code

Line 3761: G_Table_name := 'GMF_BURDEN_PERCENTAGES';

3757:
3758: BEGIN
3759:
3760: G_Migration_run_id := P_migration_run_id;
3761: G_Table_name := 'GMF_BURDEN_PERCENTAGES';
3762: G_Context := 'Burden Percentages Migration';
3763: X_failure_count := 0;
3764:
3765: /********************************

Line 3804: * Update a row in GMF_BURDEN_PERCENTAGES *

3800: l_itm_failure_count_all := nvl(l_itm_failure_count_all,0) + nvl(l_itm_failure_count,0);
3801: END LOOP;
3802:
3803: /********************************************************
3804: * Update a row in GMF_BURDEN_PERCENTAGES *
3805: ********************************************************/
3806:
3807: BEGIN
3808:

Line 3810: INTO gmf_burden_percentages

3806:
3807: BEGIN
3808:
3809: INSERT
3810: INTO gmf_burden_percentages
3811: (
3812: burden_percentage_id,
3813: calendar_code,
3814: period_code,

Line 3852: FROM gmf_burden_percentages a,

3848: a.gl_business_category_id,
3849: a.gl_category_id,
3850: a.cost_category_id,
3851: a.gl_prod_line_category_id
3852: FROM gmf_burden_percentages a,
3853: ic_whse_mst e
3854: WHERE a.orgn_code IS NOT NULL
3855: AND a.whse_code IS NULL
3856: AND a.orgn_code = e.orgn_code

Line 3861: FROM gmf_burden_percentages x

3857: AND e.mtl_organization_id IS NOT NULL
3858: AND nvl(e.subinventory_ind_flag,'N') <> 'Y'
3859: AND NOT EXISTS (
3860: SELECT 'X'
3861: FROM gmf_burden_percentages x
3862: WHERE x.calendar_code = a.calendar_code
3863: AND x.period_code = a.period_code
3864: AND x.cost_mthd_code = a.cost_mthd_code
3865: AND x.burden_id = a.burden_id

Line 3876: UPDATE gmf_burden_percentages a

3872: AND nvl(x.gl_prod_line_category_id, -1) = nvl(a.gl_prod_line_category_id, -1)
3873: )
3874: );
3875:
3876: UPDATE gmf_burden_percentages a
3877: SET (
3878: a.cost_type_id,
3879: a.period_id,
3880: a.legal_entity_id

Line 3920: UPDATE gmf_burden_percentages a

3916: OR (a.organization_id IS NULL AND (a.whse_code IS NOT NULL OR a.orgn_code IS NOT NULL))
3917: );
3918:
3919: /* Bug 9674561 - Updating organization_id for the Burden percentage records (START) */
3920: UPDATE gmf_burden_percentages a
3921: SET (
3922: a.organization_id,
3923: a.delete_mark
3924: )

Line 3979: UPDATE gmf_burden_percentages a

3975:
3976: END;
3977:
3978: BEGIN
3979: UPDATE gmf_burden_percentages a
3980: SET (
3981: a.master_organization_id,
3982: a.inventory_item_id
3983: )

Line 4000: UPDATE gmf_burden_percentages a

3996: )
3997: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
3998: OR (a.master_organization_id IS NULL AND a.item_id IS NOT NULL);
3999:
4000: UPDATE gmf_burden_percentages a
4001: SET a.delete_mark = 1
4002: WHERE ROWID NOT IN (
4003: SELECT MIN(x.ROWID)
4004: FROM gmf_burden_percentages x

Line 4004: FROM gmf_burden_percentages x

4000: UPDATE gmf_burden_percentages a
4001: SET a.delete_mark = 1
4002: WHERE ROWID NOT IN (
4003: SELECT MIN(x.ROWID)
4004: FROM gmf_burden_percentages x
4005: WHERE x.legal_entity_id = a.legal_entity_id
4006: AND x.period_id = a.period_id
4007: AND x.cost_type_id = a.cost_type_id
4008: AND x.burden_id = a.burden_id

Line 4065: FROM gmf_burden_percentages

4061: **********************************************/
4062:
4063: SELECT count(*)
4064: INTO x_failure_count
4065: FROM gmf_burden_percentages
4066: WHERE (
4067: (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
4068: OR (calendar_code IS NOT NULL AND period_code IS NOT NULL AND period_id IS NULL)
4069: OR (calendar_code IS NOT NULL AND legal_entity_id IS NULL)