DBA Data[Home] [Help]

APPS.MSC_ATP_24X7 dependencies on MSC_TP_ID_LID

Line 757: from msc_tp_id_lid mtil

753: -- Inline view for Customers
754: ( select mtil.sr_instance_id sr_instance_id,
755: mtil.tp_id tp_id,
756: max(mtil.sr_tp_id) sr_tp_id
757: from msc_tp_id_lid mtil
758: where mtil.partner_type = 2
759: and mtil.sr_company_id = -1
760: group by mtil.sr_instance_id, mtil.tp_id
761: ) CUST_VIEW,

Line 1048: from msc_tp_id_lid mtil

1044: -- Inline view for Customers
1045: ( select mtil.sr_instance_id sr_instance_id,
1046: mtil.tp_id tp_id,
1047: max(mtil.sr_tp_id) sr_tp_id
1048: from msc_tp_id_lid mtil
1049: where mtil.partner_type = 2
1050: and mtil.sr_company_id = -1
1051: group by mtil.sr_instance_id, mtil.tp_id
1052: ) CUST_VIEW,