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_REQAPPROVAL_INIT1 dependencies on PO_LOOKUP_CODES

Line 4650: FROM po_lookup_codes

4646:
4647: CURSOR c1(p_auth_stat VARCHAR2)
4648: IS
4649: SELECT DISPLAYED_FIELD
4650: FROM po_lookup_codes
4651: WHERE lookup_type='AUTHORIZATION STATUS'
4652: AND lookup_code = p_auth_stat;
4653: CURSOR c2(p_closed_code VARCHAR2)
4654: IS

Line 4656: FROM po_lookup_codes

4652: AND lookup_code = p_auth_stat;
4653: CURSOR c2(p_closed_code VARCHAR2)
4654: IS
4655: SELECT DISPLAYED_FIELD
4656: FROM po_lookup_codes
4657: WHERE lookup_type='DOCUMENT STATE'
4658: AND lookup_code = p_closed_code;
4659: /* Bug# 2616355: kagarwal
4660: ** Desc: We will get the document type display value from

Line 4672: from po_lookup_codes

4668: AND document_subtype = p_doc_subtype;
4669: /*
4670: cursor c4(p_doc_subtype varchar2) is
4671: select DISPLAYED_FIELD
4672: from po_lookup_codes
4673: where lookup_type='REQUISITION TYPE'
4674: and lookup_code = p_doc_subtype;
4675: */
4676: /* Bug# 1470041: kagarwal

Line 6982: po_lookup_codes ty,

6978: || ' '
6979: || hd.SEGMENT1
6980: INTO l_doc_string
6981: FROM po_headers hd,
6982: po_lookup_codes ty,
6983: po_lookup_codes st
6984: WHERE hd.po_header_id = l_document_id
6985: AND ty.lookup_type = 'DOCUMENT TYPE'
6986: AND ty.lookup_code = l_document_type

Line 6983: po_lookup_codes st

6979: || hd.SEGMENT1
6980: INTO l_doc_string
6981: FROM po_headers hd,
6982: po_lookup_codes ty,
6983: po_lookup_codes st
6984: WHERE hd.po_header_id = l_document_id
6985: AND ty.lookup_type = 'DOCUMENT TYPE'
6986: AND ty.lookup_code = l_document_type
6987: AND st.lookup_type = 'DOCUMENT SUBTYPE'

Line 6997: po_lookup_codes ty,

6993: || ' '
6994: || hd.SEGMENT1
6995: INTO l_doc_string
6996: FROM po_requisition_headers hd,
6997: po_lookup_codes ty,
6998: po_lookup_codes st
6999: WHERE hd.requisition_header_id = l_document_id
7000: AND ty.lookup_type = 'DOCUMENT TYPE'
7001: AND ty.lookup_code = l_document_type

Line 6998: po_lookup_codes st

6994: || hd.SEGMENT1
6995: INTO l_doc_string
6996: FROM po_requisition_headers hd,
6997: po_lookup_codes ty,
6998: po_lookup_codes st
6999: WHERE hd.requisition_header_id = l_document_id
7000: AND ty.lookup_type = 'DOCUMENT TYPE'
7001: AND ty.lookup_code = l_document_type
7002: AND st.lookup_type = 'REQUISITION TYPE'

Line 7015: po_lookup_codes ty,

7011: || rl.RELEASE_NUM
7012: INTO l_doc_string
7013: FROM po_headers hd,
7014: po_releases rl,
7015: po_lookup_codes ty,
7016: po_lookup_codes st
7017: WHERE rl.po_release_id = l_document_id
7018: AND rl.po_header_id = hd.po_header_id
7019: AND ty.lookup_type = 'DOCUMENT TYPE'

Line 7016: po_lookup_codes st

7012: INTO l_doc_string
7013: FROM po_headers hd,
7014: po_releases rl,
7015: po_lookup_codes ty,
7016: po_lookup_codes st
7017: WHERE rl.po_release_id = l_document_id
7018: AND rl.po_header_id = hd.po_header_id
7019: AND ty.lookup_type = 'DOCUMENT TYPE'
7020: AND ty.lookup_code = l_document_type