APPS.ENG_VALIDATE_REV_COMPONENT dependencies on DUAL

Line 153: SELECT 'X' date_available FROM sys.dual

149: RETURN BOOLEAN
150: IS
151: X_Count NUMBER := 0;
152: CURSOR X_All_Dates IS
153: SELECT 'X' date_available FROM sys.dual
154: WHERE EXISTS (
155: SELECT 1 from BOM_Inventory_Components
156: WHERE Component_Item_Id = X_Member_Item_Id
157: AND Bill_Sequence_Id = X_Bill_Sequence_Id

Line 208: SELECT 'X' unit_available FROM sys.dual

204: RETURN BOOLEAN
205: IS
206: X_Count NUMBER := 0;
207: CURSOR X_All_Numbers IS
208: SELECT 'X' unit_available FROM sys.dual
209: WHERE EXISTS (
210: SELECT 1 from BOM_Inventory_Components
211: WHERE Component_Item_Id = X_Member_Item_Id
212: AND Bill_Sequence_Id = X_Bill_Sequence_Id

Line 1025: FROM sys.dual

1021: -- Local function to verify locators
1022: FUNCTION Check_Locators RETURN BOOLEAN IS
1023: Cursor CheckDuplicate is
1024: SELECT 'checking for duplicates' dummy
1025: FROM sys.dual
1026: WHERE EXISTS (
1027: SELECT null
1028: FROM mtl_item_locations
1029: WHERE organization_id = g_rev_comp_Unexp_rec.organization_id

Line 3588: FROM sys.dual

3584: IF p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_DELETE THEN
3585: BEGIN
3586: SELECT 'Component cancelled'
3587: INTO l_dummy
3588: FROM sys.dual
3589: WHERE NOT EXISTS
3590: (SELECT 1 from bom_inventory_components
3591: WHERE component_sequence_id =
3592: p_rev_comp_Unexp_rec.component_sequence_id

Line 3842: FROM sys.dual

3838: l_is_comp_unit_controlled BOOLEAN := FALSE;
3839:
3840: CURSOR c_CheckCancelled IS
3841: SELECT 1
3842: FROM sys.dual
3843: WHERE NOT EXISTS
3844: ( SELECT component_sequence_id
3845: FROM bom_inventory_components
3846: WHERE component_item_id = p_component_item_id