[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ph.segment1|| DECODE(pr.release_num, NULL, '', '-' || pr.release_num)
INTO l_po_num
FROM
po_releases_all pr,
po_headers_all ph,
po_line_locations_all pll
WHERE
pll.line_location_id=p_line_location_id AND
pll.po_header_id = ph.po_header_id AND
pll.po_release_id = pr.po_release_id(+);
SELECT ooh.order_number
INTO l_so_number
from po_requisition_lines_all prl,
po_requisition_headers_all prh,
oe_order_headers_all ooh,
-- oe_order_lines_all ool,
po_system_parameters_all psp
WHERE prl.requisition_header_id = prh.requisition_header_id
AND prl.requisition_line_id = p_req_line_id
AND prh.requisition_header_id = ooh.source_document_id
AND prh.segment1 = ooh.orig_sys_document_ref
-- AND ool.header_id = ooh.header_id
-- AND ool.orig_sys_line_ref = TO_CHAR(prl.line_num)
AND psp.org_id = prh.org_id
AND psp.order_source_id = ooh.order_source_id;
SELECT code_combination_id
FROM po_req_distributions_all
WHERE requisition_line_id = p_req_line_id;
SELECT fs.segment_num, gls.chart_of_accounts_id
INTO l_segment_num, l_account_id
FROM FND_ID_FLEX_SEGMENTS fs,
fnd_segment_attribute_values fsav,
financials_system_params_all fsp,
gl_sets_of_books gls,
po_requisition_lines_all prl
WHERE prl.requisition_line_id = p_req_line_id AND
--added NVL check for single org, bug#6705513
NVL(prl.org_id,-99) = NVL(fsp.org_id,-99) AND
fsp.set_of_books_id = gls.set_of_books_id AND
fsav.id_flex_num = gls.chart_of_accounts_id AND
fsav.id_flex_code = 'GL#' AND
fsav.application_id = 101 AND
fsav.segment_attribute_type = 'FA_COST_CTR' AND
fsav.id_flex_num = fs.id_flex_num AND
fsav.id_flex_code = fs.id_flex_code AND
fsav.application_id = fs.application_id AND
fsav.application_column_name = fs.application_column_name AND
fsav.attribute_value='Y';