APPS.EDW_ITEMS_M_SIZE dependencies on MTL_PARAMETERS

Line 91: mtl_parameters mtp,

87: avg(nvl(vsize(NULL), 0)) +
88: avg(nvl(vsize(mti.segment1), 0)) +
89: 45
90: from mtl_system_items_b_kfv mti,
91: mtl_parameters mtp,
92: mtl_parameters mtm,
93: edw_local_instance inst
94: WHERE
95: mti.product_family_item_id is NULL

Line 92: mtl_parameters mtm,

88: avg(nvl(vsize(mti.segment1), 0)) +
89: 45
90: from mtl_system_items_b_kfv mti,
91: mtl_parameters mtp,
92: mtl_parameters mtm,
93: edw_local_instance inst
94: WHERE
95: mti.product_family_item_id is NULL
96: and mti.organization_id=mtp.organization_id

Line 119: mtl_parameters mp,

115: 10
116: FROM
117: mtl_system_items_kfv mti,
118: mtl_item_revisions mtr,
119: mtl_parameters mp,
120: edw_local_instance inst
121: WHERE
122: mti.inventory_item_id = mtr.inventory_item_id
123: and mti.organization_id = mtr.organization_id

Line 150: mtl_parameters mtp,

146: avg(nvl(vsize(mti.creation_date), 0)) +
147: avg(nvl(vsize(NULL), 0)) +
148: 15
149: from mtl_system_items_kfv mti,
150: mtl_parameters mtp,
151: edw_local_instance inst
152: WHERE mtp.organization_id = mtp.master_organization_id
153: and mti.organization_id = mtp.organization_id
154: and mti.last_update_date between

Line 314: mtl_parameters mtp,

310: FROM
311: mtl_system_items_kfv mti,
312: mtl_item_categories mic,
313: mtl_category_sets sets,
314: mtl_parameters mtp,
315: mtl_parameters mtm,
316: edw_local_instance inst
317: WHERE
318: mti.product_family_item_id is not null

Line 315: mtl_parameters mtm,

311: mtl_system_items_kfv mti,
312: mtl_item_categories mic,
313: mtl_category_sets sets,
314: mtl_parameters mtp,
315: mtl_parameters mtm,
316: edw_local_instance inst
317: WHERE
318: mti.product_family_item_id is not null
319: and mti.organization_id = mtp.organization_id