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_DISCRETE_JOBS

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 2059: FROM wip_discrete_jobs wdj,

2055: SELECT 'X'
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

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 2229: wip_discrete_jobs w

2225: p_organization_id NUMBER)
2226: IS
2227: SELECT 'X'
2228: FROM wip_operations o,
2229: wip_discrete_jobs w
2230: WHERE w.wip_entity_id = p_from_wip_entity_id
2231: AND w.status_type = 1
2232: AND o.wip_entity_id = w.wip_entity_id
2233: AND o.operation_seq_num = p_operation_seq_num

Line 2246: FROM wip_discrete_jobs wdj,

2242: SELECT 'X'
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

Line 2274: FROM wip_discrete_jobs wdj

2270: SELECT 'X'
2271: FROM DUAL
2272: WHERE EXISTS (
2273: SELECT 1
2274: FROM wip_discrete_jobs wdj
2275: WHERE wdj.lot_number= p_wip_lot_number
2276: AND wdj.status_type = 1
2277: AND wdj.primary_item_id = item.revised_item_id
2278: AND wdj.organization_Id = item.organization_id

Line 2345: wip_discrete_jobs w

2341: )
2342: IS
2343: SELECT 'X'
2344: FROM wip_operation_resources wor,
2345: wip_discrete_jobs w
2346: WHERE w.wip_entity_id = p_from_wip_entity_id
2347: AND w.status_type = 1
2348: AND wor.wip_entity_id = p_from_wip_entity_id
2349: AND wor.operation_seq_num = p_operation_seq_num

Line 2365: FROM wip_discrete_jobs wdj,

2361: SELECT 'X'
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

Line 2397: FROM wip_discrete_jobs wdj

2393: SELECT 'X'
2394: FROM DUAL
2395: WHERE EXISTS (
2396: SELECT 1
2397: FROM wip_discrete_jobs wdj
2398: WHERE wdj.lot_number= p_wip_lot_number
2399: AND wdj.primary_item_id = item.revised_item_id
2400: AND wdj.organization_Id = item.organization_id
2401: AND wdj.status_type = 1

Line 2423: wip_discrete_jobs w

2419: )
2420: IS
2421: SELECT 'X'
2422: FROM wip_requirement_operations ro,
2423: wip_discrete_jobs w
2424: WHERE w.wip_entity_id = p_from_wip_entity_id
2425: AND w.status_type = 1
2426: AND ro.wip_entity_id = p_from_wip_entity_id
2427: AND ro.operation_seq_num = p_operation_seq_num

Line 2444: FROM wip_discrete_jobs wdj,

2440: SELECT 'X'
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

Line 2476: FROM wip_discrete_jobs wdj

2472: SELECT 'X'
2473: FROM DUAL
2474: WHERE EXISTS (
2475: SELECT 1
2476: FROM wip_discrete_jobs wdj
2477: WHERE wdj.lot_number= p_wip_lot_number
2478: AND wdj.primary_item_id = item.revised_item_id
2479: AND wdj.organization_Id = item.organization_id
2480: AND wdj.status_type = 1

Line 2575: FROM wip_discrete_jobs wdj,

2571: wdj.bom_revision_date,
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

Line 2605: FROM wip_discrete_jobs wdj,

2601: wdj.bom_revision_date,
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

Line 2647: FROM wip_discrete_jobs wdj,

2643: wdj.bom_revision_date,
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

Line 2679: FROM wip_discrete_jobs wdj,

2675: wdj.bom_revision_date,
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

Line 2714: FROM wip_discrete_jobs wdj,

2710: wdj.bom_revision_date,
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

Line 2750: FROM wip_discrete_jobs wdj,

2746: wdj.bom_revision_date,
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

Line 2800: FROM wip_discrete_jobs wdj,

2796: wdj.bom_revision_date,
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

Line 5245: -- Among WIP discrete jobs with same specified lot number, check

5241: END IF; -- nvl(item.to_wip_entity_id, 0) <> 0
5242:
5243:
5244: -- For ECO Lot type record
5245: -- Among WIP discrete jobs with same specified lot number, check
5246: -- if there is a WIP discrete job, in which the current opertion has
5247: -- already been disabled or changed.
5248: IF item.lot_number IS NOT NULL
5249: THEN

Line 5768: --Among WIP discrete jobs with same specified lot number,

5764: CLOSE check_not_existing_res_job;
5765: END IF; -- envl(item.to_wip_entity_id, 0) <> 0
5766:
5767: --For ECO Lot type record
5768: --Among WIP discrete jobs with same specified lot number,
5769: -- check if there is a WIP discrete job, in which the
5770: -- current component has already been disabled or changed.
5771: IF item.lot_number IS NOT NULL
5772: THEN

Line 6341: -- Among WIP discrete jobs with same specified lot number,

6337: End if; --2974766
6338: END IF;
6339:
6340: -- For ECO Lot type record
6341: -- Among WIP discrete jobs with same specified lot number,
6342: -- check if there is a WIP discrete job, in which the
6343: -- current component has already been disabled or changed.
6344: IF item.lot_number IS NOT NULL
6345: THEN

Line 8725: -- for updating other common wip discrete jobs

8721: l_wip_jsi_insert_flag := 1;
8722: END IF ;
8723: END LOOP; */
8724: ELSE
8725: -- for updating other common wip discrete jobs
8726:
8727: FOR wip_name_for_common_rec in l_wip_name_for_common_cur
8728: LOOP
8729: l_wip_job_name2 := wip_name_for_common_rec.wip_entity_name;