VIEW: APPS.IEX_OPEN_INT_HST_UV

Source

View Text - Preformatted

SELECT IOH.OBJECT1_ID1 ,IOH.OBJECT1_ID2 ,IOH.JTOT_OBJECT1_CODE ,IOH.ACTION ,FLA.MEANING ACTION_MEANING ,IOH.STATUS STATUS ,FLS.MEANING STATUS_MEANING ,IOH.COMMENTS ,IOH.REQUEST_DATE ,IOH.PROCESS_DATE ,IEA.EXTERNAL_AGENCY_NAME ,IOH.REVIEW_DATE ,IOH.RECALL_DATE FROM IEX_OPEN_INT_HST IOH,IEX_EXT_AGNCY_V IEA,FND_LOOKUP_VALUES FLA,FND_LOOKUP_VALUES FLS WHERE (IOH.ACTION = FLA.LOOKUP_CODE AND FLA.LOOKUP_TYPE = 'IEX_EXTERNAL_INTERFACE_ACTION') AND (IOH.STATUS = FLS.LOOKUP_CODE AND FLS.LOOKUP_TYPE = 'IEX_EXTERNAL_INTERFACE_STATUS') AND IOH.EXT_AGNCY_ID = IEA.EXTERNAL_AGENCY_ID(+)

View Text - HTML Formatted

SELECT IOH.OBJECT1_ID1
, IOH.OBJECT1_ID2
, IOH.JTOT_OBJECT1_CODE
, IOH.ACTION
, FLA.MEANING ACTION_MEANING
, IOH.STATUS STATUS
, FLS.MEANING STATUS_MEANING
, IOH.COMMENTS
, IOH.REQUEST_DATE
, IOH.PROCESS_DATE
, IEA.EXTERNAL_AGENCY_NAME
, IOH.REVIEW_DATE
, IOH.RECALL_DATE
FROM IEX_OPEN_INT_HST IOH
, IEX_EXT_AGNCY_V IEA
, FND_LOOKUP_VALUES FLA
, FND_LOOKUP_VALUES FLS
WHERE (IOH.ACTION = FLA.LOOKUP_CODE
AND FLA.LOOKUP_TYPE = 'IEX_EXTERNAL_INTERFACE_ACTION')
AND (IOH.STATUS = FLS.LOOKUP_CODE
AND FLS.LOOKUP_TYPE = 'IEX_EXTERNAL_INTERFACE_STATUS')
AND IOH.EXT_AGNCY_ID = IEA.EXTERNAL_AGENCY_ID(+)