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

Line 60: po_lookup_codes plc_clo

56: begin
57: SELECT 'Y'
58: into l_code_exist
59: FROM po_requisition_headers prh,
60: po_lookup_codes plc_clo
61: WHERE plc_clo.lookup_code = nvl(prh.closed_code, 'OPEN')
62: AND plc_clo.lookup_type = 'DOCUMENT STATE'
63: AND prh.requisition_header_id = l_document_id;
64: EXCEPTION

Line 161: po_lookup_codes plc_sta,

157: if (doctype = 'RELEASE') then
158: select 'Y'
159: into l_code_exist
160: from po_releases por,
161: po_lookup_codes plc_sta,
162: po_lookup_codes plc_can,
163: po_lookup_codes plc_clo,
164: po_lookup_codes plc_fro,
165: po_lookup_codes plc_hld

Line 162: po_lookup_codes plc_can,

158: select 'Y'
159: into l_code_exist
160: from po_releases por,
161: po_lookup_codes plc_sta,
162: po_lookup_codes plc_can,
163: po_lookup_codes plc_clo,
164: po_lookup_codes plc_fro,
165: po_lookup_codes plc_hld
166: where plc_sta.lookup_code =

Line 163: po_lookup_codes plc_clo,

159: into l_code_exist
160: from po_releases por,
161: po_lookup_codes plc_sta,
162: po_lookup_codes plc_can,
163: po_lookup_codes plc_clo,
164: po_lookup_codes plc_fro,
165: po_lookup_codes plc_hld
166: where plc_sta.lookup_code =
167: decode(por.approved_flag,

Line 164: po_lookup_codes plc_fro,

160: from po_releases por,
161: po_lookup_codes plc_sta,
162: po_lookup_codes plc_can,
163: po_lookup_codes plc_clo,
164: po_lookup_codes plc_fro,
165: po_lookup_codes plc_hld
166: where plc_sta.lookup_code =
167: decode(por.approved_flag,
168: 'R', por.approved_flag,

Line 165: po_lookup_codes plc_hld

161: po_lookup_codes plc_sta,
162: po_lookup_codes plc_can,
163: po_lookup_codes plc_clo,
164: po_lookup_codes plc_fro,
165: po_lookup_codes plc_hld
166: where plc_sta.lookup_code =
167: decode(por.approved_flag,
168: 'R', por.approved_flag,
169: nvl(por.authorization_status,'INCOMPLETE'))

Line 185: po_lookup_codes plc_sta,

181: elsif (l_document_type = 'PO' or l_document_type = 'PA') then
182: select 'Y'
183: into l_code_exist
184: from po_headers poh,
185: po_lookup_codes plc_sta,
186: po_lookup_codes plc_can,
187: po_lookup_codes plc_clo,
188: po_lookup_codes plc_fro,
189: po_lookup_codes plc_hld

Line 186: po_lookup_codes plc_can,

182: select 'Y'
183: into l_code_exist
184: from po_headers poh,
185: po_lookup_codes plc_sta,
186: po_lookup_codes plc_can,
187: po_lookup_codes plc_clo,
188: po_lookup_codes plc_fro,
189: po_lookup_codes plc_hld
190: where plc_sta.lookup_code =

Line 187: po_lookup_codes plc_clo,

183: into l_code_exist
184: from po_headers poh,
185: po_lookup_codes plc_sta,
186: po_lookup_codes plc_can,
187: po_lookup_codes plc_clo,
188: po_lookup_codes plc_fro,
189: po_lookup_codes plc_hld
190: where plc_sta.lookup_code =
191: decode(poh.approved_flag,

Line 188: po_lookup_codes plc_fro,

184: from po_headers poh,
185: po_lookup_codes plc_sta,
186: po_lookup_codes plc_can,
187: po_lookup_codes plc_clo,
188: po_lookup_codes plc_fro,
189: po_lookup_codes plc_hld
190: where plc_sta.lookup_code =
191: decode(poh.approved_flag,
192: 'R', poh.approved_flag,

Line 189: po_lookup_codes plc_hld

185: po_lookup_codes plc_sta,
186: po_lookup_codes plc_can,
187: po_lookup_codes plc_clo,
188: po_lookup_codes plc_fro,
189: po_lookup_codes plc_hld
190: where plc_sta.lookup_code =
191: decode(poh.approved_flag,
192: 'R', poh.approved_flag,
193: nvl(poh.authorization_status, 'INCOMPLETE'))