[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT mx.inventory_item_id, mx.uom_code, mr.revision
INTO x_item_id, x_uom_code, x_revision
FROM MTL_CROSS_REFERENCES mx, MTL_ITEM_REVISIONS_B mr
WHERE mx.organization_id = mr.organization_id(+)
and mx.inventory_item_id = mr.inventory_item_id(+)
and mx.revision_id = mr.revision_id(+)
and mx.cross_reference_type = g_gtin_cross_ref_type
and mx.cross_reference = p_cross_reference
and nvl(mx.organization_id, p_org_id) = p_org_id
and rownum = 1;
SELECT msi.concatenated_segments, mx.uom_code, mr.revision
INTO x_concatenated_segments, x_uom_code, x_revision
FROM MTL_CROSS_REFERENCES mx, MTL_ITEM_REVISIONS_B mr,
mtl_system_items_kfv msi
WHERE mx.organization_id = mr.organization_id(+)
and mx.inventory_item_id = mr.inventory_item_id(+)
and mx.revision_id = mr.revision_id(+)
and mx.cross_reference_type = g_gtin_cross_ref_type
and mx.cross_reference LIKE lpad(Rtrim(p_cross_reference,'%'),
g_gtin_code_length, '00000000000000')
and nvl(mx.organization_id, p_org_id) = p_org_id
and msi.organization_id = p_org_id
and msi.inventory_item_id = mx.inventory_item_id
and rownum = 1;
SELECT total_lpn_length
, ucc_128_suffix_flag
INTO x_ucc_128_attributes.total_lpn_length
, x_ucc_128_attributes.ucc_128_suffix_flag
FROM mtl_parameters
WHERE organization_id = x_ucc_128_attributes.organization_id;