DBA Data[Home] [Help]

APPS.CTO_OSS_SOURCE_PK dependencies on MRP_SOURCES_V

Line 5550: from mrp_sources_v msv

5546: sourcing_rule_id,
5547: nvl(source_type,1) source_type,
5548: assignment_type,
5549: assignment_id
5550: from mrp_sources_v msv
5551: where msv.assignment_set_id = g_def_assg_set
5552: and msv.inventory_item_id = p_item_id
5553: and msv.organization_id = p_org_id
5554: and nvl(effective_date,sysdate) <= nvl(disable_date, sysdate)