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.INV_MIGRATE_PROCESS_ORG dependencies on SY_ORGN_MST

Line 234: FROM sy_orgn_mst a, gl_plcy_mst b

230: WHERE process_enabled_flag = 'Y';
231:
232: CURSOR Cur_get_oper_unit (V_orgn_code VARCHAR2)IS
233: SELECT a.co_code
234: FROM sy_orgn_mst a, gl_plcy_mst b
235: WHERE a.co_code = b.co_code
236: AND a.orgn_code = V_orgn_code
237: AND b.new_le_flag = 'Y';
238:

Line 785: FROM sy_orgn_mst

781: AND NVL(migrated_ind,0) = 0;
782:
783: CURSOR Cur_get_orgn(V_orgn_code VARCHAR2) IS
784: SELECT organization_id
785: FROM sy_orgn_mst
786: WHERE orgn_code = V_orgn_code;
787:
788: CURSOR Cur_check_subinventory(V_whse_code VARCHAR2, V_organization_id NUMBER) IS
789: SELECT 1

Line 1485: p_table_name => 'SY_ORGN_MST',

1481: GMA_COMMON_LOGGING.gma_migration_central_log (
1482: p_run_id => P_migration_run_id,
1483: p_log_level => FND_LOG.LEVEL_ERROR,
1484: p_message_token => 'GMA_TEMP_ORGN_MISSING_ERROR',
1485: p_table_name => 'SY_ORGN_MST',
1486: p_context => 'ORGANIZATION',
1487: p_token1 => 'ORGANIZATION',
1488: p_param1 => p_orgn_code,
1489: p_app_short_name => 'GMA');

Line 1497: p_table_name => 'SY_ORGN_MST',

1493: GMA_COMMON_LOGGING.gma_migration_central_log (
1494: p_run_id => P_migration_run_id,
1495: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1496: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1497: p_table_name => 'SY_ORGN_MST',
1498: p_context => 'ORGANIZATION',
1499: p_db_error => p_orgn_code||'-'||l_msg_data,
1500: p_app_short_name => 'GMA');
1501:

Line 1509: p_table_name => 'SY_ORGN_MST',

1505: GMA_COMMON_LOGGING.gma_migration_central_log (
1506: p_run_id => P_migration_run_id,
1507: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1508: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1509: p_table_name => 'SY_ORGN_MST',
1510: p_context => 'ORGANIZATION',
1511: p_db_error => SQLERRM,
1512: p_app_short_name => 'GMA');
1513: END create_organization;

Line 1551: FROM sy_orgn_mst

1547:
1548: --CURSORS
1549: CURSOR Cur_get_organization IS
1550: SELECT *
1551: FROM sy_orgn_mst
1552: WHERE (migrate_as_ind <> 0 OR migrate_as_ind IS NULL)
1553: AND (orgn_code <> co_code or plant_ind > 0)
1554: AND NVL(migrated_ind,0) = 0;
1555:

Line 1585: p_table_name => 'SY_ORGN_MST',

1581: GMA_COMMON_LOGGING.gma_migration_central_log (
1582: p_run_id => l_migration_id,
1583: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1584: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1585: p_table_name => 'SY_ORGN_MST',
1586: p_context => 'ORGANIZATION',
1587: p_app_short_name => 'GMA');
1588:
1589: FOR l_rec IN Cur_get_organization LOOP

Line 1634: UPDATE sy_orgn_mst_b

1630: SET default_status_id = l_default_status_id
1631: WHERE organization_id = l_rec.organization_id;
1632: END IF; /* IF NVL(l_rec.migrate_as_ind, 1) IN (1,3) */
1633:
1634: UPDATE sy_orgn_mst_b
1635: SET organization_id = l_organization_id,
1636: migrated_ind = 1
1637: WHERE orgn_code = l_rec.orgn_code;
1638:

Line 1661: p_table_name => 'SY_ORGN_MST',

1657: GMA_COMMON_LOGGING.gma_migration_central_log (
1658: p_run_id => l_migration_id,
1659: p_log_level => FND_LOG.LEVEL_ERROR,
1660: p_message_token => 'GMA_ORGN_MISSING_ERROR',
1661: p_table_name => 'SY_ORGN_MST',
1662: p_context => 'ORGANIZATION',
1663: p_token1 => 'ORGANIZATION',
1664: p_param1 => l_rec.orgn_code,
1665: p_app_short_name => 'GMA');

Line 1684: p_table_name => 'SY_ORGN_MST',

1680: GMA_COMMON_LOGGING.gma_migration_central_log(
1681: p_run_id => P_migration_run_id,
1682: p_log_level => FND_LOG.LEVEL_ERROR,
1683: p_message_token => 'GMA_DEFAULT_STATUS_MISSING_ERROR',
1684: p_table_name => 'SY_ORGN_MST',
1685: p_context => 'ORGANIZATION',
1686: p_token1 => 'ORGANIZATION',
1687: p_param1 => l_rec.organization_code,
1688: p_app_short_name => 'GMA');

Line 1710: p_table_name => 'SY_ORGN_MST',

1706: GMA_COMMON_LOGGING.gma_migration_central_log (
1707: p_run_id => l_migration_id,
1708: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1709: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1710: p_table_name => 'SY_ORGN_MST',
1711: p_context => 'ORGANIZATION',
1712: p_db_error => SQLERRM,
1713: p_app_short_name => 'GMA');
1714: END;

Line 1721: p_table_name => 'SY_ORGN_MST',

1717: GMA_COMMON_LOGGING.gma_migration_central_log (
1718: p_run_id => l_migration_id,
1719: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1720: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1721: p_table_name => 'SY_ORGN_MST',
1722: p_context => 'ORGANIZATION',
1723: p_param1 => l_migrate_count,
1724: p_param2 => X_failure_count,
1725: p_app_short_name => 'GMA');

Line 1736: p_table_name => 'SY_ORGN_MST',

1732: GMA_COMMON_LOGGING.gma_migration_central_log (
1733: p_run_id => l_migration_id,
1734: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1735: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1736: p_table_name => 'SY_ORGN_MST',
1737: p_context => 'ORGANIZATION',
1738: p_db_error => SQLERRM,
1739: p_app_short_name => 'GMA');
1740:

Line 1745: p_table_name => 'SY_ORGN_MST',

1741: GMA_COMMON_LOGGING.gma_migration_central_log (
1742: p_run_id => l_migration_id,
1743: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1744: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
1745: p_table_name => 'SY_ORGN_MST',
1746: p_context => 'ORGANIZATION',
1747: p_app_short_name => 'GMA');
1748:
1749: END migrate_organization;