...
This uses a single table PD_ADDRESSES which is imported into the iShare database as NorthgateLLPG.
Workflow stored procedure Create a Workflow Stored Procedure Task to create AstunLocationLookup : at_using the Workflow function at_wkf_build_from_northgatemvm (from v6.0.0 this is called wkf_build_from_northgatemvmnorthgate under the -Workflow- Function filter)
SQL Statements
Table | SQL Statement |
|---|---|
NorthgateLLPG | SELECT * FROM PD_ADDRESSES WHERE PRIMARY_LPI = 'Y' AND PLAPI_STATUS='L' |