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

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

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

2129: p_organization_id NUMBER)
2130: IS
2131: SELECT 'X'
2132: FROM wip_operations o,
2133: wip_discrete_jobs w
2134: WHERE w.wip_entity_id = p_from_wip_entity_id
2135: AND w.status_type = 1
2136: AND o.wip_entity_id = w.wip_entity_id
2137: AND o.operation_seq_num = p_operation_seq_num

Line 2150: FROM wip_discrete_jobs wdj,

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

Line 2178: FROM wip_discrete_jobs wdj

2174: SELECT 'X'
2175: FROM DUAL
2176: WHERE EXISTS (
2177: SELECT 1
2178: FROM wip_discrete_jobs wdj
2179: WHERE wdj.lot_number= p_wip_lot_number
2180: AND wdj.status_type = 1
2181: AND wdj.primary_item_id = item.revised_item_id
2182: AND wdj.organization_Id = item.organization_id

Line 2249: wip_discrete_jobs w

2245: )
2246: IS
2247: SELECT 'X'
2248: FROM wip_operation_resources wor,
2249: wip_discrete_jobs w
2250: WHERE w.wip_entity_id = p_from_wip_entity_id
2251: AND w.status_type = 1
2252: AND wor.wip_entity_id = p_from_wip_entity_id
2253: AND wor.operation_seq_num = p_operation_seq_num

Line 2269: FROM wip_discrete_jobs wdj,

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

Line 2301: FROM wip_discrete_jobs wdj

2297: SELECT 'X'
2298: FROM DUAL
2299: WHERE EXISTS (
2300: SELECT 1
2301: FROM wip_discrete_jobs wdj
2302: WHERE wdj.lot_number= p_wip_lot_number
2303: AND wdj.primary_item_id = item.revised_item_id
2304: AND wdj.organization_Id = item.organization_id
2305: AND wdj.status_type = 1

Line 2327: wip_discrete_jobs w

2323: )
2324: IS
2325: SELECT 'X'
2326: FROM wip_requirement_operations ro,
2327: wip_discrete_jobs w
2328: WHERE w.wip_entity_id = p_from_wip_entity_id
2329: AND w.status_type = 1
2330: AND ro.wip_entity_id = p_from_wip_entity_id
2331: AND ro.operation_seq_num = p_operation_seq_num

Line 2348: FROM wip_discrete_jobs wdj,

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

Line 2380: FROM wip_discrete_jobs wdj

2376: SELECT 'X'
2377: FROM DUAL
2378: WHERE EXISTS (
2379: SELECT 1
2380: FROM wip_discrete_jobs wdj
2381: WHERE wdj.lot_number= p_wip_lot_number
2382: AND wdj.primary_item_id = item.revised_item_id
2383: AND wdj.organization_Id = item.organization_id
2384: AND wdj.status_type = 1

Line 2479: FROM wip_discrete_jobs wdj,

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

Line 2509: FROM wip_discrete_jobs wdj,

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

Line 2551: FROM wip_discrete_jobs wdj,

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

Line 2583: FROM wip_discrete_jobs wdj,

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

Line 2618: FROM wip_discrete_jobs wdj,

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

Line 2653: FROM wip_discrete_jobs wdj,

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

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

4977: END IF; -- nvl(item.to_wip_entity_id, 0) <> 0
4978:
4979:
4980: -- For ECO Lot type record
4981: -- Among WIP discrete jobs with same specified lot number, check
4982: -- if there is a WIP discrete job, in which the current opertion has
4983: -- already been disabled or changed.
4984: IF item.lot_number IS NOT NULL
4985: THEN

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

5500: CLOSE check_not_existing_res_job;
5501: END IF; -- envl(item.to_wip_entity_id, 0) <> 0
5502:
5503: --For ECO Lot type record
5504: --Among WIP discrete jobs with same specified lot number,
5505: -- check if there is a WIP discrete job, in which the
5506: -- current component has already been disabled or changed.
5507: IF item.lot_number IS NOT NULL
5508: THEN

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

6030: End if; --2974766
6031: END IF;
6032:
6033: -- For ECO Lot type record
6034: -- Among WIP discrete jobs with same specified lot number,
6035: -- check if there is a WIP discrete job, in which the
6036: -- current component has already been disabled or changed.
6037: IF item.lot_number IS NOT NULL
6038: THEN

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

8377: l_wip_jsi_insert_flag := 1;
8378: END IF ;
8379: END LOOP;
8380: ELSE
8381: -- for updating other common wip discrete jobs
8382:
8383: FOR wip_name_for_common_rec in l_wip_name_for_common_cur
8384: LOOP
8385: l_wip_job_name2 := wip_name_for_common_rec.wip_entity_name;