DFF Query for Asset Numbers
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.
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.
0