APPS.WIP_WIPREVAL_XMLP_PKG dependencies on WIP_REPETITIVE_ITEMS

Line 317: FROM WIP_REPETITIVE_ITEMS WRI

313:
314: IF FROM_CLASS IS NULL THEN
315: SELECT NVL(MIN(WRI.CLASS_CODE),'X')
316: INTO FROM_CLASS
317: FROM WIP_REPETITIVE_ITEMS WRI
318: WHERE WRI.ORGANIZATION_ID = ORG_ID;
319: END IF;
320:
321: IF TO_CLASS IS NULL THEN

Line 324: FROM WIP_REPETITIVE_ITEMS WRI

320:
321: IF TO_CLASS IS NULL THEN
322: SELECT NVL(MAX(WRI.CLASS_CODE),'X')
323: INTO TO_CLASS
324: FROM WIP_REPETITIVE_ITEMS WRI
325: WHERE WRI.ORGANIZATION_ID = ORG_ID;
326: END IF;
327:
328: IF FROM_LINE IS NULL THEN

Line 404: wip_repetitive_items wri,

400: bom_calendar_dates bcd1,
401: bom_calendar_dates bcd2,
402: wip_entities we,
403: wip_lines wl,
404: wip_repetitive_items wri,
405: wip_repetitive_schedules wrs
406: where
407: bcd1.calendar_date =
408: decode(sign(trunc(wrs.last_unit_start_date) -

Line 535: wip_repetitive_items wri,

531: mtl_material_txn_allocations mmta2,
532: bom_calendar_dates bcd1,
533: bom_calendar_dates bcd2,
534: wip_lines wl,
535: wip_repetitive_items wri,
536: wip_repetitive_schedules wrs,
537: wip_entities we
538: where
539: bcd1.calendar_date =

Line 706: wip_repetitive_items wri,

702: bom_calendar_dates bcd1,
703: bom_calendar_dates bcd2,
704: wip_lines wl,
705: wip_repetitive_schedules wrs,
706: wip_repetitive_items wri,
707: wip_entities we
708: where
709: bcd1.calendar_date =
710: decode(sign(trunc(wrs.last_unit_start_date) -

Line 821: wip_repetitive_items wri,

817: bom_calendar_dates bcd1,
818: bom_calendar_dates bcd2,
819: wip_lines wl,
820: wip_repetitive_schedules wrs,
821: wip_repetitive_items wri,
822: wip_entities we
823: where
824: bcd1.calendar_date =
825: decode(sign(trunc(wrs.last_unit_start_date) -

Line 936: wip_repetitive_items wri,

932: bom_calendar_dates bcd1,
933: bom_calendar_dates bcd2,
934: wip_lines wl,
935: wip_repetitive_schedules wrs,
936: wip_repetitive_items wri,
937: wip_entities we
938: where
939: bcd1.calendar_date =
940: decode(sign(trunc(wrs.last_unit_start_date) -