[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT stock_enabled_flag, restrict_subinventories_code
INTO var_stk,
var_restrict
FROM mtl_system_items
WHERE organization_id = arg_org_id
AND inventory_item_id = arg_item_id;
SELECT 'Y'
into var_stk
FROM mtl_item_sub_inventories
WHERE organization_id = arg_org_id
AND inventory_item_id = arg_item_id
AND secondary_inventory = arg_sub_inv;
SELECT misl.vendor_id,
misl.vendor_site_id,
misl.source_organization_id,
misl.allocation_percent,
NVL(misl.rank, 9999),
misl.sourcing_rule_id
FROM mrp_item_sourcing_levels_v misl
WHERE misl.source_type in (1,3)
AND misl.inventory_item_id = p_item_id
AND misl.organization_id = p_dest_organization_id
AND misl.assignment_set_id = var_set_id
AND p_autosource_date between misl.effective_date AND
NVL(disable_date, to_date(2634525, 'J'))
AND PO_ASL_SV.check_asl_action('2_SOURCING',
misl.vendor_id, misl.vendor_site_id, p_item_id, -1
, p_dest_organization_id ) <> 0
AND nvl(nvl(p_source_organization_id,
misl.source_organization_id), -23453)
= nvl(misl.source_organization_id, -23453)
ORDER BY misl.sourcing_level ASC,
allocation_percent DESC, NVL(misl.rank, 9999) ASC;
SELECT misi.source_organization_id,
misi.source_subinventory
INTO var_source_org,
var_source_sub
FROM mtl_item_sub_inventories misi,
org_organization_definitions ood,
financials_system_parameters fsp
WHERE misi.organization_id = p_dest_organization_id
AND misi.inventory_item_id = p_item_id
AND misi.secondary_inventory = p_dest_subinventory
AND misi.organization_id = ood.organization_id
AND ood.set_of_books_id = fsp.set_of_books_id
AND ood.operating_unit = fsp.org_id -- bug 4968383
AND NVL(x_source_organization_id,
misi.source_organization_id) = misi.source_organization_id;
SELECT msi.source_organization_id,
msi.source_subinventory
INTO var_source_org,
var_source_sub
FROM mtl_secondary_inventories msi,
org_organization_definitions ood,
financials_system_parameters fsp
WHERE msi.organization_id = p_dest_organization_id
AND msi.secondary_inventory_name = p_dest_subinventory
AND msi.organization_id = ood.organization_id
AND ood.set_of_books_id = fsp.set_of_books_id
AND ood.operating_unit = fsp.org_id -- bug 4968383
AND NVL(x_source_organization_id,
msi.source_organization_id) = msi.source_organization_id;
SELECT msi.source_organization_id,
msi.source_subinventory
INTO var_source_org,
var_source_sub
FROM mtl_system_items msi,
org_organization_definitions ood,
financials_system_parameters fsp
WHERE msi.organization_id = p_dest_organization_id
AND msi.inventory_item_id = p_item_id
AND msi.organization_id = ood.organization_id
AND ood.operating_unit = fsp.org_id -- bug 4968383
AND ood.set_of_books_id = fsp.set_of_books_id;
SELECT mp.source_organization_id,
mp.source_subinventory
INTO var_source_org,
var_source_sub
FROM mtl_parameters mp,
org_organization_definitions ood,
financials_system_parameters fsp
WHERE mp.organization_id = p_dest_organization_id
AND mp.organization_id = ood.organization_id
AND ood.operating_unit = fsp.org_id -- bug 4968383
AND ood.set_of_books_id = fsp.set_of_books_id;
SELECT site.vendor_site_code
INTO var_new_site_code
FROM
po_vendor_sites_all site,
po_vendors ven
WHERE NVL(ven.enabled_flag, 'N') = 'Y'
AND SYSDATE BETWEEN NVL(ven.start_date_active, SYSDATE -1)
AND NVL(ven.end_date_active, sysdate+1)
AND SYSDATE < NVL(site.inactive_date, SYSDATE + 1)
AND ven.vendor_id = site.vendor_id(+)
AND site.vendor_site_id(+) = var_site_id
AND ven.vendor_id = var_vendor_id ;
fnd_message.set_name('MRP', 'GEN-CANNOT SELECT');
fnd_message.set_token('SELECT', 'EC_SOURCE', TRUE);
fnd_message.set_name('MRP', 'GEN-NO ROWS SELECTED');