APPS.PO_SOURCING_SV dependencies on MRP_SOURCES_V

Line 375: from mrp_sources_v sv

371: -- item in some org.
372:
373: select 'exists' into
374: temp
375: from mrp_sources_v sv
376: where sv.inventory_item_id = X_item_id
377: and sv.vendor_id = X_vendor_id
378: and nvl(sv.vendor_site_id, -1) = nvl(X_vendor_site_id, -1)
379: and sv.assignment_set_id = X_assignment_set_id

Line 387: from mrp_sources_v sv

383:
384: elsif (X_autosource_rule_id is null) then
385: select 'exists' into
386: temp
387: from mrp_sources_v sv
388: where sv.inventory_item_id = X_item_id
389: and sv.vendor_id = X_vendor_id
390: and nvl(sv.vendor_site_id, -1) = nvl(X_vendor_site_id, -1)
391: and sv.assignment_set_id = X_assignment_set_id

Line 401: from mrp_sources_v sv

397: else
398:
399: select 'exists' into
400: temp
401: from mrp_sources_v sv
402: where sv.inventory_item_id = X_item_id
403: and sv.sourcing_rule_id = X_autosource_rule_id
404: and sv.vendor_id = X_vendor_id
405: and nvl(sv.vendor_site_id, -1) = nvl(X_vendor_site_id, -1)