Posts

Showing posts from March, 2006

More Useful SQL statments for Visual Enterprise from Infor

Here are some of my raw notes:


SELECT CUSTOMER_ID, ID, CUSTOMER_PO_REF
FROM CUSTOMER_ORDER
WHERE (ID = '200150960')

select CUST_ORDER_ID from CUST_ORDER_LINE where CUST_ORDER_ID='200150960'

SELECT QUOTE_ID FROM QUOTE_ORDER WHERE CUST_ORDER_ID = '200150960'

Use SFC to get the Work Order Number:
------------------------------------------

SELECT SUPPLY_BASE_ID, DEMAND_BASE_ID
FROM DEMAND_SUPPLY_LINK
WHERE (DEMAND_BASE_ID = '200150960')


Now find the Operation Status
---------------------------------
SELECT OPERATION_SEQ_NO, RESOURCE_ID
FROM LABOR_TICKET
WHERE WORKORDER_TYPE = 'W' AND WORKORDER_BASE_ID = '746952' AND WORKORDER_LOT_ID = '1'

What is the work order Status, and ship date if it's already gone?
----------------------------------------------
SELECT STATUS, close_date
FROM WORK_ORDER
WHERE BASE_ID = '789635'


Combine WO and Status
------------------------
SELECT DEMAND_SUPPLY_LINK.DEMAND_…

Usefull SQL Statements for SQL Server and Visual Manufacturing from Infor

Here is an example of how you can convert OPERATION_BINARY.BITS to text using cast, so that you can have it show up in a report.


SELECT OPERATION_BINARY.SEQUENCE_NO, CAST(CAST(OPERATION_BINARY.BITS AS varbinary(8000)) AS varchar(8000)) AS specs,
OPERATION.RESOURCE_ID, OPERATION.OPERATION_TYPE, OPERATION_TYPE.DESCRIPTION,
OPERATION_BINARY.WORKORDER_TYPE
FROM OPERATION_BINARY INNER JOIN
OPERATION ON OPERATION_BINARY.WORKORDER_BASE_ID = OPERATION.WORKORDER_BASE_ID AND
OPERATION_BINARY.SEQUENCE_NO = OPERATION.SEQUENCE_NO AND
OPERATION_BINARY.WORKORDER_TYPE = OPERATION.WORKORDER_TYPE AND
OPERATION_BINARY.WORKORDER_SUB_ID = OPERATION.WORKORDER_SUB_ID AND
OPERATION_BINARY.WORKORDER_SPLIT_ID = OPERATION.WORKORDER_SPLIT_ID AND
OPERATION_BINARY.WORKORDER_LOT_ID = OPERATION.WORKORDER_LOT_ID INNER JOIN

Automated Silent Installation/Deploy

Every admin out there has the need to install software on a new PC, and hopefully silently.
Here is my batch file that I use to install everything after I use RIS to install XP.
My ERP and other software that would be useless to most people has been removed.
The Ghostscript PDF creation tool is available from my website: http://www.looserubble.com

-------------------------------------------

@echo off
q:
cd "Q:\software\Build PC"

echo Installing Quicktime
start /WAIT QuickTimeFullInstaller.exe

echo Installing Real Player
start /WAIT RealPlayer10GOLD_bb.exe /S

echo Installing MSN Messenger 7.5
start /WAIT msiexec /i "MSN Messenger\msnmsgs.msi" /q

echo Installing Prism Plug-In for Boeing Drawings
start /WAIT prism\PrizmPlug-in-ext.exe /s /f1"prism\SkillsInstallPrism.iss"

echo Installing Desktop Icons
REM start /WAIT "Installing" "Q:\software\Desktop Apps\Desktop Icons\Doc Control Icons.EXE"
echo Copy desktop icons from the terminal server
copy "\\monst…