DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_LOOKUP_CODES

Line 5497: from po_lookup_codes

5493: l_min_acct_unit number;
5494: /*End Bug#3406460 */
5495: cursor c1(p_auth_stat varchar2) is
5496: select DISPLAYED_FIELD
5497: from po_lookup_codes
5498: where lookup_type='AUTHORIZATION STATUS'
5499: and lookup_code = p_auth_stat;
5500:
5501: cursor c2(p_closed_code varchar2) is

Line 5503: from po_lookup_codes

5499: and lookup_code = p_auth_stat;
5500:
5501: cursor c2(p_closed_code varchar2) is
5502: select DISPLAYED_FIELD
5503: from po_lookup_codes
5504: where lookup_type='DOCUMENT STATE'
5505: and lookup_code = p_closed_code;
5506:
5507: /* Bug# 2616355: kagarwal

Line 5521: from po_lookup_codes

5517:
5518: /*
5519: cursor c4(p_doc_subtype varchar2) is
5520: select DISPLAYED_FIELD
5521: from po_lookup_codes
5522: where lookup_type='REQUISITION TYPE'
5523: and lookup_code = p_doc_subtype;
5524: */
5525:

Line 7708: po_lookup_codes ty,

7704: ty.DISPLAYED_FIELD || ' ' ||
7705: hd.SEGMENT1
7706: into l_doc_string
7707: from po_headers hd,
7708: po_lookup_codes ty,
7709: po_lookup_codes st
7710: where hd.po_header_id = l_document_id
7711: and ty.lookup_type = 'DOCUMENT TYPE'
7712: and ty.lookup_code = l_document_type

Line 7709: po_lookup_codes st

7705: hd.SEGMENT1
7706: into l_doc_string
7707: from po_headers hd,
7708: po_lookup_codes ty,
7709: po_lookup_codes st
7710: where hd.po_header_id = l_document_id
7711: and ty.lookup_type = 'DOCUMENT TYPE'
7712: and ty.lookup_code = l_document_type
7713: and st.lookup_type = 'DOCUMENT SUBTYPE'

Line 7721: po_lookup_codes ty,

7717: ty.DISPLAYED_FIELD || ' ' ||
7718: hd.SEGMENT1
7719: into l_doc_string
7720: from po_requisition_headers hd,
7721: po_lookup_codes ty,
7722: po_lookup_codes st
7723: where hd.requisition_header_id = l_document_id
7724: and ty.lookup_type = 'DOCUMENT TYPE'
7725: and ty.lookup_code = l_document_type

Line 7722: po_lookup_codes st

7718: hd.SEGMENT1
7719: into l_doc_string
7720: from po_requisition_headers hd,
7721: po_lookup_codes ty,
7722: po_lookup_codes st
7723: where hd.requisition_header_id = l_document_id
7724: and ty.lookup_type = 'DOCUMENT TYPE'
7725: and ty.lookup_code = l_document_type
7726: and st.lookup_type = 'REQUISITION TYPE'

Line 7736: po_lookup_codes ty,

7732: rl.RELEASE_NUM
7733: into l_doc_string
7734: from po_headers hd,
7735: po_releases rl,
7736: po_lookup_codes ty,
7737: po_lookup_codes st
7738: where rl.po_release_id = l_document_id
7739: and rl.po_header_id = hd.po_header_id
7740: and ty.lookup_type = 'DOCUMENT TYPE'

Line 7737: po_lookup_codes st

7733: into l_doc_string
7734: from po_headers hd,
7735: po_releases rl,
7736: po_lookup_codes ty,
7737: po_lookup_codes st
7738: where rl.po_release_id = l_document_id
7739: and rl.po_header_id = hd.po_header_id
7740: and ty.lookup_type = 'DOCUMENT TYPE'
7741: and ty.lookup_code = l_document_type