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_REQUIREMENT_OPERATIONS

Line 2422: FROM wip_requirement_operations ro,

2418: p_organization_id NUMBER
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

Line 2457: FROM wip_requirement_operations ro

2453: AND we.organization_id = p_organization_id
2454: AND status_type = 1
2455: AND NOT EXISTS (
2456: SELECT 1
2457: FROM wip_requirement_operations ro
2458: WHERE ro.wip_entity_id = we.wip_entity_id
2459: AND ro.operation_seq_num = p_operation_seq_num
2460: AND ro.inventory_item_id= p_inventory_item_id
2461: AND ro.organization_id = p_organization_id

Line 2483: FROM wip_requirement_operations ro

2479: AND wdj.organization_Id = item.organization_id
2480: AND wdj.status_type = 1
2481: AND NOT EXISTS (
2482: SELECT 1
2483: FROM wip_requirement_operations ro
2484: WHERE ro.wip_entity_id = wdj.wip_entity_id
2485: AND ro.operation_seq_num = p_operation_seq_num
2486: AND ro.inventory_item_id = p_inventory_item_id
2487: AND ro.organization_id = p_organization_id

Line 2607: wip_requirement_operations o,

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
2611: AND we1.wip_entity_id = l_from_wip_entity_id

Line 2681: wip_requirement_operations o

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
2685: AND (( wdj.scheduled_start_date >= eff_date

Line 2753: wip_requirement_operations o

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
2756: AND wdj.job_type = 1 -- 2986915
2757: AND (( wdj.scheduled_start_date >= eff_date