DBA Data[Home] [Help]

APPS.MSC_ATP_FUNC dependencies on MSC_LOCATION_ASSOCIATIONS

Line 232: -- Location ID from msc_location_associations

228:
229: ELSIF ((p_customer_id IS NOT NULL) AND
230: (p_customer_site_id IS NOT NULL)) THEN
231: -- krajan:
232: -- Location ID from msc_location_associations
233: SELECT loc.location_id
234: INTO l_location_id
235: FROM msc_tp_site_id_lid tpsid,
236: msc_location_associations loc

Line 236: msc_location_associations loc

232: -- Location ID from msc_location_associations
233: SELECT loc.location_id
234: INTO l_location_id
235: FROM msc_tp_site_id_lid tpsid,
236: msc_location_associations loc
237: -- Modified for Sony Bug 2793404
238: -- Remove customer_id filter and corresponding join to msc_tp_id Bug 2816887
239: WHERE tpsid.sr_tp_site_id = p_customer_site_id
240: AND tpsid.sr_instance_id = p_instance_id

Line 254: FROM msc_location_associations l

250:
251: -- cchen: 1124206
252: SELECT l.location_id
253: INTO l_location_id
254: FROM msc_location_associations l
255: WHERE l.sr_instance_id = p_instance_id
256: AND l.partner_id = p_supplier_id
257: AND l.partner_site_id = p_supplier_site_id;
258: