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 1590: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,

1586: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
1587: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
1588: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1589: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1590: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
1591: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
1592: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,
1593: message_names OUT NOCOPY NameArray,
1594: token1 OUT NOCOPY NameArray,

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

1587: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
1588: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1589: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1590: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
1591: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
1592: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,
1593: message_names OUT NOCOPY NameArray,
1594: token1 OUT NOCOPY NameArray,
1595: value1 OUT NOCOPY StringArray,

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

1588: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1589: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1590: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
1591: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
1592: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,
1593: message_names OUT NOCOPY NameArray,
1594: token1 OUT NOCOPY NameArray,
1595: value1 OUT NOCOPY StringArray,
1596: translate1 OUT NOCOPY BooleanArray,

Line 2042: FROM wip_discrete_jobs wdj, wip_entities we

2038: wdj.bom_revision,
2039: wdj.routing_revision,
2040: wdj.bom_revision_date,
2041: wdj.routing_revision_date
2042: FROM wip_discrete_jobs wdj, wip_entities we
2043: WHERE wdj.wip_entity_id = p_from_wip_entity_id
2044: AND we.wip_entity_id = wdj.wip_entity_id
2045: AND wdj.status_type = 1;
2046:

Line 2060: wip_entities we,

2056: FROM DUAL
2057: WHERE EXISTS (
2058: SELECT 1
2059: FROM wip_discrete_jobs wdj,
2060: wip_entities we,
2061: wip_entities we1,
2062: wip_entities we2
2063: WHERE we1.wip_entity_id = p_from_wip_entity_id
2064: AND we2.wip_entity_id = p_to_wip_entity_id

Line 2061: wip_entities we1,

2057: WHERE EXISTS (
2058: SELECT 1
2059: FROM wip_discrete_jobs wdj,
2060: wip_entities we,
2061: wip_entities we1,
2062: wip_entities we2
2063: WHERE we1.wip_entity_id = p_from_wip_entity_id
2064: AND we2.wip_entity_id = p_to_wip_entity_id
2065: AND we.wip_entity_name >= we1.wip_entity_name

Line 2062: wip_entities we2

2058: SELECT 1
2059: FROM wip_discrete_jobs wdj,
2060: wip_entities we,
2061: wip_entities we1,
2062: wip_entities we2
2063: WHERE we1.wip_entity_id = p_from_wip_entity_id
2064: AND we2.wip_entity_id = p_to_wip_entity_id
2065: AND we.wip_entity_name >= we1.wip_entity_name
2066: AND we.wip_entity_name <= we2.wip_entity_name

Line 2086: FROM wip_discrete_jobs wdj, wip_entities we

2082: SELECT 'X'
2083: FROM DUAL
2084: WHERE EXISTS (
2085: SELECT 1
2086: FROM wip_discrete_jobs wdj, wip_entities we
2087: WHERE wdj.lot_number = p_wip_lot_number
2088: AND wdj.wip_entity_id = we.wip_entity_id
2089: AND wdj.primary_item_id = item.revised_item_id
2090: AND wdj.organization_Id = item.organization_id

Line 2247: wip_entities we,

2243: FROM DUAL
2244: WHERE EXISTS (
2245: SELECT 1
2246: FROM wip_discrete_jobs wdj,
2247: wip_entities we,
2248: wip_entities we1,
2249: wip_entities we2
2250: WHERE we1.wip_entity_id = p_from_wip_entity_id
2251: AND we2.wip_entity_id = p_to_wip_entity_id

Line 2248: wip_entities we1,

2244: WHERE EXISTS (
2245: SELECT 1
2246: FROM wip_discrete_jobs wdj,
2247: wip_entities we,
2248: wip_entities we1,
2249: wip_entities we2
2250: WHERE we1.wip_entity_id = p_from_wip_entity_id
2251: AND we2.wip_entity_id = p_to_wip_entity_id
2252: AND we.wip_entity_name >= we1.wip_entity_name

Line 2249: wip_entities we2

2245: SELECT 1
2246: FROM wip_discrete_jobs wdj,
2247: wip_entities we,
2248: wip_entities we1,
2249: wip_entities we2
2250: WHERE we1.wip_entity_id = p_from_wip_entity_id
2251: AND we2.wip_entity_id = p_to_wip_entity_id
2252: AND we.wip_entity_name >= we1.wip_entity_name
2253: AND we.wip_entity_name <= we2.wip_entity_name

Line 2366: wip_entities we,

2362: FROM DUAL
2363: WHERE EXISTS (
2364: SELECT 1
2365: FROM wip_discrete_jobs wdj,
2366: wip_entities we,
2367: wip_entities we1,
2368: wip_entities we2
2369: WHERE we1.wip_entity_id = p_from_wip_entity_id
2370: AND we2.wip_entity_id = p_to_wip_entity_id

Line 2367: wip_entities we1,

2363: WHERE EXISTS (
2364: SELECT 1
2365: FROM wip_discrete_jobs wdj,
2366: wip_entities we,
2367: wip_entities we1,
2368: wip_entities we2
2369: WHERE we1.wip_entity_id = p_from_wip_entity_id
2370: AND we2.wip_entity_id = p_to_wip_entity_id
2371: AND we.wip_entity_name >= we1.wip_entity_name

Line 2368: wip_entities we2

2364: SELECT 1
2365: FROM wip_discrete_jobs wdj,
2366: wip_entities we,
2367: wip_entities we1,
2368: wip_entities we2
2369: WHERE we1.wip_entity_id = p_from_wip_entity_id
2370: AND we2.wip_entity_id = p_to_wip_entity_id
2371: AND we.wip_entity_name >= we1.wip_entity_name
2372: AND we.wip_entity_name <= we2.wip_entity_name

Line 2445: wip_entities we,

2441: FROM DUAL
2442: WHERE EXISTS (
2443: SELECT 1
2444: FROM wip_discrete_jobs wdj,
2445: wip_entities we,
2446: wip_entities we1,
2447: wip_entities we2
2448: WHERE we1.wip_entity_id = p_from_wip_entity_id
2449: AND we2.wip_entity_id = p_to_wip_entity_id

Line 2446: wip_entities we1,

2442: WHERE EXISTS (
2443: SELECT 1
2444: FROM wip_discrete_jobs wdj,
2445: wip_entities we,
2446: wip_entities we1,
2447: wip_entities we2
2448: WHERE we1.wip_entity_id = p_from_wip_entity_id
2449: AND we2.wip_entity_id = p_to_wip_entity_id
2450: AND we.wip_entity_name >= we1.wip_entity_name

Line 2447: wip_entities we2

2443: SELECT 1
2444: FROM wip_discrete_jobs wdj,
2445: wip_entities we,
2446: wip_entities we1,
2447: wip_entities we2
2448: WHERE we1.wip_entity_id = p_from_wip_entity_id
2449: AND we2.wip_entity_id = p_to_wip_entity_id
2450: AND we.wip_entity_name >= we1.wip_entity_name
2451: AND we.wip_entity_name <= we2.wip_entity_name

Line 2576: wip_entities we,

2572: wdj.routing_revision_date,
2573: null bom_revision, -- Bug 3381547
2574: null routing_revision -- Bug 3381547
2575: FROM wip_discrete_jobs wdj,
2576: wip_entities we,
2577: wip_entities we1,
2578: wip_entities we2
2579: WHERE we1.wip_entity_id = l_from_wip_entity_id
2580: AND we2.wip_entity_id = l_to_wip_entity_id

Line 2577: wip_entities we1,

2573: null bom_revision, -- Bug 3381547
2574: null routing_revision -- Bug 3381547
2575: FROM wip_discrete_jobs wdj,
2576: wip_entities we,
2577: wip_entities we1,
2578: wip_entities we2
2579: WHERE we1.wip_entity_id = l_from_wip_entity_id
2580: AND we2.wip_entity_id = l_to_wip_entity_id
2581: AND ( (we.wip_entity_name >= we1.wip_entity_name

Line 2578: wip_entities we2

2574: null routing_revision -- Bug 3381547
2575: FROM wip_discrete_jobs wdj,
2576: wip_entities we,
2577: wip_entities we1,
2578: wip_entities we2
2579: WHERE we1.wip_entity_id = l_from_wip_entity_id
2580: AND we2.wip_entity_id = l_to_wip_entity_id
2581: AND ( (we.wip_entity_name >= we1.wip_entity_name
2582: and we.wip_entity_name <= we2.wip_entity_name)

Line 2606: wip_entities we,

2602: wdj.routing_revision_date,
2603: wdj.bom_revision bom_revision, -- Bug 3381547
2604: wdj.routing_revision routing_revision -- Bug 3381547
2605: FROM wip_discrete_jobs wdj,
2606: wip_entities we,
2607: wip_requirement_operations o,
2608: wip_entities we1,
2609: wip_entities we2
2610: WHERE wdj.wip_entity_id = we.wip_entity_id

Line 2608: wip_entities we1,

2604: wdj.routing_revision routing_revision -- Bug 3381547
2605: FROM wip_discrete_jobs wdj,
2606: wip_entities we,
2607: wip_requirement_operations o,
2608: wip_entities we1,
2609: wip_entities we2
2610: WHERE wdj.wip_entity_id = we.wip_entity_id
2611: AND we1.wip_entity_id = l_from_wip_entity_id
2612: AND we2.wip_entity_id = l_to_wip_entity_id

Line 2609: wip_entities we2

2605: FROM wip_discrete_jobs wdj,
2606: wip_entities we,
2607: wip_requirement_operations o,
2608: wip_entities we1,
2609: wip_entities we2
2610: WHERE wdj.wip_entity_id = we.wip_entity_id
2611: AND we1.wip_entity_id = l_from_wip_entity_id
2612: AND we2.wip_entity_id = l_to_wip_entity_id
2613: AND ( (we.wip_entity_name >= we1.wip_entity_name

Line 2648: wip_entities we,

2644: wdj.routing_revision_date,
2645: null bom_revision, -- Bug 3381547
2646: null routing_revision -- Bug 3381547
2647: FROM wip_discrete_jobs wdj,
2648: wip_entities we,
2649: bom_bill_of_materials b --3412747
2650: WHERE we.organization_id = wdj.organization_id
2651: AND we.wip_entity_id = wdj.wip_entity_id
2652: AND wdj.status_type = 1

Line 2680: wip_entities we,

2676: wdj.routing_revision_date,
2677: wdj.bom_revision bom_revision, -- Bug 3381547
2678: wdj.routing_revision routing_revision -- Bug 3381547
2679: FROM wip_discrete_jobs wdj,
2680: wip_entities we,
2681: wip_requirement_operations o
2682: WHERE wdj.wip_entity_id = we.wip_entity_id
2683: AND wdj.status_type = 1
2684: AND wdj.job_type = 1 -- 2986915

Line 2715: wip_entities we,

2711: wdj.routing_revision_date,
2712: null bom_revision, -- Bug 3381547
2713: null routing_revision -- Bug 3381547
2714: FROM wip_discrete_jobs wdj,
2715: wip_entities we,
2716: bom_bill_of_materials b --3412747
2717: WHERE we.organization_id = wdj.organization_id
2718: --WHERE we.organization_id = l_wip_organization_id
2719: AND wdj.wip_entity_id = we.wip_entity_id

Line 2751: wip_entities we,

2747: wdj.routing_revision_date,
2748: wdj.bom_revision bom_revision, -- Bug 3381547
2749: wdj.routing_revision routing_revision -- Bug 3381547
2750: FROM wip_discrete_jobs wdj,
2751: wip_entities we,
2752: bom_bill_of_materials b, --3412747
2753: wip_requirement_operations o
2754: WHERE wdj.wip_entity_id = we.wip_entity_id
2755: AND wdj.status_type = 1

Line 2801: wip_entities we,

2797: wdj.routing_revision_date,
2798: null bom_revision,
2799: null routing_revision
2800: FROM wip_discrete_jobs wdj,
2801: wip_entities we,
2802: bom_operational_routings b
2803: WHERE we.organization_id = wdj.organization_id
2804: AND wdj.wip_entity_id = we.wip_entity_id
2805: AND wdj.status_type = 1

Line 9117: FROM WIP_ENTITIES

9113: SELECT '1'
9114: FROM DUAL
9115: WHERE NOT EXISTS
9116: (SELECT 1
9117: FROM WIP_ENTITIES
9118: WHERE organization_id = l_organization_id
9119: AND wip_entity_name = l_wip_entity_name)
9120: ;
9121:

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

9167: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
9168: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
9169: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
9170: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
9171: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
9172: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
9173: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,
9174: message_names OUT NOCOPY NameArray,
9175: token1 OUT NOCOPY NameArray,

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

9168: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
9169: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
9170: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
9171: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
9172: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
9173: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,
9174: message_names OUT NOCOPY NameArray,
9175: token1 OUT NOCOPY NameArray,
9176: value1 OUT NOCOPY StringArray,

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

9169: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
9170: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
9171: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
9172: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
9173: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,
9174: message_names OUT NOCOPY NameArray,
9175: token1 OUT NOCOPY NameArray,
9176: value1 OUT NOCOPY StringArray,
9177: translate1 OUT NOCOPY BooleanArray,