Enterprise Asset Management - EBS (MOSC)

MOSC Banner

DFF Query for Asset Numbers

edited Apr 14, 2012 12:46AM in Enterprise Asset Management - EBS (MOSC) 3 commentsAnswered ✓
Hi,
I'm trying to create a DFF to get all the EAM Asset Numbers in a LOV.
So far this is what I have:
Value Set: EAM_ASSET_NUMBER
List Type: List of Values
Validation Type: Table

Edit Information button
Table Application: Inventory
Table Name: MTL_SERIAL_NUMBERS
Table Columns----
Value: SERIAL_NUMBER
Type: VarChar2
Size: 30


I want to restrict this to only EAM Asset Numbers, because so far with those values I'm getting all the Serial Numbers (MRO Items, etc)
Is there a way to accomplish this? I just want to have the Asset Number and the Description for the current org.

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