APPS.ENG_VALIDATE_REVISED_ITEM dependencies on DUAL

Line 1164: FROM SYS.DUAL

1160:
1161: CURSOR rtg_reschedule_valid
1162: IS
1163: SELECT 'Invalid Op Seq Exists'
1164: FROM SYS.DUAL
1165: WHERE EXISTS ( SELECT 'X'
1166: FROM BOM_OPERATION_SEQUENCES
1167: WHERE change_notice = p_revised_item_rec.eco_name
1168: AND routing_sequence_id = p_rev_item_unexp_rec.routing_sequence_id

Line 1377: FROM SYS.DUAL

1373: , p_routing_sequence_id NUMBER)
1374:
1375: IS
1376: SELECT 'CTP not unique'
1377: FROM SYS.DUAL
1378: WHERE EXISTS (SELECT NULL
1379: FROM BOM_OPERATIONAL_ROUTINGS
1380: WHERE ctp_flag = 1 -- Yes
1381: AND NVL(cfm_routing_flag, 2) = NVL(p_cfm_routing_flag, 2)

Line 1421: FROM SYS.DUAL

1417: , p_priority NUMBER )
1418:
1419: IS
1420: SELECT 'Priority not unique'
1421: FROM SYS.DUAL
1422: WHERE EXISTS (SELECT NULL
1423: FROM BOM_OPERATIONAL_ROUTINGS
1424: WHERE priority = p_priority
1425: AND NVL(cfm_routing_flag, 2) = NVL(p_cfm_routing_flag, 2)

Line 1461: FROM SYS.DUAL

1457: CURSOR l_subinv_csr ( p_organization_id NUMBER
1458: , p_subinventory VARCHAR2)
1459: IS
1460: SELECT 'SubInv exists'
1461: FROM SYS.DUAL
1462: WHERE NOT EXISTS ( SELECT null
1463: FROM mtl_secondary_inventories
1464: WHERE organization_id = p_organization_id
1465: AND secondary_inventory_name = p_subinventory

Line 1535: FROM sys.dual

1531: RETURN BOOLEAN
1532: IS
1533: Cursor CheckDuplicate is
1534: SELECT 'checking for duplicates' dummy
1535: FROM sys.dual
1536: WHERE EXISTS (
1537: SELECT null
1538: FROM mtl_item_locations
1539: WHERE organization_id = p_organization_id

Line 2274: FROM SYS.DUAL

2270: , p_rev_item_id NUMBER
2271: )
2272: IS
2273: SELECT 'Lot Number is invalid'
2274: FROM SYS.DUAL
2275: WHERE NOT EXISTS ( SELECT 'Valid Lot'
2276: FROM WIP_DISCRETE_JOBS wdj1
2277: WHERE wdj1.lot_number = p_lot_number
2278: AND wdj1.status_type = 1

Line 2302: FROM SYS.DUAL

2298: , p_bill_sequence_id NUMBER
2299: , p_routing_sequence_id NUMBER )
2300: IS
2301: SELECT 'WO Range is invalid'
2302: FROM SYS.DUAL
2303: WHERE NOT EXISTS ( SELECT 'Valid WO'
2304: FROM WIP_DISCRETE_JOBS wdj1
2305: , WIP_ENTITIES we1
2306: WHERE wdj1.status_type = 1

Line 4058: FROM SYS.DUAL;

4054: p_revised_item_rec.new_effective_date
4055: )
4056: INTO l_token_tbl(3).token_value,
4057: l_token_tbl(4).token_value
4058: FROM SYS.DUAL;
4059:
4060: l_token_tbl(2).token_name := 'ECO_NAME';
4061: l_token_tbl(2).token_value := p_revised_item_rec.eco_name;
4062:

Line 5437: FROM SYS.DUAL

5433: -- to validate alternate designator.
5434: CURSOR c_Check_Alternate( p_alt_designator VARCHAR2,
5435: p_organization_id NUMBER ) IS
5436: SELECT 'Invalid Alaternatae'
5437: FROM SYS.DUAL
5438: WHERE NOT EXISTS ( SELECT NULL
5439: FROM bom_alternate_designators
5440: WHERE alternate_designator_code = p_alt_designator
5441: AND organization_id = p_organization_id

Line 5976: FROM SYS.DUAL

5972: -- Enhancement for ECO Routing
5973: ******************************************************************/
5974: CURSOR rev_op_seq IS
5975: SELECT 'Rev Op Exist'
5976: FROM SYS.DUAL
5977: WHERE EXISTS ( SELECT NULL
5978: FROM BOM_OPERATION_SEQUENCES
5979: WHERE revised_item_sequence_id =
5980: p_rev_item_unexp_rec.revised_item_sequence_id) ;

Line 6512: FROM SYS.DUAL

6508:
6509: -- Moved from BOM_Validate_Op_Seq.Check_Access by MK on 12/04
6510: CURSOR c_CheckCancelled IS
6511: SELECT 1
6512: FROM SYS.DUAL
6513: WHERE NOT EXISTS
6514: ( SELECT NULL
6515: FROM BOM_OPERATION_SEQUENCES
6516: WHERE NVL(operation_type, 1) = NVL(p_operation_type, 1)