DBA Data[Home] [Help]

APPS.ENG_GLOBALS dependencies on DUAL

Line 2086: FROM DUAL

2082: , p_alternate_rtg_code VARCHAR2
2083: )
2084: IS
2085: SELECT 'Routing Exists'
2086: FROM DUAL
2087: WHERE NOT EXISTS ( SELECT routing_sequence_id
2088: FROM BOM_OPERATIONAL_ROUTINGS
2089: WHERE assembly_item_id = p_revised_item_id
2090: AND organization_id = p_organization_id

Line 2108: FROM DUAL ;

2104: -- Get Routing_Sequence_id
2105: CURSOR l_get_rtg_seq_csr
2106: IS
2107: SELECT BOM_OPERATIONAL_ROUTINGS_S.NEXTVAL routing_sequence_id
2108: FROM DUAL ;
2109:
2110:
2111: BEGIN
2112:

Line 2401: FROM DUAL

2397: , p_alternate_rtg_code VARCHAR2
2398: )
2399: IS
2400: SELECT 'Routing Exists'
2401: FROM DUAL
2402: WHERE NOT EXISTS ( SELECT routing_sequence_id
2403: FROM BOM_OPERATIONAL_ROUTINGS
2404: WHERE assembly_item_id = p_revised_item_id
2405: AND organization_id = p_organization_id

Line 2422: FROM DUAL ;

2418: -- Get Routing_Sequence_id
2419: CURSOR l_get_rtg_seq_csr
2420: IS
2421: SELECT BOM_OPERATIONAL_ROUTINGS_S.NEXTVAL routing_sequence_id
2422: FROM DUAL ;
2423:
2424:
2425: BEGIN
2426: