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.ENGPKIMP dependencies on WIP_ENTITIES

Line 1518: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,

1514: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
1515: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
1516: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1517: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1518: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
1519: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
1520: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,
1521: message_names OUT NOCOPY NameArray,
1522: token1 OUT NOCOPY NameArray,

Line 1519: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,

1515: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
1516: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1517: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1518: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
1519: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
1520: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,
1521: message_names OUT NOCOPY NameArray,
1522: token1 OUT NOCOPY NameArray,
1523: value1 OUT NOCOPY StringArray,

Line 1520: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,

1516: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1517: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1518: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
1519: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
1520: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,
1521: message_names OUT NOCOPY NameArray,
1522: token1 OUT NOCOPY NameArray,
1523: value1 OUT NOCOPY StringArray,
1524: translate1 OUT NOCOPY BooleanArray,

Line 1946: FROM wip_discrete_jobs wdj, wip_entities we

1942: wdj.bom_revision,
1943: wdj.routing_revision,
1944: wdj.bom_revision_date,
1945: wdj.routing_revision_date
1946: FROM wip_discrete_jobs wdj, wip_entities we
1947: WHERE wdj.wip_entity_id = p_from_wip_entity_id
1948: AND we.wip_entity_id = wdj.wip_entity_id
1949: AND wdj.status_type = 1;
1950:

Line 1964: wip_entities we,

