DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MSC_SUPPLIER_CAPACITIES

Line 11106: FROM msc_supplier_capacities s

11102: is sufficient to know whether capacity is defined or not. However since this table
11103: is being queried, we are getting last cap date as well.*/
11104: SELECT max(trunc(NVL(to_date,G_PLAN_INFO_REC.plan_cutoff_date))) --4055719
11105: INTO l_atp_rec.last_cap_date
11106: FROM msc_supplier_capacities s
11107: WHERE s.inventory_item_id = NVL(C_ITEM_INFO_REC.base_item_id,
11108: C_ITEM_INFO_REC.dest_inv_item_id)
11109: AND s.sr_instance_id = l_sources.instance_id(j)
11110: AND s.plan_id = p_plan_id