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_LOOKUP_VALUES

Line 2689: FROM po_requisition_headers_all prh, FND_LOOKUP_VALUES FLV

2685:
2686: -- MIPR Changes
2687: CURSOR mipr_csr(p_doc_id NUMBER) IS
2688: SELECT flv.MEANING
2689: FROM po_requisition_headers_all prh, FND_LOOKUP_VALUES FLV
2690: WHERE prh.requisition_header_id = p_doc_id
2691: AND prh.clm_mipr_type = flv.LOOKUP_CODE
2692: AND NVL(prh.cancel_flag,'N') = 'N'
2693: AND FLV.LOOKUP_TYPE='MIPR_TYPE'

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