1960: FROM DUAL
1961: WHERE EXISTS (
1962: SELECT 1
1963: FROM wip_discrete_jobs wdj,
1964: wip_entities we,
1965: wip_entities we1,
1966: wip_entities we2
1967: WHERE we1.wip_entity_id = p_from_wip_entity_id
1968: AND we2.wip_entity_id = p_to_wip_entity_id

Line 1965: wip_entities we1,

1961: WHERE EXISTS (
1962: SELECT 1
1963: FROM wip_discrete_jobs wdj,
1964: wip_entities we,
1965: wip_entities we1,
1966: wip_entities we2
1967: WHERE we1.wip_entity_id = p_from_wip_entity_id
1968: AND we2.wip_entity_id = p_to_wip_entity_id
1969: AND we.wip_entity_name >= we1.wip_entity_name

Line 1966: wip_entities we2

1962: SELECT 1
1963: FROM wip_discrete_jobs wdj,
1964: wip_entities we,
1965: wip_entities we1,
1966: wip_entities we2
1967: WHERE we1.wip_entity_id = p_from_wip_entity_id
1968: AND we2.wip_entity_id = p_to_wip_entity_id
1969: AND we.wip_entity_name >= we1.wip_entity_name
1970: AND we.wip_entity_name <= we2.wip_entity_name

Line 1990: FROM wip_discrete_jobs wdj, wip_entities we

1986: SELECT 'X'
1987: FROM DUAL
1988: WHERE EXISTS (
1989: SELECT 1
1990: FROM wip_discrete_jobs wdj, wip_entities we
1991: WHERE wdj.lot_number = p_wip_lot_number
1992: AND wdj.wip_entity_id = we.wip_entity_id
1993: AND wdj.primary_item_id = item.revised_item_id
1994: AND wdj.organization_Id = item.organization_id

Line 2151: wip_entities we,

2147: FROM DUAL
2148: WHERE EXISTS (
2149: SELECT 1
2150: FROM wip_discrete_jobs wdj,
2151: wip_entities we,
2152: wip_entities we1,
2153: wip_entities we2
2154: WHERE we1.wip_entity_id = p_from_wip_entity_id
2155: AND we2.wip_entity_id = p_to_wip_entity_id

Line 2152: wip_entities we1,

2148: WHERE EXISTS (
2149: SELECT 1
2150: FROM wip_discrete_jobs wdj,
2151: wip_entities we,
2152: wip_entities we1,
2153: wip_entities we2
2154: WHERE we1.wip_entity_id = p_from_wip_entity_id
2155: AND we2.wip_entity_id = p_to_wip_entity_id
2156: AND we.wip_entity_name >= we1.wip_entity_name

Line 2153: wip_entities we2

2149: SELECT 1
2150: FROM wip_discrete_jobs wdj,
2151: wip_entities we,
2152: wip_entities we1,
2153: wip_entities we2
2154: WHERE we1.wip_entity_id = p_from_wip_entity_id
2155: AND we2.wip_entity_id = p_to_wip_entity_id
2156: AND we.wip_entity_name >= we1.wip_entity_name
2157: AND we.wip_entity_name <= we2.wip_entity_name

Line 2270: wip_entities we,

2266: FROM DUAL
2267: WHERE EXISTS (
2268: SELECT 1
2269: FROM wip_discrete_jobs wdj,
2270: wip_entities we,
2271: wip_entities we1,
2272: wip_entities we2
2273: WHERE we1.wip_entity_id = p_from_wip_entity_id
2274: AND we2.wip_entity_id = p_to_wip_entity_id

Line 2271: wip_entities we1,

2267: WHERE EXISTS (
2268: SELECT 1
2269: FROM wip_discrete_jobs wdj,
2270: wip_entities we,
2271: wip_entities we1,
2272: wip_entities we2
2273: WHERE we1.wip_entity_id = p_from_wip_entity_id
2274: AND we2.wip_entity_id = p_to_wip_entity_id
2275: AND we.wip_entity_name >= we1.wip_entity_name

Line 2272: wip_entities we2

2268: SELECT 1
2269: FROM wip_discrete_jobs wdj,
2270: wip_entities we,
2271: wip_entities we1,
2272: wip_entities we2
2273: WHERE we1.wip_entity_id = p_from_wip_entity_id
2274: AND we2.wip_entity_id = p_to_wip_entity_id
2275: AND we.wip_entity_name >= we1.wip_entity_name
2276: AND we.wip_entity_name <= we2.wip_entity_name

Line 2349: wip_entities we,

2345: FROM DUAL
2346: WHERE EXISTS (
2347: SELECT 1
2348: FROM wip_discrete_jobs wdj,
2349: wip_entities we,
2350: wip_entities we1,
2351: wip_entities we2
2352: WHERE we1.wip_entity_id = p_from_wip_entity_id
2353: AND we2.wip_entity_id = p_to_wip_entity_id

Line 2350: wip_entities we1,

2346: WHERE EXISTS (
2347: SELECT 1
2348: FROM wip_discrete_jobs wdj,
2349: wip_entities we,
2350: wip_entities we1,
2351: wip_entities we2
2352: WHERE we1.wip_entity_id = p_from_wip_entity_id
2353: AND we2.wip_entity_id = p_to_wip_entity_id
2354: AND we.wip_entity_name >= we1.wip_entity_name

Line 2351: wip_entities we2

2347: SELECT 1
2348: FROM wip_discrete_jobs wdj,
2349: wip_entities we,
2350: wip_entities we1,
2351: wip_entities we2
2352: WHERE we1.wip_entity_id = p_from_wip_entity_id
2353: AND we2.wip_entity_id = p_to_wip_entity_id
2354: AND we.wip_entity_name >= we1.wip_entity_name
2355: AND we.wip_entity_name <= we2.wip_entity_name

Line 2480: wip_entities we,

2476: wdj.routing_revision_date,
2477: null bom_revision, -- Bug 3381547
2478: null routing_revision -- Bug 3381547
2479: FROM wip_discrete_jobs wdj,
2480: wip_entities we,
2481: wip_entities we1,
2482: wip_entities we2
2483: WHERE we1.wip_entity_id = l_from_wip_entity_id
2484: AND we2.wip_entity_id = l_to_wip_entity_id

Line 2481: wip_entities we1,

2477: null bom_revision, -- Bug 3381547
2478: null routing_revision -- Bug 3381547
2479: FROM wip_discrete_jobs wdj,
2480: wip_entities we,
2481: wip_entities we1,
2482: wip_entities we2
2483: WHERE we1.wip_entity_id = l_from_wip_entity_id
2484: AND we2.wip_entity_id = l_to_wip_entity_id
2485: AND ( (we.wip_entity_name >= we1.wip_entity_name

Line 2482: wip_entities we2

2478: null routing_revision -- Bug 3381547
2479: FROM wip_discrete_jobs wdj,
2480: wip_entities we,
2481: wip_entities we1,
2482: wip_entities we2
2483: WHERE we1.wip_entity_id = l_from_wip_entity_id
2484: AND we2.wip_entity_id = l_to_wip_entity_id
2485: AND ( (we.wip_entity_name >= we1.wip_entity_name
2486: and we.wip_entity_name <= we2.wip_entity_name)

Line 2510: wip_entities we,

2506: wdj.routing_revision_date,
2507: wdj.bom_revision bom_revision, -- Bug 3381547
2508: wdj.routing_revision routing_revision -- Bug 3381547
2509: FROM wip_discrete_jobs wdj,
2510: wip_entities we,
2511: wip_requirement_operations o,
2512: wip_entities we1,
2513: wip_entities we2
2514: WHERE wdj.wip_entity_id = we.wip_entity_id

Line 2512: wip_entities we1,

2508: wdj.routing_revision routing_revision -- Bug 3381547
2509: FROM wip_discrete_jobs wdj,
2510: wip_entities we,
2511: wip_requirement_operations o,
2512: wip_entities we1,
2513: wip_entities we2
2514: WHERE wdj.wip_entity_id = we.wip_entity_id
2515: AND we1.wip_entity_id = l_from_wip_entity_id
2516: AND we2.wip_entity_id = l_to_wip_entity_id

Line 2513: wip_entities we2

2509: FROM wip_discrete_jobs wdj,
2510: wip_entities we,
2511: wip_requirement_operations o,
2512: wip_entities we1,
2513: wip_entities we2
2514: WHERE wdj.wip_entity_id = we.wip_entity_id
2515: AND we1.wip_entity_id = l_from_wip_entity_id
2516: AND we2.wip_entity_id = l_to_wip_entity_id
2517: AND ( (we.wip_entity_name >= we1.wip_entity_name

Line 2552: wip_entities we,

2548: wdj.routing_revision_date,
2549: null bom_revision, -- Bug 3381547
2550: null routing_revision -- Bug 3381547
2551: FROM wip_discrete_jobs wdj,
2552: wip_entities we,
2553: bom_bill_of_materials b --3412747
2554: WHERE we.organization_id = wdj.organization_id
2555: AND we.wip_entity_id = wdj.wip_entity_id
2556: AND wdj.status_type = 1

Line 2584: wip_entities we,

2580: wdj.routing_revision_date,
2581: wdj.bom_revision bom_revision, -- Bug 3381547
2582: wdj.routing_revision routing_revision -- Bug 3381547
2583: FROM wip_discrete_jobs wdj,
2584: wip_entities we,
2585: wip_requirement_operations o
2586: WHERE wdj.wip_entity_id = we.wip_entity_id
2587: AND wdj.status_type = 1
2588: AND wdj.job_type = 1 -- 2986915

Line 2619: wip_entities we,

2615: wdj.routing_revision_date,
2616: null bom_revision, -- Bug 3381547
2617: null routing_revision -- Bug 3381547
2618: FROM wip_discrete_jobs wdj,
2619: wip_entities we,
2620: bom_bill_of_materials b --3412747
2621: WHERE we.organization_id = wdj.organization_id
2622: --WHERE we.organization_id = l_wip_organization_id
2623: AND wdj.wip_entity_id = we.wip_entity_id

Line 2654: wip_entities we,

2650: wdj.routing_revision_date,
2651: wdj.bom_revision bom_revision, -- Bug 3381547
2652: wdj.routing_revision routing_revision -- Bug 3381547
2653: FROM wip_discrete_jobs wdj,
2654: wip_entities we,
2655: bom_bill_of_materials b, --3412747
2656: wip_requirement_operations o
2657: WHERE wdj.wip_entity_id = we.wip_entity_id
2658: AND wdj.status_type = 1

Line 8772: FROM WIP_ENTITIES

8768: SELECT '1'
8769: FROM DUAL
8770: WHERE NOT EXISTS
8771: (SELECT 1
8772: FROM WIP_ENTITIES
8773: WHERE organization_id = l_organization_id
8774: AND wip_entity_name = l_wip_entity_name)
8775: ;
8776:

Line 8826: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,

8822: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
8823: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
8824: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
8825: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
8826: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
8827: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
8828: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,
8829: message_names OUT NOCOPY NameArray,
8830: token1 OUT NOCOPY NameArray,

Line 8827: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,

8823: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
8824: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
8825: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
8826: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
8827: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
8828: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,
8829: message_names OUT NOCOPY NameArray,
8830: token1 OUT NOCOPY NameArray,
8831: value1 OUT NOCOPY StringArray,

Line 8828: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,

8824: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
8825: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
8826: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
8827: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
8828: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,
8829: message_names OUT NOCOPY NameArray,
8830: token1 OUT NOCOPY NameArray,
8831: value1 OUT NOCOPY StringArray,
8832: translate1 OUT NOCOPY BooleanArray,