[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT set_of_books_id
INTO X_set_of_books_id
FROM financials_system_parameters;
select
ph.pay_on_code,
lk.displayed_field,
PH.shipping_control, --
PH.SUPPLY_AGREEMENT_FLAG, --Bug#3514141
PH.CONFIRMING_ORDER_FLAG --Bug#3514141
into
x_pay_on_code,
x_pay_on_dsp,
x_shipping_control, --
x_supply_agreement_flag, --Bug#3514141
x_confirming_order_flag --Bug#3514141
from
po_headers ph,
po_lookup_codes lk
where
ph.po_header_id = X_po_header_id AND
lk.lookup_type (+) = 'PAY ON CODE' AND
lk.lookup_code (+) = ph.pay_on_code;
SELECT nvl(SUM((quantity-quantity_cancelled) * price_override), 0)
into X_rel_total
FROM po_line_locations
WHERE po_release_id = X_release_id;
SELECT plc_sta.displayed_field,
decode(por.cancel_flag,
'Y', plc_can.displayed_field, NULL),
decode(nvl(por.closed_code, 'OPEN'), 'OPEN', NULL,
plc_clo.displayed_field),
decode(por.frozen_flag,
'Y', plc_fro.displayed_field, NULL),
decode(por.hold_flag,
'Y', plc_hld.displayed_field, NULL),
por.authorization_status,
nvl(por.cancel_flag, 'N'),
nvl(por.closed_code, 'OPEN'),
nvl(por.frozen_flag, 'N'),
nvl(por.hold_flag, 'N')
into x_status_code,
x_cancel_status,
x_closed_status,
x_frozen_status,
x_hold_status,
x_auth_status,
x_cancel_flag,
x_closed_code,
x_frozen_flag,
x_user_hold_flag
from po_releases por,
po_lookup_codes plc_sta,
po_lookup_codes plc_can,
po_lookup_codes plc_clo,
po_lookup_codes plc_fro,
po_lookup_codes plc_hld
where plc_sta.lookup_code =
decode(por.approved_flag,
'R', por.approved_flag,
nvl(por.authorization_status,'INCOMPLETE'))
and plc_sta.lookup_type in ('PO APPROVAL', 'DOCUMENT STATE')
and plc_can.lookup_code = 'CANCELLED'
and plc_can.lookup_type = 'DOCUMENT STATE'
and plc_clo.lookup_code = nvl(por.closed_code, 'OPEN')
and plc_clo.lookup_type = 'DOCUMENT STATE'
and plc_fro.lookup_code = 'FROZEN'
and plc_fro.lookup_type = 'DOCUMENT STATE'
and plc_hld.lookup_code = 'ON HOLD'
and plc_hld.lookup_type = 'DOCUMENT STATE'
and por.po_release_id = X_po_release_id;
SELECT x_status_code||
decode(x_closed_code, 'OPEN', '',
x_delimiter||x_closed_status)||
decode(x_cancel_flag, 'N', '', '', '',
x_delimiter||x_cancel_status)||
decode(x_frozen_flag, 'N', '', '', '',
x_delimiter||x_frozen_status)||
decode(x_user_hold_flag, 'N', '', '', '',
x_delimiter||x_hold_status)||
decode(x_reserved_flag, 'N', '', '', '',
x_delimiter||x_reserved_status)
INTO X_status
FROM dual;