eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_WF_REQ_NOTIFICATION dependencies on FND_LANGUAGES

Line 3306: from po_document_types_tl tl, FND_LANGUAGES fl

3302: */
3303:
3304: cursor c_lookup_value(p_doc_subtype varchar2, p_language varchar2) is
3305: select type_name
3306: from po_document_types_tl tl, FND_LANGUAGES fl
3307: where fl.nls_language = p_language
3308: and tl.LANGUAGE = fl.language_code
3309: and tl.document_type_code = 'REQUISITION'
3310: and tl.document_subtype = p_doc_subtype;

Line 3315: from FND_LOOKUP_VALUES flv, FND_LANGUAGES fl

3311:
3312: /*
3313: cursor c_lookup_value(p_doc_subtype varchar2, p_language varchar2) is
3314: select MEANING
3315: from FND_LOOKUP_VALUES flv, FND_LANGUAGES fl
3316: where
3317: fl.nls_language = p_language
3318: and flv.LANGUAGE = fl.language_code
3319: and flv.lookup_type='REQUISITION TYPE'

Line 3328: FROM po_requisition_headers_all prh, FND_LOOKUP_VALUES FLV, FND_LANGUAGES FL

3324:
3325: -- MIPR Changes
3326: CURSOR mipr_csr(p_doc_id NUMBER, p_language varchar2) IS
3327: SELECT flv.MEANING
3328: FROM po_requisition_headers_all prh, FND_LOOKUP_VALUES FLV, FND_LANGUAGES FL
3329: WHERE prh.requisition_header_id = p_doc_id
3330: AND prh.clm_mipr_type = flv.LOOKUP_CODE
3331: AND NVL(cancel_flag,'N') = 'N'
3332: AND FL.NLS_LANGUAGE = p_language