APPS.GMF_MIGRATION dependencies on GMF_BURDEN_PERCENTAGES

Line 3747: FROM gmf_burden_percentages a,

3743: organization_id
3744: FROM (
3745: SELECT a.item_id,
3746: 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
3747: FROM gmf_burden_percentages a,
3748: ic_whse_mst b,
3749: ic_whse_mst c
3750: WHERE a.item_id IS NOT NULL
3751: AND b.orgn_code = a.orgn_code

Line 3758: G_Table_name := 'GMF_BURDEN_PERCENTAGES';

3754:
3755: BEGIN
3756:
3757: G_Migration_run_id := P_migration_run_id;
3758: G_Table_name := 'GMF_BURDEN_PERCENTAGES';
3759: G_Context := 'Burden Percentages Migration';
3760: X_failure_count := 0;
3761:
3762: /********************************

Line 3801: * Update a row in GMF_BURDEN_PERCENTAGES *

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

Line 3807: INTO gmf_burden_percentages

3803:
3804: BEGIN
3805:
3806: INSERT
3807: INTO gmf_burden_percentages
3808: (
3809: burden_percentage_id,
3810: calendar_code,
3811: period_code,

Line 3849: FROM gmf_burden_percentages a,

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

Line 3858: FROM gmf_burden_percentages x

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

Line 3873: UPDATE gmf_burden_percentages a

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

Line 3956: UPDATE gmf_burden_percentages a

3952:
3953: END;
3954:
3955: BEGIN
3956: UPDATE gmf_burden_percentages a
3957: SET (
3958: a.master_organization_id,
3959: a.inventory_item_id
3960: )

Line 3977: UPDATE gmf_burden_percentages a

3973: )
3974: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
3975: OR (a.master_organization_id IS NULL AND a.item_id IS NOT NULL);
3976:
3977: UPDATE gmf_burden_percentages a
3978: SET a.delete_mark = 1
3979: WHERE ROWID NOT IN (
3980: SELECT MIN(x.ROWID)
3981: FROM gmf_burden_percentages x

Line 3981: FROM gmf_burden_percentages x

3977: UPDATE gmf_burden_percentages a
3978: SET a.delete_mark = 1
3979: WHERE ROWID NOT IN (
3980: SELECT MIN(x.ROWID)
3981: FROM gmf_burden_percentages x
3982: WHERE x.legal_entity_id = a.legal_entity_id
3983: AND x.period_id = a.period_id
3984: AND x.cost_type_id = a.cost_type_id
3985: AND x.burden_id = a.burden_id

Line 4042: FROM gmf_burden_percentages

4038: **********************************************/
4039:
4040: SELECT count(*)
4041: INTO x_failure_count
4042: FROM gmf_burden_percentages
4043: WHERE (
4044: (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
4045: OR (calendar_code IS NOT NULL AND period_code IS NOT NULL AND period_id IS NULL)
4046: OR (calendar_code IS NOT NULL AND legal_entity_id IS NULL)