eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_MIGRATION dependencies on GMF_BURDEN_PRIORITIES

Line 9422: G_Table_name := 'GMF_BURDEN_PRIORITIES';

9418:
9419: BEGIN
9420:
9421: G_Migration_run_id := P_migration_run_id;
9422: G_Table_name := 'GMF_BURDEN_PRIORITIES';
9423: G_Context := 'Burden Priorities Migration';
9424: X_failure_count := 0;
9425:
9426: /********************************

Line 9445: UPDATE gmf_burden_priorities a

9441: /*****************************************
9442: * Update rows For Organization Priority *
9443: *****************************************/
9444:
9445: UPDATE gmf_burden_priorities a
9446: SET a.organization_pri = nvl(a.whse_code_pri, a.orgn_code_pri),
9447: a.legal_entity_id
9448: = (
9449: SELECT x.legal_entity_id

Line 9456: UPDATE gmf_burden_priorities a

9452: )
9453: WHERE ((a.whse_code_pri IS NOT NULL OR a.orgn_code_pri IS NOT null) AND a.organization_pri IS NULL)
9454: OR (a.co_code IS NOT NULL AND a.legal_entity_id IS NULL);
9455:
9456: UPDATE gmf_burden_priorities a
9457: SET a.delete_mark = 1
9458: WHERE a.ROWID NOT IN (
9459: SELECT MIN(x.ROWID)
9460: FROM gmf_burden_priorities x

Line 9460: FROM gmf_burden_priorities x

9456: UPDATE gmf_burden_priorities a
9457: SET a.delete_mark = 1
9458: WHERE a.ROWID NOT IN (
9459: SELECT MIN(x.ROWID)
9460: FROM gmf_burden_priorities x
9461: WHERE x.burden_id = a.burden_id
9462: AND x.legal_entity_id = a.legal_Entity_id
9463: AND x.delete_mark <> 1
9464: );

Line 9466: UPDATE gmf_burden_priorities

9462: AND x.legal_entity_id = a.legal_Entity_id
9463: AND x.delete_mark <> 1
9464: );
9465:
9466: UPDATE gmf_burden_priorities
9467: SET organization_pri = decode(trunc(nvl(organization_pri,0) / orgn_code_pri), 0, organization_pri, organization_pri - 1),
9468: item_id_pri = decode(trunc(nvl(item_id_pri,0) / orgn_code_pri), 0, item_id_pri, item_id_pri - 1),
9469: icgl_class_pri = decode(trunc(nvl(icgl_class_pri,0) / orgn_code_pri), 0, icgl_class_pri, icgl_class_pri - 1),
9470: itemcost_class_pri = decode(trunc(nvl(itemcost_class_pri,0) / orgn_code_pri), 0, itemcost_class_pri, itemcost_class_pri - 1),

Line 9484: FROM gmf_burden_priorities a

9480: **********************************************/
9481:
9482: SELECT count(*)
9483: INTO x_failure_count
9484: FROM gmf_burden_priorities a
9485: WHERE ((a.whse_code_pri IS NOT NULL OR a.orgn_code_pri IS NOT null) AND a.organization_pri IS NULL)
9486: OR (a.co_code IS NOT NULL AND a.legal_entity_id IS NULL);
9487:
9488: IF nvl(x_failure_count,0) > 0 THEN