[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT intf_price_diffs.price_diff_interface_id,
intf_price_diffs.interface_line_id,
intf_price_diffs.interface_header_id,
intf_price_diffs.price_differential_num,
intf_price_diffs.price_type,
intf_price_diffs.entity_type,
intf_price_diffs.entity_id,
intf_price_diffs.multiplier,
intf_price_diffs.min_multiplier,
intf_price_diffs.max_multiplier,
-- attributes read from line location record
intf_locs.line_location_id,
-- attributes read from line record
intf_lines.po_line_id,
-- attributes read from header record
intf_headers.draft_id,
NVL(draft_headers.style_id, txn_headers.style_id),
-- set initial value for error_flag
FND_API.g_FALSE
FROM PO_PRICE_DIFF_INTERFACE intf_price_diffs,
PO_LINE_LOCATIONS_INTERFACE intf_locs,
PO_LINES_INTERFACE intf_lines,
PO_HEADERS_INTERFACE intf_headers,
PO_LINES_DRAFT_ALL draft_lines,
PO_HEADERS_DRAFT_ALL draft_headers,
PO_HEADERS_ALL txn_headers
WHERE intf_price_diffs.interface_line_id = intf_lines.interface_line_id
AND intf_lines.interface_header_id = intf_headers.interface_header_id
AND intf_lines.po_line_id = draft_lines.po_line_id
AND intf_headers.draft_id = draft_lines.draft_id
AND intf_headers.po_header_id = draft_headers.po_header_id(+)
AND intf_headers.draft_id = draft_headers.draft_id(+)
AND intf_headers.po_header_id = txn_headers.po_header_id(+)
AND draft_lines.order_type_lookup_code = 'RATE'
AND intf_price_diffs.interface_line_location_id = intf_locs.interface_line_location_id(+)
AND intf_price_diffs.processing_id = PO_PDOI_PARAMS.g_processing_id
AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
AND intf_price_diffs.price_diff_interface_id > p_max_intf_price_diff_id
AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
<> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
ORDER BY intf_price_diffs.price_diff_interface_id;
DELETE FROM PO_INTERFACE_ERRORS
WHERE price_diff_interface_id = l_remove_err_price_diff_tbl(i)
AND interface_line_id = l_remove_err_line_tbl(i);