DBA Data[Home] [Help]

APPS.MSC_SNAPSHOT_PK dependencies on MSC_SAFETY_STOCKS

Line 2341: FROM msc_safety_stocks

2337: l_date date;
2338: begin
2339: SELECT TRUNC(nvl(max(period_start_date),sysdate))
2340: into l_date
2341: FROM msc_safety_stocks
2342: WHERE period_start_date <= TRUNC(SYSDATE)
2343: AND inventory_item_id = p_item_id
2344: AND sr_instance_id = p_instance_id
2345: AND organization_id = p_org_id

Line 2361: FROM msc_safety_stocks

2357: l_date date;
2358: begin
2359: SELECT TRUNC(nvl(max(period_start_date),sysdate))
2360: into l_date
2361: FROM msc_safety_stocks
2362: WHERE period_start_date <= TRUNC(SYSDATE)
2363: AND inventory_item_id = p_item_id
2364: AND sr_instance_id = p_instance_id
2365: AND organization_id = p_org_id