APPS.OPI_DBI_PTP_BASELINE_PKG dependencies on MTL_PARAMETERS

Line 170: mtl_parameters mp,

166: :g_sysdate,
167: :g_last_updated_by,
168: :g_last_update_login
169: from
170: mtl_parameters mp,
171: mtl_system_Items_b msi,
172: (select /*+ no_merge use_hash(sched,setup,plan,orgs) */
173: orgs.organization_id,
174: sched.from_date

Line 212: mtl_parameters mp

208: msi.inventory_item_id,
209: decode (mp.primary_cost_method, 1, 1, 2) cost_type_id
210: from
211: mtl_system_items_b msi,
212: mtl_parameters mp
213: where mp.organization_id in ' || l_new_orgs || '
214: AND mp.process_enabled_flag <> ''Y''
215: AND mp.organization_id = msi.organization_id
216: ) io,

Line 425: mtl_parameters mp

421: msi.inventory_item_id,
422: decode (mp.primary_cost_method, 1, 1, 2) cost_type_id
423: from
424: mtl_system_items_b msi,
425: mtl_parameters mp
426: where mp.organization_id in ' || l_existing_orgs || '
427: AND mp.process_enabled_flag <> ''Y''
428: AND mp.organization_id = msi.organization_id
429: ) io

Line 714: mtl_parameters mp

710: (select distinct organization_id,
711: 1 existing_flag
712: from opi_dbi_ptp_conv
713: ) org2,
714: mtl_parameters mp
715: where org1.organization_id = org2.organization_id (+)
716: and org1.organization_id = mp.organization_id
717: and mp.process_enabled_flag = 'Y';
718:

Line 831: mtl_parameters mp,

827: :g_sysdate,
828: :g_last_updated_by,
829: :g_last_update_login
830: from
831: mtl_parameters mp,
832: mtl_system_Items_b msi,
833: (select orgs.organization_id,
834: sched.from_date
835: from opi_dbi_baseline_schedules sched,