DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MSC_SUPPLIER_CAPACITIES

Line 11861: FROM msc_supplier_capacities s

11857: is sufficient to know whether capacity is defined or not. However since this table
11858: is being queried, we are getting last cap date as well.*/
11859: SELECT max(trunc(NVL(to_date,G_PLAN_INFO_REC.plan_cutoff_date))) --4055719
11860: INTO l_atp_rec.last_cap_date
11861: FROM msc_supplier_capacities s
11862: WHERE s.inventory_item_id = NVL(C_ITEM_INFO_REC.base_item_id,
11863: C_ITEM_INFO_REC.dest_inv_item_id)
11864: AND s.sr_instance_id = l_sources.instance_id(j)
11865: AND s.plan_id = p_plan_id