DBA Data[Home] [Help]

APPS.CSI_ORDER_FULFILL_PUB dependencies on WIP_REQUIREMENT_OPERATIONS

Line 4999: SELECT '1' FROM wip_requirement_operations

4995: BEGIN
4996: SELECT 'Y' INTO l_phantom
4997: FROM sys.dual
4998: WHERE EXISTS (
4999: SELECT '1' FROM wip_requirement_operations
5000: WHERE wip_entity_id = p_wip_entity_id
5001: AND inventory_item_id = p_option_item_id
5002: AND wip_supply_type = 6); --phantoms
5003: debug(' supply_type : phantom - just the fulfillment of option' );

Line 5012: FROM wip_requirement_operations

5008: SELECT wip_supply_type,
5009: quantity_issued
5010: INTO l_wip_supply_type,
5011: l_quantity_issued
5012: FROM wip_requirement_operations
5013: WHERE wip_entity_id = p_wip_entity_id
5014: AND inventory_item_id = p_option_item_id
5015: AND rownum = 1;
5016: