[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT organization_id,
name
INTO gOperatingUnitId,
gOperatingUnitName
FROM hr_operating_units
WHERE organization_id = pOperatingUnitId;
SELECT organization_id,
name
INTO gInventoryOrgId,
gInventoryOrgName
FROM hr_all_organization_units
WHERE organization_id = pInventoryOrgId;
SELECT category_id,
web_status,
start_date_active,
end_date_active,
disable_date
INTO xCategoryId,
xWebEnabledFlag,
xStartDate,
xEndDate,
xDisableDate
FROM mtl_categories_kfv
WHERE structure_id = gStructureId
AND concatenated_segments = pValue;
SELECT VALID_FOR_EXTRACT
INTO xStatus
FROM mtl_category_set_valid_cats
WHERE category_set_id = gCategorySetId
AND category_id = xCategoryId;
SELECT inactive_date
INTO xInactiveDate
FROM po_reqexpress_headers_all
WHERE express_name = pValue
AND rownum = 1;
SELECT VALID_FOR_EXTRACT,
rt_category_id
INTO xStatus,
xRtCategoryId
FROM icx_cat_categories_tl
WHERE key = to_char(pCategoryId)
AND type = ICX_POR_EXT_CLASS.CATEGORY_TYPE
AND rownum = 1;
SELECT concatenated_segments
INTO xCategoryName
FROM mtl_categories_kfv
WHERE category_id = pCategoryId
AND rownum = 1;
SELECT VALID_FOR_EXTRACT,
rt_category_id
INTO xStatus,
xRtCategoryId
FROM icx_cat_categories_tl
WHERE key = pTemplateName||'_tmpl'
AND type = ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE
AND rownum = 1;
SELECT pl.po_line_id,
getContractLineStatus(pl.po_line_id,
ICX_POR_EXT_TEST.gTestMode),
NVL(mi.concatenated_segments, pl.item_description),
pl.category_id
INTO xContractLineId,
xStatus,
xItemNum,
xCategoryId
FROM po_headers_all ph,
po_lines_all pl,
financials_system_params_all fsp,
mtl_system_items_kfv mi
WHERE ph.segment1 = pPONum
AND (ph.org_id is null and pOperatingUnitId is null or ph.org_id = pOperatingUnitId)
AND ph.type_lookup_code = pType
AND ph.po_header_id = pl.po_header_id
AND pl.line_num = TO_NUMBER(pLineNum)
AND (ph.org_id is null and fsp.org_id is null or ph.org_id = fsp.org_id)
AND fsp.inventory_organization_id = NVL(mi.organization_id,
fsp.inventory_organization_id)
AND pl.item_id = mi.inventory_item_id (+)
AND rownum = 1;
SELECT getTemplateLineStatus(prl.express_name,
prl.sequence_num,
prl.org_id,
prh.inactive_date,
prl.po_line_id,
ICX_POR_EXT_TEST.gTestMode),
NVL(mi.concatenated_segments, prl.item_description),
prl.category_id
INTO xStatus,
xItemNum,
xCategoryId
FROM po_reqexpress_headers_all prh,
po_reqexpress_lines_all prl,
financials_system_params_all fsp,
mtl_system_items_kfv mi
WHERE prh.express_name = pTemplateName
AND (prh.org_id is null and pOperatingUnitId is null or prh.org_id = pOperatingUnitId)
AND prl.express_name = prh.express_name
AND (prh.org_id is null and prl.org_id is null or prl.org_id = prh.org_id)
AND prl.sequence_num = TO_NUMBER(pLineNum)
AND (prh.org_id is null and fsp.org_id is null or prh.org_id = fsp.org_id)
AND fsp.inventory_organization_id = NVL(mi.organization_id,
fsp.inventory_organization_id)
AND prl.item_id = mi.inventory_item_id (+)
AND rownum = 1;
SELECT getASLStatus(pasl.asl_id,
pasl.disable_flag,
pasl.asl_status_id,
mi.list_price_per_unit,
ICX_POR_EXT_TEST.gTestMode),
pv.vendor_name,
mi.concatenated_segments,
NVL(pasl.category_id, mic.category_id),
hr.name
INTO xStatus,
xSupplier,
xItemNum,
xCategoryId,
xOrgName
FROM po_approved_supplier_list pasl,
po_vendors pv,
financials_system_params_all fsp,
mtl_system_items_kfv mi,
mtl_item_categories mic,
hr_all_organization_units hr
WHERE pasl.asl_id = pASLId
AND (fsp.org_id is null and pOperatingUnitId is null or fsp.org_id = pOperatingUnitId)
AND fsp.inventory_organization_id = pasl.owning_organization_id
AND pasl.vendor_id = pv.vendor_id
AND fsp.inventory_organization_id = mi.organization_id
AND pasl.item_id = mi.inventory_item_id
AND mic.category_set_id = gCategorySetId
AND mic.inventory_item_id = mi.inventory_item_id
AND mic.organization_id = mi.organization_id
AND mi.organization_id = hr.organization_id
AND rownum = 1;
SELECT getPurchasingItemStatus(mi.purchasing_enabled_flag,
mi.outside_operation_flag,
mi.list_price_per_unit,
ICX_POR_EXT_TEST.gTestMode),
getInternalItemStatus(mi.internal_order_enabled_flag,
ICX_POR_EXT_TEST.gTestMode),
mi.inventory_item_id,
mic.category_id,
hr.name
INTO xStatus1,
xStatus2,
xItemId,
xCategoryId,
xOrgName
FROM financials_system_params_all fsp,
mtl_system_items_kfv mi,
mtl_item_categories mic,
hr_all_organization_units hr
WHERE (fsp.org_id is null and pOperatingUnitId is null or fsp.org_id = pOperatingUnitId)
AND fsp.inventory_organization_id = mi.organization_id
AND mi.concatenated_segments = pItemNum
AND mic.category_set_id = gCategorySetId
AND mic.inventory_item_id = mi.inventory_item_id
AND mic.organization_id = mi.organization_id
AND mi.organization_id = hr.organization_id
AND rownum = 1;
SELECT NVL(load_item_master, 'N'),
NVL(load_internal_item, 'N')
INTO xLoadPurchasing,
xLoadInternal
FROM icx_por_loader_values;
SELECT category_set_id,
validate_flag,
structure_id
INTO gCategorySetId,
gValidateFlag,
gStructureId
FROM mtl_default_sets_view
WHERE functional_area_id = 2;
SELECT business_group_id
INTO xBusinessGroupId
FROM per_business_groups_perf
WHERE name = pBusinessGroup;
SELECT organization_id
INTO xOperatingUnitId
FROM hr_operating_units
WHERE business_group_id = xBusinessGroupId
AND name = pOperatingUnit;
SELECT category_set_id,
validate_flag,
structure_id
INTO gCategorySetId,
gValidateFlag,
gStructureId
FROM mtl_default_sets_view
WHERE functional_area_id = 2;
'SELECT ' || VALID_FOR_EXTRACT || ' ';
' EXISTS (SELECT ''current approved effective price break'' ';
'SELECT decode(mi.inventory_item_id, ' ||
' NULL, ' || VALID_FOR_EXTRACT || ', ' ||
' decode(NVL(mi.purchasing_enabled_flag, ''N''), ' ||
' ''N'', ' || INVALID_BLANKET_LINE || ', ' ||
' ' || VALID_FOR_EXTRACT || ')) ' ||
'FROM ';
'SELECT ph.type_lookup_code, ' ||
'ph.approved_date, ' ||
'ph.approved_flag, ' ||
'ph.cancel_flag, ' ||
'ph.frozen_flag, ' ||
'ph.closed_code, ' ||
'pl.closed_code, ' ||
'pl.cancel_flag, ' ||
'ph.status_lookup_code, ' ||
'ph.quotation_class_code, ' ||
'ph.start_date, ' ||
'ph.end_date, ' ||
'pl.expiration_date ';
SELECT VALID_FOR_EXTRACT
INTO xStatus
FROM dual
WHERE EXISTS (SELECT 'same UOM class'
FROM mtl_units_of_measure uom1,
mtl_units_of_measure uom2,
mtl_units_of_measure uom3
WHERE uom1.uom_code = p_uom_code
AND uom2.uom_code = p_local_uom_code
AND uom3.uom_code = p_purchasing_uom_code
AND uom1.uom_class = uom2.uom_class
AND uom1.uom_class = uom3.uom_class);
'SELECT decode(mi.inventory_item_id, NULL, ' ||
VALID_FOR_EXTRACT || ', ' ||
'decode(NVL(mi.purchasing_enabled_flag, ''N''), ''N'', ' ||
'decode(NVL(mi.internal_order_enabled_flag, ''N''), ''Y'', ' ||
'decode(prl.source_type_code, ''INVENTORY'', ' ||
VALID_FOR_EXTRACT || ', ' ||
INVALID_TEMPLATE_LINE || '), ' ||
INVALID_TEMPLATE_LINE || '), ' ||
VALID_FOR_EXTRACT || ')) ' ||
'FROM ';
'SELECT ' || VALID_FOR_EXTRACT || ' ';
'SELECT decode(mi.inventory_item_id, ' ||
' NULL, ' || VALID_FOR_EXTRACT || ', ' ||
' decode(NVL(mi.purchasing_enabled_flag, ''N''), ' ||
' ''N'', ' || INVALID_ASL || ', ' ||
' ' || VALID_FOR_EXTRACT || ')) ' ||
'FROM ';
'SELECT prl.express_name, '||
'prl.sequence_num, '||
'prl.org_id, '||
'prh.inactive_date, '||
'p.contract_line_id '||
'FROM icx_cat_item_prices p, ';
SELECT contract_line_id
INTO l_contract_line_id
FROM icx_cat_item_prices
WHERE rowid = p_row_id;
'SELECT t.enabled_flag, '||
'pvs.purchasing_site_flag, '||
'pvs.inactive_date, '||
'mi.purchasing_enabled_flag, '||
'mi.outside_operation_flag, '||
'p.unit_of_measure, '||
'mi.primary_uom_code, '||
'mi2.purchasing_enabled_flag, '||
'mi2.outside_operation_flag, '||
'mi2.primary_uom_code '||
'FROM icx_cat_item_prices p, ';
'SELECT pasl.asl_id, '||
'pasl.disable_flag, '||
'pasl.asl_status_id, '||
'mi.list_price_per_unit '||
'FROM icx_cat_item_prices p, ';
'SELECT mi.purchasing_enabled_flag, '||
'mi.outside_operation_flag, '||
'mi.list_price_per_unit '||
'FROM icx_cat_item_prices p, ';
'SELECT mi.internal_order_enabled_flag '||
'FROM icx_cat_item_prices p, ';