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 2326: FROM wip_requirement_operations ro,

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

Line 2361: FROM wip_requirement_operations ro

2357: AND we.organization_id = p_organization_id
2358: AND status_type = 1
2359: AND NOT EXISTS (
2360: SELECT 1
2361: FROM wip_requirement_operations ro
2362: WHERE ro.wip_entity_id = we.wip_entity_id
2363: AND ro.operation_seq_num = p_operation_seq_num
2364: AND ro.inventory_item_id= p_inventory_item_id
2365: AND ro.organization_id = p_organization_id

Line 2387: FROM wip_requirement_operations ro

2383: AND wdj.organization_Id = item.organization_id
2384: AND wdj.status_type = 1
2385: AND NOT EXISTS (
2386: SELECT 1
2387: FROM wip_requirement_operations ro
2388: WHERE ro.wip_entity_id = wdj.wip_entity_id
2389: AND ro.operation_seq_num = p_operation_seq_num
2390: AND ro.inventory_item_id = p_inventory_item_id
2391: AND ro.organization_id = p_organization_id

Line 2511: wip_requirement_operations o,

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

Line 2585: wip_requirement_operations o

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

Line 2656: wip_requirement_operations o

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