DBA Data[Home] [Help]

APPS.WIP_VALIDATE dependencies on MTL_SYSTEM_ITEMS

Line 739: FROM mtl_system_items

735: END IF;
736:
737: SELECT 'VALID'
738: INTO l_dummy
739: FROM mtl_system_items
740: WHERE inventory_item_id = p_primary_item_id
741: AND organization_id = p_organization_id;
742:
743: RETURN TRUE;

Line 2134: FROM mtl_system_items

2130: END IF;
2131:
2132: SELECT 'VALID'
2133: INTO l_dummy
2134: FROM mtl_system_items
2135: WHERE inventory_item_id = p_bom_reference_id
2136: AND organization_id = p_organization_id;
2137:
2138: RETURN TRUE;

Line 2402: FROM mtl_system_items

2398: END IF;
2399:
2400: SELECT 'VALID'
2401: INTO l_dummy
2402: FROM mtl_system_items
2403: WHERE inventory_item_id = p_routing_reference_id
2404: AND organization_id = p_organization_id;
2405:
2406: RETURN TRUE;

Line 2989: FROM mtl_system_items

2985: END IF;
2986:
2987: SELECT 'VALID'
2988: INTO l_dummy
2989: FROM mtl_system_items
2990: WHERE inventory_item_id = p_inventory_item_id
2991: AND organization_id = p_organization_id;
2992:
2993: