DBA Data[Home] [Help]

APPS.MSC_SNAPSHOT_PK dependencies on MSC_SAFETY_STOCKS

Line 2025: FROM msc_safety_stocks

2021: l_date date;
2022: begin
2023: SELECT TRUNC(nvl(max(period_start_date),sysdate))
2024: into l_date
2025: FROM msc_safety_stocks
2026: WHERE period_start_date <= TRUNC(SYSDATE)
2027: AND inventory_item_id = p_item_id
2028: AND sr_instance_id = p_instance_id
2029: AND organization_id = p_org_id