APPS.BOM_VALIDATE_RTG_HEADER dependencies on DUAL

Line 921: FROM SYS.DUAL

917: CURSOR l_subinv_csr ( p_organization_id NUMBER
918: , p_subinventory VARCHAR2)
919: IS
920: SELECT 'SubInv exists'
921: FROM SYS.DUAL
922: WHERE NOT EXISTS ( SELECT null
923: FROM mtl_secondary_inventories
924: WHERE organization_id = p_organization_id
925: AND secondary_inventory_name = p_subinventory

Line 989: FROM sys.dual

985: RETURN BOOLEAN
986: IS
987: Cursor CheckDuplicate is
988: SELECT 'checking for duplicates' dummy
989: FROM sys.dual
990: WHERE EXISTS (
991: SELECT null
992: FROM mtl_item_locations
993: WHERE organization_id = p_organization_id

Line 1293: FROM sys.dual

1289: P_org_id NUMBER,
1290: p_cfm_rtg_flag NUMBER,
1291: P_alt_desg VARCHAR2) is
1292: SELECT 1 dummy
1293: FROM sys.dual
1294: WHERE not exists (
1295: SELECT NULL
1296: FROM bom_operational_routings bor
1297: WHERE bor.routing_sequence_id = P_cmn_rtg_id

Line 1313: FROM sys.dual

1309: CURSOR c_check_Ops(
1310: p_routing_sequence_id NUMBER)
1311: IS
1312: SELECT 'Y' has_ops
1313: FROM sys.dual
1314: WHERE exists ( Select null
1315: FROM Bom_Operation_Sequences
1316: WHERE routing_sequence_id =
1317: p_routing_sequence_id );

Line 1327: FROM sys.dual

1323: p_common_routing_sequence_id NUMBER
1324: )
1325: IS
1326: SELECT 'Y'
1327: FROM sys.dual
1328: WHERE exists ( Select null
1329: FROM bom_operational_routings
1330: WHERE common_routing_sequence_id <>
1331: p_common_routing_sequence_id

Line 1344: FROM sys.dual

1340: p_routing_sequence_id NUMBER
1341: )
1342: IS
1343: SELECT 'Y'
1344: FROM sys.dual
1345: WHERE exists ( Select null
1346: FROM Bom_Operation_Sequences
1347: WHERE routing_sequence_id =p_routing_sequence_id
1348: AND NVL(disable_date, trunc(sysdate) + 1)

Line 1363: FROM sys.dual

1359: p_common_routing_sequence_id NUMBER
1360: )
1361: IS
1362: SELECT 'Y'
1363: FROM sys.dual
1364: WHERE exists ( Select null
1365: FROM Bom_Operational_Routings
1366: WHERE organization_id = P_organization_id
1367: AND assembly_item_id = P_assembly_item_id

Line 1382: FROM sys.dual

1378: p_common_routing_sequence_id NUMBER
1379: )
1380: IS
1381: SELECT 'Y'
1382: FROM sys.dual
1383: WHERE exists ( Select null
1384: FROM Bom_Operational_Routings
1385: WHERE organization_id = p_organization_id
1386: AND Assembly_Item_Id = p_assembly_item_id

Line 1424: SELECT NULL from dual

1420: AND secondary_inventory_name =
1421: p_rtg_header_rec.completion_subinventory;
1422:
1423: CURSOR c_Check_BOM IS
1424: SELECT NULL from dual
1425: WHERE exists
1426: (SELECT 1 /* Checking for the BOM components operation seq. num. for alternate */
1427: FROM BOM_BILL_OF_MATERIALS BOM, BOM_COMPONENT_OPERATIONS BCO
1428: WHERE BOM.ORGANIZATION_ID = p_rtg_header_unexp_rec.organization_id

Line 2545: FROM SYS.DUAL ;

2541: IF l_rtg_header_unexp_rec.Routing_Type IS NULL -- Added for bug 2774997
2542: THEN
2543: SELECT DECODE(p_rtg_header_rec.eng_routing_flag, 1, 2, 1)
2544: INTO l_rtg_header_unexp_rec.routing_type
2545: FROM SYS.DUAL ;
2546: END IF;
2547: -- Return the unexposed record
2548: x_rtg_header_unexp_rec := l_rtg_header_unexp_rec;
2549:

Line 2579: from dual

2575: , x_return_status IN OUT NOCOPY VARCHAR2
2576: ) IS
2577: Cursor check_ssos_cur IS
2578: Select 'IsNotValid'
2579: from dual
2580: where p_rtg_header_rec.ser_start_op_seq NOT IN
2581: (select bos.OPERATION_SEQ_NUM
2582: from bom_operation_sequences bos
2583: where bos.ROUTING_SEQUENCE_ID = p_rtg_header_unexp_rec.routing_sequence_id