How to Limit LOV in Miscellaneous Transaction - Source
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