APPS.WIP_WIPREVAL_XMLP_PKG dependencies on WIP_ENTITIES

Line 301: FROM WIP_ENTITIES WE

297:
298: IF FROM_ASSEMBLY IS NULL THEN
299: SELECT NVL(MIN(WE.WIP_ENTITY_NAME),'X')
300: INTO FROM_ASSEMBLY
301: FROM WIP_ENTITIES WE
302: WHERE WE.ORGANIZATION_ID = ORG_ID
303: AND WE.ENTITY_TYPE = 2;
304: END IF;
305:

Line 309: FROM WIP_ENTITIES WE

305:
306: IF TO_ASSEMBLY IS NULL THEN
307: SELECT NVL(MAX(WE.WIP_ENTITY_NAME),'X')
308: INTO TO_ASSEMBLY
309: FROM WIP_ENTITIES WE
310: WHERE WE.ORGANIZATION_ID = ORG_ID
311: AND WE.ENTITY_TYPE = 2;
312: END IF;
313:

Line 402: wip_entities we,

398: to_date('||''''|| C_TO_PERIOD_END_DATE || ''''||','||''''||'YYYY/MM/DD HH24:MI:SS'||''')
399: from
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

Line 537: wip_entities we

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 =
540: decode(sign(trunc(wrs.last_unit_start_date) -
541: to_date('||''''|| C_TO_PERIOD_END_DATE || ''''||','||''''||'YYYY/MM/DD HH24:MI:SS'||''')),

Line 707: wip_entities we

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) -
711: to_date('||''''|| C_TO_PERIOD_END_DATE || ''''||','||''''||'YYYY/MM/DD HH24:MI:SS'||''')),

Line 822: wip_entities we

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) -
826: to_date('||''''|| C_TO_PERIOD_END_DATE || ''''||','||''''||'YYYY/MM/DD HH24:MI:SS'||''')),

Line 937: wip_entities we

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) -
941: to_date('||''''|| C_TO_PERIOD_END_DATE || ''''||','||''''||'YYYY/MM/DD HH24:MI:SS'||''')),