SELECT OOS.NAME "Order Import Source"
,OOS.DESCRIPTION "Description"
,OOS.ENABLED_FLAG "Enabled"
,OOS.AIA_ENABLED_FLAG "AIA Enabled"
FROM APPS.OE_ORDER_SOURCES OOS
WHERE 1=1
AND EXISTS (SELECT 1 FROM APPS.FND_USER WHERE USER_ID = OOS.CREATED_BY)
,OOS.DESCRIPTION "Description"
,OOS.ENABLED_FLAG "Enabled"
,OOS.AIA_ENABLED_FLAG "AIA Enabled"
FROM APPS.OE_ORDER_SOURCES OOS
WHERE 1=1
AND EXISTS (SELECT 1 FROM APPS.FND_USER WHERE USER_ID = OOS.CREATED_BY)
No comments:
Post a Comment