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 9742: G_Table_name := 'GMF_BURDEN_PRIORITIES';

9738:
9739: BEGIN
9740:
9741: G_Migration_run_id := P_migration_run_id;
9742: G_Table_name := 'GMF_BURDEN_PRIORITIES';
9743: G_Context := 'Burden Priorities Migration';
9744: X_failure_count := 0;
9745:
9746: /********************************

Line 9765: UPDATE gmf_burden_priorities a

9761: /*****************************************
9762: * Update rows For Organization Priority *
9763: *****************************************/
9764:
9765: UPDATE gmf_burden_priorities a
9766: SET a.organization_pri = nvl(a.whse_code_pri, a.orgn_code_pri),
9767: a.legal_entity_id
9768: = (
9769: SELECT x.legal_entity_id

Line 9776: UPDATE gmf_burden_priorities a

9772: )
9773: WHERE ((a.whse_code_pri IS NOT NULL OR a.orgn_code_pri IS NOT null) AND a.organization_pri IS NULL)
9774: OR (a.co_code IS NOT NULL AND a.legal_entity_id IS NULL);
9775:
9776: UPDATE gmf_burden_priorities a
9777: SET a.delete_mark = 1
9778: WHERE a.ROWID NOT IN (
9779: SELECT MIN(x.ROWID)
9780: FROM gmf_burden_priorities x

Line 9780: FROM gmf_burden_priorities x

9776: UPDATE gmf_burden_priorities a
9777: SET a.delete_mark = 1
9778: WHERE a.ROWID NOT IN (
9779: SELECT MIN(x.ROWID)
9780: FROM gmf_burden_priorities x
9781: WHERE x.burden_id = a.burden_id
9782: AND x.legal_entity_id = a.legal_Entity_id
9783: AND x.delete_mark <> 1
9784: );

Line 9786: UPDATE gmf_burden_priorities

9782: AND x.legal_entity_id = a.legal_Entity_id
9783: AND x.delete_mark <> 1
9784: );
9785:
9786: UPDATE gmf_burden_priorities
9787: SET organization_pri = decode(trunc(nvl(organization_pri,0) / orgn_code_pri), 0, organization_pri, organization_pri - 1),
9788: item_id_pri = decode(trunc(nvl(item_id_pri,0) / orgn_code_pri), 0, item_id_pri, item_id_pri - 1),
9789: icgl_class_pri = decode(trunc(nvl(icgl_class_pri,0) / orgn_code_pri), 0, icgl_class_pri, icgl_class_pri - 1),
9790: itemcost_class_pri = decode(trunc(nvl(itemcost_class_pri,0) / orgn_code_pri), 0, itemcost_class_pri, itemcost_class_pri - 1),

Line 9804: FROM gmf_burden_priorities a

9800: **********************************************/
9801:
9802: SELECT count(*)
9803: INTO x_failure_count
9804: FROM gmf_burden_priorities a
9805: WHERE ((a.whse_code_pri IS NOT NULL OR a.orgn_code_pri IS NOT null) AND a.organization_pri IS NULL)
9806: OR (a.co_code IS NOT NULL AND a.legal_entity_id IS NULL);
9807:
9808: IF nvl(x_failure_count,0) > 0 THEN