DBA Data[Home] [Help]

APPS.CTO_OSS_SOURCE_PK dependencies on MRP_SOURCES_V

Line 6231: from mrp_sources_v msv

6227: sourcing_rule_id,
6228: nvl(source_type,1) source_type,
6229: assignment_type,
6230: assignment_id
6231: from mrp_sources_v msv
6232: where msv.assignment_set_id = g_def_assg_set
6233: and msv.inventory_item_id = p_item_id
6234: and msv.organization_id = p_org_id
6235: and nvl(effective_date,sysdate) <= nvl(disable_date, sysdate)