DBA Data[Home] [Help]

APPS.MRP_SOURCING_API_PK dependencies on MRP_ITEM_SOURCING_LEVELS_V

Line 87: FROM mrp_item_sourcing_levels_v misl

83: misl.source_organization_id,
84: misl.allocation_percent,
85: NVL(misl.rank, 9999),
86: misl.sourcing_rule_id
87: FROM mrp_item_sourcing_levels_v misl
88: WHERE misl.source_type in (1,3)
89: and misl.inventory_item_id = arg_item_id
90: and misl.organization_id = arg_dest_organization_id
91: and misl.assignment_set_id = var_set_id

Line 493: mrp_item_sourcing_levels_v misl

489: CURSOR sr IS
490: SELECT distinct misl.sourcing_rule_name, ml.meaning
491: FROM
492: mfg_lookups ml,
493: mrp_item_sourcing_levels_v misl
494: WHERE misl.inventory_item_id = NVL(arg_item_id, misl.inventory_item_id)
495: and NVL(misl.category_id,-1) = NVL(arg_category_id, NVL(misl.category_id, -1))
496: and misl.vendor_id = arg_supplier_id
497: and NVL(misl.vendor_site_id,-1) = NVL(arg_supplier_site_id,-1)