267: x_frozen_flag,
268: x_user_hold_flag,
269: x_type_lookup_code,
270: l_org_id -- Bug 3208853
271: from po_lookup_codes plc_sta,
272: po_lookup_codes plc_can,
273: po_lookup_codes plc_clo,
274: po_lookup_codes plc_fro,
275: po_lookup_codes plc_hld,
268: x_user_hold_flag,
269: x_type_lookup_code,
270: l_org_id -- Bug 3208853
271: from po_lookup_codes plc_sta,
272: po_lookup_codes plc_can,
273: po_lookup_codes plc_clo,
274: po_lookup_codes plc_fro,
275: po_lookup_codes plc_hld,
276: po_headers_all poh -- Bug 3208853
269: x_type_lookup_code,
270: l_org_id -- Bug 3208853
271: from po_lookup_codes plc_sta,
272: po_lookup_codes plc_can,
273: po_lookup_codes plc_clo,
274: po_lookup_codes plc_fro,
275: po_lookup_codes plc_hld,
276: po_headers_all poh -- Bug 3208853
277: where plc_sta.lookup_code =
270: l_org_id -- Bug 3208853
271: from po_lookup_codes plc_sta,
272: po_lookup_codes plc_can,
273: po_lookup_codes plc_clo,
274: po_lookup_codes plc_fro,
275: po_lookup_codes plc_hld,
276: po_headers_all poh -- Bug 3208853
277: where plc_sta.lookup_code =
278: decode(poh.approved_flag,
271: from po_lookup_codes plc_sta,
272: po_lookup_codes plc_can,
273: po_lookup_codes plc_clo,
274: po_lookup_codes plc_fro,
275: po_lookup_codes plc_hld,
276: po_headers_all poh -- Bug 3208853
277: where plc_sta.lookup_code =
278: decode(poh.approved_flag,
279: 'R', poh.approved_flag,