DBA Data[Home] [Help]

APPS.OKS_IMPORT_REPORT dependencies on FND_NEW_MESSAGES

Line 164: (SELECT FM.* FROM FND_NEW_MESSAGES FM, FND_APPLICATION FA

160: CURSOR error_messages_cur (c_parent_request_id IN NUMBER)
161: IS
162: SELECT OIE.INTERFACE_TABLE, OIE.INTERFACE_ID, nvl(FNM.MESSAGE_TEXT, OIE.ERROR_MESSAGE) ERROR_MESSAGE
163: FROM OKS_IMP_ERRORS OIE,
164: (SELECT FM.* FROM FND_NEW_MESSAGES FM, FND_APPLICATION FA
165: WHERE FM.LANGUAGE_CODE = USERENV('LANG')
166: AND FA.APPLICATION_SHORT_NAME = 'OKS' AND FM.APPLICATION_ID = FA.APPLICATION_ID) FNM
167: WHERE OIE.ERROR_MESSAGE = FNM.MESSAGE_NAME (+)
168: AND PARENT_REQUEST_ID = c_parent_request_id;