APPS.EDW_ITEMS_M_SIZE dependencies on EDW_LOCAL_INSTANCE

Line 93: edw_local_instance inst

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
97: and mtp.master_organization_id=mtm.organization_id

Line 120: edw_local_instance inst

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
124: and mtr.organization_id = mp.organization_id

Line 151: edw_local_instance inst

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
155: p_from_date and p_to_date;

Line 213: edw_local_instance inst

209: 47
210: From
211: mtl_categories_kfv cat,
212: po_lines_all l,
213: edw_local_instance inst
214: WHERE cat.category_id = l.category_id
215: and l.item_id is null
216: and l.last_update_date between
217: p_from_date and p_to_date

Line 247: From edw_local_instance inst,

243: avg(nvl(vsize(NULL), 0)) +
244: avg(nvl(vsize(NULL), 0)) +
245: avg(nvl(vsize(NULL), 0)) +
246: 17
247: From edw_local_instance inst,
248: mtl_categories_kfv cat,
249: po_lines_all l
250: WHERE cat.category_id = l.category_id
251: and l.item_id is null

Line 316: edw_local_instance inst

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
320: and mic.inventory_item_id = mti.product_family_item_id

Line 347: edw_local_instance inst

343: 11
344: from
345: mtl_categories_kfv mtc,
346: mtl_category_sets mts,
347: edw_local_instance inst
348: WHERE mtc.structure_id = mts.structure_id
349: and mts.control_level = 1
350: and mtc.last_update_date between
351: p_from_date and p_to_date;

Line 372: edw_local_instance inst

368: avg(nvl(vsize(NULL), 0)) +
369: 11
370: from mtl_categories_kfv mtc,
371: mtl_category_sets mts,
372: edw_local_instance inst
373: WHERE mtc.structure_id = mts.structure_id
374: and mtc.last_update_date between
375: p_from_date and p_to_date;
376:

Line 402: edw_local_instance inst

398: 15
399: FROM
400: mtl_categories_kfv cats,
401: mtl_category_sets sets,
402: edw_local_instance inst
403: WHERE
404: cats.structure_id = sets.structure_id
405: and sets.category_set_name = 'Product Family'
406: and cats.last_update_date between

Line 434: EDW_LOCAL_INSTANCE INST

430: 16
431: FROM
432: AS_INTEREST_CODES_V CD ,
433: AS_INTEREST_TYPES_V INTYP ,
434: EDW_LOCAL_INSTANCE INST
435: WHERE
436: CD.INTEREST_TYPE_ID = INTYP.INTEREST_TYPE_ID
437: AND CD.PARENT_INTEREST_CODE_ID IS NULL
438: AND INTYP.EXPECTED_PURCHASE_FLAG = 'Y'

Line 470: EDW_LOCAL_INSTANCE INST

466: FROM
467: AS_INTEREST_CODES_V SCD ,
468: AS_INTEREST_CODES_V PCD ,
469: AS_INTEREST_TYPES_V INTYP ,
470: EDW_LOCAL_INSTANCE INST
471: WHERE
472: SCD.PARENT_INTEREST_CODE_ID = PCD.INTEREST_CODE_ID
473: AND PCD.PARENT_INTEREST_CODE_ID IS NULL
474: AND SCD.INTEREST_TYPE_ID = PCD.INTEREST_TYPE_ID

Line 507: EDW_LOCAL_INSTANCE INST

503: avg(nvl(vsize(TO_DATE(NULL)), 0)) +
504: 16
505: FROM
506: AS_INTEREST_TYPES_V INTYP ,
507: EDW_LOCAL_INSTANCE INST
508: WHERE
509: INTYP.EXPECTED_PURCHASE_FLAG = 'Y'
510: and intyp.last_update_date between
511: p_from_date and p_to_date;