 |
|
|
|
||||||||||||
 |
| My Home | Job Search | Browse Jobs | Company Profiles | Career Center | Help | Login |
| You Are Here: Company Profiles |
Company Profile
| Texas Communication Limited, Dusseldorf, Germany | |
| Updated: 09/2005 | |
DESCRIPTION: -- QUERY FOR GETTING DISCREPANCIES SELECT OPERATING_UNIT_CODE, ORGANIZATION_CODE, SUBINVENTORY_CODE, ITEM_NAME, LEGACY_ONHAND_QTY, G1_ONHAND_QTY, ( LEGACY_ONHAND_QTY - G1_ONHAND_QTY ) DIFFERENCE FROM GLB_ONHD_SYNC_IN_INTERFACE WHERE OPERATING_UNIT_CODE = 'TSB' -- OU NAME AND DISCREPANCY_FLAG = 'Y' AND SUBINVENTORY_CODE NOT LIKE 'TCN%' -- TCN SUBINVENTORIES ARE NOT NETTABLE. WE DONT COMPARE INVENTORY LEVELS IN THESE SUBINVS. ORDER BY ORGANIZATION_CODE; -- QUERY FOR GETTING NO. OF DISCREPANCIES ON A GIVEN DAY SELECT OPERATING_UNIT_CODE, COUNT(1) DISCREPANCIES FROM GLB_ONHD_SYNC_IN_INTERFACE WHERE DISCREPANCY_FLAG = 'Y' AND SUBINVENTORY_CODE NOT LIKE 'TCN%' GROUP BY OPERATING_UNIT_CODE; | |
| MISSION: n/a | |
| GENERAL INFO | |
Year Established: 1999 Sector: Most Descriptive Sector Industry: Most Descriptive Sector Employees: 100 Number of Jobs Listed: 0 (View All Active Jobs of Texas Communication Limited) | |
| FINANCIAL INFO | |
Revenue: n/a | |
| Ownership: Private | |
| LOCATION | |
Headquarters: Dusseldorf,DE Web Site: http://texas.technologie.limited.com
| |
|
|
Site Map | Partners | Link To Us | Alumni.NET | Philippine Outsourcing | SYP | Online Education |