DBA Data[Home] [Help]

APPS.MSC_AATP_PVT dependencies on MSC_SUPPLIER_CAPACITIES

Line 8787: msc_supplier_capacities s

8783: s.sr_instance_id,
8784: S.ORGANIZATION_ID,
8785: S.capacity
8786: FROM msc_calendar_dates c,
8787: msc_supplier_capacities s
8788: --WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
8789: WHERE s.inventory_item_id = l_inv_item_id
8790: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
8791: AND s.plan_id = p_sup_atp_info_rec.plan_id

Line 8947: msc_supplier_capacities s

8943: s.sr_instance_id,
8944: S.ORGANIZATION_ID,
8945: S.capacity
8946: FROM msc_calendar_dates c,
8947: msc_supplier_capacities s
8948: WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
8949: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
8950: AND s.plan_id = p_sup_atp_info_rec.plan_id
8951: AND s.organization_id = p_sup_atp_info_rec.organization_id

Line 9187: msc_supplier_capacities s

9183: s.organization_id,
9184: c.seq_num
9185:
9186: FROM msc_calendar_dates c,
9187: msc_supplier_capacities s
9188: --WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
9189: WHERE s.inventory_item_id = l_inv_item_id
9190: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
9191: AND s.plan_id = p_sup_atp_info_rec.plan_id

Line 9471: msc_supplier_capacities s

9467: s.sr_instance_id,
9468: s.organization_id,
9469: c.seq_num
9470: FROM msc_calendar_dates c,
9471: msc_supplier_capacities s
9472: WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
9473: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
9474: AND s.plan_id = p_sup_atp_info_rec.plan_id
9475: AND s.organization_id = p_sup_atp_info_rec.organization_id