Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

How to Limit LOV in Miscellaneous Transaction - Source

edited Dec 7, 2018 4:01AM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 1 commentAnswered

Hi,

Can anyone help me, I've been trying to limit LOV for Source in Inventory Miscellaneous transaction window the code is working in toad. It returns only one value, but when I put it in the form and tried to select for LOV it still shows all values.

SELECT MTL_GENERIC_DISPOSITIONS.SEGMENT1 C0,

       MTL_GENERIC_DISPOSITIONS.DESCRIPTION "Description",

       ENABLED_FLAG,

       SUMMARY_FLAG,

       NVL(TO_CHAR(START_DATE_ACTIVE, 'J'),0),

       NVL(TO_CHAR(END_DATE_ACTIVE, 'J'), 0),

       SEGMENT1, DISPOSITION_ID,

       DISTRIBUTION_ACCOUNT    

FROM MTL_GENERIC_DISPOSITIONS

WHERE MTL_GENERIC_DISPOSITIONS.DISPOSITION_ID = 492

AND MTL_GENERIC_DISPOSITIONS.ENABLED_FLAG = 'Y'

AND MTL_GENERIC_DISPOSITIONS.ORGANIZATION_ID = 201

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