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.CSI_ORDER_FULFILL_PUB dependencies on WIP_REQUIREMENT_OPERATIONS

Line 5051: SELECT '1' FROM wip_requirement_operations

5047: -- Selecting wip requirement operation for which required qty is > 0
5048: SELECT 'Y' INTO l_phantom
5049: FROM sys.dual
5050: WHERE EXISTS (
5051: SELECT '1' FROM wip_requirement_operations
5052: WHERE wip_entity_id = p_wip_entity_id
5053: AND inventory_item_id = p_option_item_id
5054: AND required_quantity > 0
5055: AND wip_supply_type = 6); --phantoms

Line 5083: FROM wip_requirement_operations

5079: SELECT wip_supply_type,
5080: quantity_issued
5081: INTO l_wip_supply_type,
5082: l_quantity_issued
5083: FROM wip_requirement_operations
5084: WHERE wip_entity_id = p_wip_entity_id
5085: AND inventory_item_id = p_option_item_id
5086: AND required_quantity > 0
5087: AND rownum = 1;

Line 5175: ,wip_requirement_operations wro

5171: ,bom_bill_of_materials bom
5172: ,mtl_system_items msi
5173: ,mtl_system_items msip
5174: ,mtl_parameters mp
5175: ,wip_requirement_operations wro
5176: WHERE bet.group_id = p_group_id
5177: AND bet.plan_level > 0 -- Ignore Top Most
5178: AND bet.component_item_id = msi.inventory_item_id
5179: AND bet.organization_id = msi.organization_id