DBA Data[Home] [Help]

APPS.MSC_AATP_PVT dependencies on MSC_SUPPLIER_CAPACITIES

Line 9018: msc_supplier_capacities s

9014: s.sr_instance_id,
9015: S.ORGANIZATION_ID,
9016: S.capacity
9017: FROM msc_calendar_dates c,
9018: msc_supplier_capacities s
9019: --WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
9020: WHERE s.inventory_item_id = l_inv_item_id
9021: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
9022: AND s.plan_id = p_sup_atp_info_rec.plan_id

Line 9178: msc_supplier_capacities s

9174: s.sr_instance_id,
9175: S.ORGANIZATION_ID,
9176: S.capacity
9177: FROM msc_calendar_dates c,
9178: msc_supplier_capacities s
9179: WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
9180: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
9181: AND s.plan_id = p_sup_atp_info_rec.plan_id
9182: AND s.organization_id = p_sup_atp_info_rec.organization_id

Line 9418: msc_supplier_capacities s

9414: s.organization_id,
9415: c.seq_num
9416:
9417: FROM msc_calendar_dates c,
9418: msc_supplier_capacities s
9419: --WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
9420: WHERE s.inventory_item_id = l_inv_item_id
9421: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
9422: AND s.plan_id = p_sup_atp_info_rec.plan_id

Line 9702: msc_supplier_capacities s

9698: s.sr_instance_id,
9699: s.organization_id,
9700: c.seq_num
9701: FROM msc_calendar_dates c,
9702: msc_supplier_capacities s
9703: WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
9704: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
9705: AND s.plan_id = p_sup_atp_info_rec.plan_id
9706: AND s.organization_id = p_sup_atp_info_rec.organization_id