[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT oracle_username
INTO g_apps_schema_name
FROM fnd_oracle_userid
WHERE read_only_flag = 'U';
SELECT key, index_num1, index_num2,
index_char1, index_char2,
char1, char2, char3
FROM po_session_gt
WHERE key = p_key;
l_key_tbl.DELETE;
l_index_num1_tbl.DELETE;
l_index_num2_tbl.DELETE;
l_index_char1_tbl.DELETE;
l_index_char2_tbl.DELETE;
l_char1_tbl.DELETE;
l_char2_tbl.DELETE;
l_char3_tbl.DELETE;
SELECT inventory_item_id, organization_id, revision_id,
category_id, category_set_id
FROM mtl_item_bulkload_recs
WHERE request_id = p_request_id;
l_inventory_item_id_tbl.DELETE;
l_organization_id_tbl.DELETE;
l_revision_id_tbl.DELETE;
l_category_id_tbl.DELETE;
l_category_set_id_tbl.DELETE;
SELECT to_number(external_source_key)
INTO l_po_category_id
FROM icx_por_category_order_map
WHERE rt_category_id = p_category_id;
SELECT icx_cat_items_ctx_requestid_s.nextval
INTO l_internal_request_id
FROM dual;
SELECT language_code
INTO g_base_language
FROM fnd_languages
WHERE installed_flag='B';
SELECT category_set_id,
validate_flag,
structure_id
INTO g_category_set_id,
g_validate_flag,
g_structure_id
FROM mtl_default_sets_view
WHERE functional_area_id = 2;
SELECT application_column_name
BULK COLLECT INTO l_appl_column_name_tbl
FROM fnd_id_flex_segments
WHERE application_id = 401
AND id_flex_code = 'MSTK'
AND id_flex_num = 101
AND enabled_flag = 'Y'
ORDER BY segment_num;
SELECT concatenated_segment_delimiter
INTO l_delimiter
FROM fnd_id_flex_structures
WHERE application_id = 401
AND id_flex_code = 'MSTK'
AND id_flex_num = 101
AND enabled_flag = 'Y';
SELECT NVL(MIN(job_number), 1)
INTO l_upgrade_job_number
FROM icx_cat_r12_upgrade_jobs;
SELECT start_date_active, end_date_active, disable_date
INTO l_start_date, l_end_date, l_disable_date
FROM mtl_categories_kfv
WHERE category_id = p_category_id;
SELECT prh.inactive_date, prl.po_line_id, prl.item_id
INTO l_inactive_date, l_po_line_id, l_item_id
FROM po_reqexpress_headers_all prh, po_reqexpress_lines_all prl
WHERE prh.express_name = p_req_template_name
AND prh.org_id = p_org_id
AND prl.express_name = prh.express_name
AND prl.org_id = prh.org_id
AND prl.sequence_num = TO_NUMBER(p_req_template_line_num);
SELECT COUNT(*)
INTO l_status
FROM mtl_system_items_b msi, financials_system_params_all fsp
WHERE msi.INVENTORY_ITEM_ID = l_item_id
AND msi.ORGANIZATION_ID = fsp.INVENTORY_ORGANIZATION_ID
AND fsp.ORG_ID = p_org_id
AND (msi.purchasing_enabled_flag = 'Y'
OR msi.internal_order_enabled_flag = 'Y' );
SELECT ph.authorization_status
INTO l_auth_status
FROM PO_HEADERS_ALL_SEC ph,PO_LINES_ALL pl
WHERE pl.po_line_id=p_po_line_id
AND ph.po_header_id = pl.po_header_id;
select max(REVISION_NUM)
into l_revision
from po_lines_archive_all
where po_line_id=p_po_line_id;
SELECT 1
INTO l_status
FROM po_headers_archive_all ph, po_lines_archive_all pl
WHERE pl.po_line_id = p_po_line_id
AND ph.LATEST_EXTERNAL_FLAG = 'Y'
AND pl.REVISION_NUM = l_revision
AND ph.po_header_id = pl.po_header_id
AND ph.approved_date IS NOT NULL
AND ph.authorization_status NOT IN ('REJECTED', 'INCOMPLETE')
AND NVL(ph.user_hold_flag, 'N') <> 'Y'
AND NVL(ph.cancel_flag, 'N') <> 'Y'
AND NVL(ph.frozen_flag, 'N') <> 'Y'
AND NVL(ph.closed_code, 'OPEN') NOT IN ('CLOSED', 'FINALLY CLOSED')
AND NVL(pl.closed_code, 'OPEN') NOT IN ('CLOSED', 'FINALLY CLOSED')
AND NVL(pl.cancel_flag, 'N') <> 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(ph.start_date), TRUNC( SYSDATE - 1))
AND NVL(TRUNC(ph.end_date), TRUNC( SYSDATE + 1))
AND TRUNC(SYSDATE) <= NVL(TRUNC(pl.expiration_date), TRUNC( SYSDATE+1))
--Bug:#14370992 begin
AND Decode (pl.item_id, NULL, 1,
(SELECT Count(*)
FROM mtl_system_items_b msi,
financials_system_params_all fsp
WHERE msi.INVENTORY_ITEM_ID = pl.ITEM_ID
AND msi.ORGANIZATION_ID = fsp.INVENTORY_ORGANIZATION_ID
AND p_org_id = fsp.ORG_ID
AND (msi.purchasing_enabled_flag = 'Y'
OR msi.internal_order_enabled_flag = 'Y'))) = 1;
SELECT 1
INTO l_status
FROM PO_HEADERS_ALL_SEC ph, po_lines_all pl
WHERE pl.po_line_id = p_po_line_id
AND ph.po_header_id = pl.po_header_id
AND ph.approved_date IS NOT NULL
AND ph.authorization_status NOT IN ('REJECTED', 'INCOMPLETE')
AND NVL(ph.user_hold_flag, 'N') <> 'Y'
AND NVL(ph.cancel_flag, 'N') <> 'Y'
AND NVL(ph.frozen_flag, 'N') <> 'Y'
AND NVL(ph.closed_code, 'OPEN') NOT IN ('CLOSED', 'FINALLY CLOSED')
AND NVL(pl.closed_code, 'OPEN') NOT IN ('CLOSED', 'FINALLY CLOSED')
AND NVL(pl.cancel_flag, 'N') <> 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(ph.start_date), TRUNC( SYSDATE - 1))
AND NVL(TRUNC(ph.end_date), TRUNC( SYSDATE + 1))
AND TRUNC(SYSDATE) <= NVL(TRUNC(pl.expiration_date), TRUNC( SYSDATE+1))
AND Decode (pl.item_id, NULL, 1,
(SELECT Count(*)
FROM mtl_system_items_b msi,
financials_system_params_all fsp
WHERE msi.INVENTORY_ITEM_ID = pl.ITEM_ID
AND msi.ORGANIZATION_ID = fsp.INVENTORY_ORGANIZATION_ID
AND p_org_id = fsp.ORG_ID --Bug:#14370992
AND (msi.purchasing_enabled_flag = 'Y'
OR msi.internal_order_enabled_flag = 'Y'))) = 1;
SELECT 1
INTO l_status
FROM PO_HEADERS_ALL_SEC ph, po_lines_all pl
WHERE pl.po_line_id = p_po_line_id
AND ph.po_header_id = pl.po_header_id
AND ph.status_lookup_code = 'A'
AND ph.quotation_class_code = 'CATALOG'
AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(ph.start_date), TRUNC( SYSDATE - 1))
AND NVL(TRUNC(ph.end_date), TRUNC( SYSDATE + 1))
AND (NVL(ph.approval_required_flag, 'N') = 'N'
OR
(ph.approval_required_flag = 'Y' AND
EXISTS (SELECT 'current approved effective price break'
FROM po_line_locations_all pll, po_quotation_approvals_all pqa
WHERE pl.po_line_id = pll.po_line_id
AND SYSDATE BETWEEN NVL(pll.start_date, SYSDATE-1) AND
NVL(pll.end_date, SYSDATE+1)
AND pqa.line_location_id = pll.line_location_id
AND pqa.approval_type IS NOT NULL
AND SYSDATE BETWEEN NVL(pqa.start_date_active, SYSDATE-1)
AND NVL(pqa.end_date_active, SYSDATE+1))))
AND TRUNC(SYSDATE) < NVL(TRUNC(pl.expiration_date), TRUNC( SYSDATE+1))
AND 1 = CASE WHEN pl.item_id IS NOT NULL THEN (SELECT Count(*)
FROM mtl_system_items_b msi,
financials_system_params_all fsp
WHERE msi.INVENTORY_ITEM_ID = pl.ITEM_ID
AND msi.ORGANIZATION_ID = fsp.INVENTORY_ORGANIZATION_ID
AND pl.org_id = fsp.ORG_ID
AND (msi.purchasing_enabled_flag = 'Y'
OR msi.internal_order_enabled_flag = 'Y'))
WHEN pl.item_id IS NULL THEN 1 END;
select count(*)
into l_count
from po_headers_all_sec
where po_header_id = p_header_id;
select count(*)
into l_count
from po_headers_all_sec poh,
po_lines_all pol
where poh.po_header_id = pol.po_header_id
and pol.po_line_id = p_line_id;