EBS Customizations (MOSC)

MOSC Banner

Flexfield Value Set - Table Validation

edited Jan 26, 2012 12:51PM in EBS Customizations (MOSC) 4 commentsAnswered
I am trying to setup a Value Set...to do a lookup for the delivey number from the Service Request

Problem:  Trying to use Two Tables

Wsh_Delivery_Details  dtl and Wsh_Delivery_Assignments hdr

Table Name = WSH_DELIVERY_DETAILS dtl    Left Join wsh_delivery_assignments hdr on hdr.delivery_detail_id = dtl.delivery_detail_id

Value = hdr.wsh_delivery_Assignments

ID = dtl.delivery_detail_id

Where/Order by = where dtl.inventory_item_id = :INCIDENT_TRACKING.INVENTORY_ITEM_ID
and dtl.source_header_number = :INCIDENT_TRACKING.INCIDENT_ATTRIBUTE_1  --(This is the Original Sales Order Number Part went out on)

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