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 1045: from msc_tp_id_lid mtil

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