APPS.EDW_MTL_INVENTORY_LOC_M_SZ dependencies on MTL_PARAMETERS

Line 14: mtl_parameters mp,

10: (
11: -- Locator Level
12: select count(*) cnt
13: FROM mtl_item_locations_kfv locf,
14: mtl_parameters mp,
15: hr_organization_units hou
16: where
17: locf.last_update_date between p_from_date and p_to_date AND
18: locf.organization_id = mp.organization_id AND

Line 28: mtl_parameters mp

24: select count(*) cnt
25: FROM mtl_secondary_inventories msi,
26: hr_all_organization_units bg,
27: hr_all_organization_units org,
28: mtl_parameters mp
29: WHERE msi.organization_id = mp.organization_id + 0
30: AND bg.organization_id = org.business_group_id
31: AND org.organization_id = mp.organization_id
32: and msi.last_update_date between p_from_date and p_to_date

Line 40: mtl_parameters mp

36: FROM
37: hr_all_organization_units bg,
38: hr_all_organization_units org,
39: HR_ORGANIZATION_INFORMATION HOI,
40: mtl_parameters mp
41: WHERE bg.organization_id = org.business_group_id
42: AND org.organization_id = mp.organization_id
43: and org.ORGANIZATION_ID = HOI.ORGANIZATION_ID
44: AND ( HOI.ORG_INFORMATION_CONTEXT || '') ='Accounting Information'

Line 66: MTL_PARAMETERS MP

62: SELECT COUNT(*) cnt
63: FROM IC_LOCT_INV ILI,
64: IC_ITEM_MST IIM,
65: IC_WHSE_MST IWM,
66: MTL_PARAMETERS MP
67: WHERE
68: ILI.ITEM_ID = IIM.ITEM_ID
69: AND ILI.WHSE_CODE = IWM.WHSE_CODE
70: AND MP.ORGANIZATION_ID = IWM.MTL_ORGANIZATION_ID

Line 78: MTL_PARAMETERS MP

74: SELECT COUNT(*) cnt
75: FROM IC_LOCT_INV ILI,
76: IC_ITEM_MST IIM,
77: IC_WHSE_MST IWM,
78: MTL_PARAMETERS MP
79: WHERE
80: ILI.ITEM_ID = IIM.ITEM_ID
81: AND ILI.WHSE_CODE = IWM.WHSE_CODE
82: AND MP.ORGANIZATION_ID = IWM.MTL_ORGANIZATION_ID

Line 165: mtl_parameters mp;

161: avg(nvl(vsize(mp.last_update_date), 0)),
162: -- Plant_Creation_date
163: avg(nvl(vsize(mp.creation_date), 0))
164: From
165: mtl_parameters mp;
166:
167:
168: CURSOR c_3 IS -- Part of Locator Name
169: Select