eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on STANDARD

Line 1059: WIP_CONSTANTS.NONSTANDARD = (select wdj.job_type

1055: and ( (wjsi.load_type = WIP_CONSTANTS.CREATE_NS_JOB and
1056: wjsi.firm_planned_flag = WIP_CONSTANTS.YES)
1057: or (wjsi.firm_planned_flag = WIP_CONSTANTS.YES and
1058: wjsi.load_type = WIP_CONSTANTS.RESCHED_JOB and
1059: WIP_CONSTANTS.NONSTANDARD = (select wdj.job_type
1060: from wip_discrete_jobs wdj
1061: where wdj.wip_entity_id = wjsi.wip_entity_id
1062: and wdj.organization_id = wjsi.organization_id))
1063: or (wjsi.firm_planned_flag not in (WIP_CONSTANTS.YES, WIP_CONSTANTS.NO)))

Line 1380: and WIP_CONSTANTS.NONSTANDARD <> (select wdj.job_type

1376: wip_constants.resched_job)
1377: or (wjsi.load_type = wip_constants.create_ns_job and
1378: wjsi.routing_reference_id is not null) )
1379: and wjsi.routing_reference_segments is not null
1380: and WIP_CONSTANTS.NONSTANDARD <> (select wdj.job_type
1381: from wip_discrete_jobs wdj
1382: where wdj.wip_entity_id = wjsi.wip_entity_id
1383: and wdj.organization_id = wjsi.organization_id)
1384: returning wjsi.interface_id bulk collect into l_interfaceTbl;

