85: x_supply_agreement_flag, --Bug#3514141
86: x_confirming_order_flag --Bug#3514141
87: from
88: po_headers ph,
89: po_lookup_codes lk
90: where
91: ph.po_header_id = X_po_header_id AND
92: lk.lookup_type (+) = 'PAY ON CODE' AND
93: lk.lookup_code (+) = ph.pay_on_code;
177: x_closed_code,
178: x_frozen_flag,
179: x_user_hold_flag
180: from po_releases por,
181: po_lookup_codes plc_sta,
182: po_lookup_codes plc_can,
183: po_lookup_codes plc_clo,
184: po_lookup_codes plc_fro,
185: po_lookup_codes plc_hld
178: x_frozen_flag,
179: x_user_hold_flag
180: from po_releases por,
181: po_lookup_codes plc_sta,
182: po_lookup_codes plc_can,
183: po_lookup_codes plc_clo,
184: po_lookup_codes plc_fro,
185: po_lookup_codes plc_hld
186: where plc_sta.lookup_code =
179: x_user_hold_flag
180: from po_releases por,
181: po_lookup_codes plc_sta,
182: po_lookup_codes plc_can,
183: po_lookup_codes plc_clo,
184: po_lookup_codes plc_fro,
185: po_lookup_codes plc_hld
186: where plc_sta.lookup_code =
187: decode(por.approved_flag,
180: from po_releases por,
181: po_lookup_codes plc_sta,
182: po_lookup_codes plc_can,
183: po_lookup_codes plc_clo,
184: po_lookup_codes plc_fro,
185: po_lookup_codes plc_hld
186: where plc_sta.lookup_code =
187: decode(por.approved_flag,
188: 'R', por.approved_flag,
181: po_lookup_codes plc_sta,
182: po_lookup_codes plc_can,
183: po_lookup_codes plc_clo,
184: po_lookup_codes plc_fro,
185: po_lookup_codes plc_hld
186: where plc_sta.lookup_code =
187: decode(por.approved_flag,
188: 'R', por.approved_flag,
189: nvl(por.authorization_status,'INCOMPLETE'))