Supply Chain Management - PSFT (MOSC)

MOSC Banner

Record for pulling the Service Provider Name in Template Variables - WO Submittal Notification email

edited Dec 18, 2013 2:44PM in Supply Chain Management - PSFT (MOSC) 1 commentAnswered
We are modifying the Work Order Submittal Notification email to include the Service Provider Details( Service Provider ID & Name). Hence, we have added the WO_CONID from SPF_WORDERREC Record(for Service Provider ID) in the Template Variable ID - SPF_WORK_ORDER_CMP.

For adding the Service Provider Name, if we use NAME field from the SPB_PERSON_TBL, it was pulling the Provider Contact Name(instead of service provider) as both of them share the same related display record at WO component level.

I think I need to pull the service provider name from another record in the template variables.  Would you happen to know where I should be pulling it from. I tried changing the record to SPF_TASK_WRK but it's not pulling in any name in the WO Submittal Notification email.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center