Line 1402: and WIP_CONSTANTS.NONSTANDARD <> (select wdj.job_type

1398: and wjsi.load_type in (wip_constants.create_job,
1399: wip_constants.create_sched,
1400: wip_constants.resched_job)
1401: and wjsi.routing_reference_id is not null
1402: and WIP_CONSTANTS.NONSTANDARD <> (select wdj.job_type
1403: from wip_discrete_jobs wdj
1404: where wdj.wip_entity_id = wjsi.wip_entity_id
1405: and wdj.organization_id = wjsi.organization_id)
1406: returning wjsi.interface_id bulk collect into l_interfaceTbl;

Line 1424: and WIP_CONSTANTS.NONSTANDARD = (select wdj.job_type

1420: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
1421: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1422: and (wjsi.load_type = WIP_CONSTANTS.CREATE_NS_JOB
1423: OR (wjsi.load_type = WIP_CONSTANTS.RESCHED_JOB
1424: and WIP_CONSTANTS.NONSTANDARD = (select wdj.job_type
1425: from wip_discrete_jobs wdj
1426: where wdj.wip_entity_id = wjsi.wip_entity_id
1427: and wdj.organization_id = wjsi.organization_id)))
1428: and wjsi.routing_reference_segments is not null

Line 1458: WIP_CONSTANTS.NONSTANDARD = (select wdj.job_type

1454: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
1455: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1456: and (wjsi.load_type = WIP_CONSTANTS.CREATE_NS_JOB
1457: OR (wjsi.load_type = WIP_CONSTANTS.RESCHED_JOB and
1458: WIP_CONSTANTS.NONSTANDARD = (select wdj.job_type
1459: from wip_discrete_jobs wdj
1460: where wdj.wip_entity_id = wjsi.wip_entity_id
1461: and wdj.organization_id = wjsi.organization_id)))
1462: --and wjsi.routing_reference_segments is not null

Line 1475: WIP_CONSTANTS.NONSTANDARD = (select wdj.job_type

1471: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
1472: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1473: and (wjsi.load_type = WIP_CONSTANTS.CREATE_NS_JOB
1474: OR (wjsi.load_type = WIP_CONSTANTS.RESCHED_JOB and
1475: WIP_CONSTANTS.NONSTANDARD = (select wdj.job_type
1476: from wip_discrete_jobs wdj
1477: where wdj.wip_entity_id = wjsi.wip_entity_id
1478: and wdj.organization_id = wjsi.organization_id)))
1479: and wjsi.routing_reference_id is not null

Line 1500: WIP_CONSTANTS.NONSTANDARD = (select wdj.job_type

1496: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
1497: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1498: and (wjsi.load_type = WIP_CONSTANTS.CREATE_NS_JOB
1499: OR (wjsi.load_type = WIP_CONSTANTS.RESCHED_JOB and
1500: WIP_CONSTANTS.NONSTANDARD = (select wdj.job_type
1501: from wip_discrete_jobs wdj
1502: where wdj.wip_entity_id = wjsi.wip_entity_id
1503: and wdj.organization_id = wjsi.organization_id)))
1504: and wjsi.routing_reference_id is not null

Line 1721: and WIP_CONSTANTS.NONSTANDARD <> (select wdj.job_type

1717: wip_constants.resched_job)
1718: or (wjsi.load_type = wip_constants.create_ns_job and
1719: wjsi.bom_reference_id is not null) )
1720: and wjsi.bom_reference_segments is not null
1721: and WIP_CONSTANTS.NONSTANDARD <> (select wdj.job_type
1722: from wip_discrete_jobs wdj
1723: where wdj.wip_entity_id = wjsi.wip_entity_id
1724: and wdj.organization_id = wjsi.organization_id)
1725: returning wjsi.interface_id bulk collect into l_interfaceTbl;

Line 1743: and WIP_CONSTANTS.NONSTANDARD <> (select wdj.job_type

1739: and wjsi.load_type in (wip_constants.create_job,
1740: wip_constants.create_sched,
1741: wip_constants.resched_job)
1742: and wjsi.bom_reference_id is not null
1743: and WIP_CONSTANTS.NONSTANDARD <> (select wdj.job_type
1744: from wip_discrete_jobs wdj
1745: where wdj.wip_entity_id = wjsi.wip_entity_id
1746: and wdj.organization_id = wjsi.organization_id)
1747: returning wjsi.interface_id bulk collect into l_interfaceTbl;

Line 1766: WIP_CONSTANTS.NONSTANDARD = (select wdj.job_type

1762: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
1763: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1764: and (wjsi.load_type = WIP_CONSTANTS.CREATE_NS_JOB
1765: OR (wjsi.load_type = WIP_CONSTANTS.RESCHED_JOB and
1766: WIP_CONSTANTS.NONSTANDARD = (select wdj.job_type
1767: from wip_discrete_jobs wdj
1768: where wdj.wip_entity_id = wjsi.wip_entity_id
1769: and wdj.organization_id = wjsi.organization_id)))
1770: and wjsi.bom_reference_segments is not null

Line 1800: WIP_CONSTANTS.NONSTANDARD = (select wdj.job_type

1796: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
1797: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1798: and (wjsi.load_type = WIP_CONSTANTS.CREATE_NS_JOB
1799: OR (wjsi.load_type = WIP_CONSTANTS.RESCHED_JOB and
1800: WIP_CONSTANTS.NONSTANDARD = (select wdj.job_type
1801: from wip_discrete_jobs wdj
1802: where wdj.wip_entity_id = wjsi.wip_entity_id
1803: and wdj.organization_id = wjsi.organization_id)))
1804: --and wjsi.bom_reference_segments is not null

Line 1817: WIP_CONSTANTS.NONSTANDARD = (select wdj.job_type

1813: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
1814: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1815: and (wjsi.load_type = WIP_CONSTANTS.CREATE_NS_JOB
1816: OR (wjsi.load_type = WIP_CONSTANTS.RESCHED_JOB and
1817: WIP_CONSTANTS.NONSTANDARD = (select wdj.job_type
1818: from wip_discrete_jobs wdj
1819: where wdj.wip_entity_id = wjsi.wip_entity_id
1820: and wdj.organization_id = wjsi.organization_id)))
1821: and wjsi.bom_reference_id is not null

Line 1842: WIP_CONSTANTS.NONSTANDARD = (select wdj.job_type

1838: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
1839: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1840: and (wjsi.load_type = WIP_CONSTANTS.CREATE_NS_JOB
1841: OR (wjsi.load_type = WIP_CONSTANTS.RESCHED_JOB and
1842: WIP_CONSTANTS.NONSTANDARD = (select wdj.job_type
1843: from wip_discrete_jobs wdj
1844: where wdj.wip_entity_id = wjsi.wip_entity_id
1845: and wdj.organization_id = wjsi.organization_id)))
1846: and wjsi.bom_reference_id is not null

Line 2157: wip_constants.standard = (select wdj.job_type

2153: or (wjsi.load_type = wip_constants.create_job and
2154: wjsi.start_quantity = 0)
2155: or (wjsi.load_type = wip_constants.resched_job and
2156: wjsi.start_quantity = 0 and
2157: wip_constants.standard = (select wdj.job_type
2158: from wip_discrete_jobs wdj
2159: where wdj.organization_id = wjsi.organization_id
2160: and wdj.wip_entity_id = wjsi.wip_entity_id)))
2161: returning wjsi.interface_id bulk collect into l_interfaceTbl;

Line 2262: wip_constants.nonstandard = (select wdj.job_type

2258: and ( wjsi.net_quantity not between 0 and wjsi.start_quantity
2259: or ( wjsi.net_quantity <> 0
2260: and ((wjsi.load_type = wip_constants.create_ns_job and wjsi.primary_item_id is null) or
2261: (wjsi.load_type = wip_constants.resched_job and
2262: wip_constants.nonstandard = (select wdj.job_type
2263: from wip_discrete_jobs wdj
2264: where wdj.organization_id = wjsi.organization_id
2265: and wdj.wip_entity_id = wjsi.wip_entity_id) and
2266: (select wdj.primary_item_id

Line 2824: and wdj.wip_entity_id = wjsi.wip_entity_id) = wip_constants.nonstandard and

2820: (wjsi.load_type = wip_constants.resched_job and
2821: (select wdj.job_type
2822: from wip_discrete_jobs wdj
2823: where wdj.organization_id = wjsi.organization_id
2824: and wdj.wip_entity_id = wjsi.wip_entity_id) = wip_constants.nonstandard and
2825: (select wdj.routing_reference_id
2826: from wip_discrete_jobs wdj
2827: where wdj.organization_id = wjsi.organization_id
2828: and wdj.wip_entity_id = wjsi.wip_entity_id) is null)))

Line 2933: wip_constants.nonstandard = (select wdj.job_type

2929: wjsi.routing_reference_id is null and
2930: (wjsi.first_unit_start_date is null or wjsi.last_unit_completion_date is null))
2931: or (wjsi.load_type = wip_constants.resched_job and
2932: --when rescheduling a ns job and providing one date, it must have a routing
2933: wip_constants.nonstandard = (select wdj.job_type
2934: from wip_discrete_jobs wdj
2935: where wdj.organization_id = wjsi.organization_id
2936: and wdj.wip_entity_id = wjsi.wip_entity_id) and
2937: /* (select wdj.routing_reference_id

Line 3654: from wip_non_standard_classes_val_v

3650: elsif ( wjsi_row.load_type = wip_constants.create_ns_job ) then
3651: select 1 into l_dummy
3652: from dual
3653: where exists(select 1
3654: from wip_non_standard_classes_val_v
3655: where class_code = wjsi_row.class_code
3656: and organization_id = wjsi_row.organization_id);
3657: end if;
3658: exception