APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on DUAL

Line 96: from dual

92: lpn_loaded VARCHAR2(1) := 'N';
93: BEGIN
94: select 'Y'
95: into lpn_loaded
96: from dual
97: where exists (select 1
98: from wms_shipping_transaction_temp
99: where dock_door_id = p_dock_door_id
100: and dock_appoint_flag = p_dock_appoint_flag

Line 1247: from dual;

1243:
1244: if( l_transaction_temp_id is null ) then
1245: select mtl_material_Transactions_s.nextval
1246: into l_InvPCInRecType.transaction_temp_id
1247: from dual;
1248:
1249: l_transaction_temp_id := l_InvPCInRecType.transaction_temp_id;
1250:
1251: debug('About to call wsh_integration.Set_Inv_PC_Attributes','nested_serial_check');

Line 1442: from dual

1438:
1439: BEGIN
1440: select 1
1441: into x_result
1442: from dual
1443: where exists (select 1
1444: from wms_shipping_transaction_temp
1445: where delivery_id = l_delivery_id
1446: and direct_ship_flag='Y');

Line 1460: from dual

1456: and wdl.pick_up_stop_id = wts.stop_id;
1457:
1458: select 1
1459: into x_result
1460: from dual
1461: where exists (select 1
1462: from wms_shipping_transaction_temp
1463: where trip_id = l_trip_id
1464: and direct_ship_flag='Y');

Line 1763: from DUAL

1759: -- First check if the lpn has been loaded before
1760: BEGIN
1761: select 1
1762: into l_load_before
1763: from DUAL
1764: where exists (
1765: select 1
1766: from wms_shipping_transaction_temp
1767: where outermost_lpn_id = p_outermost_lpn_id

Line 3075: open x_missing_lpns FOR select 1 from dual;

3071: x_missing_count := l_count;
3072: end if;
3073: EXCEPTION
3074: WHEN NO_DATA_FOUND THEN
3075: open x_missing_lpns FOR select 1 from dual;
3076: return;
3077: END;
3078: open x_missing_lpns FOR
3079: select wlpn.license_plate_number

Line 3157: open x_missing_lpns FOR select 1 from dual;

3153: x_missing_count := l_count;
3154: end if;
3155: EXCEPTION
3156: WHEN NO_DATA_FOUND THEN
3157: open x_missing_lpns FOR select 1 from dual;
3158: return;
3159: END;
3160:
3161:

Line 3263: open x_missing_item FOR select 1 from dual;

3259: x_missing_count := l_count;
3260: end if;
3261: EXCEPTION
3262: WHEN NO_DATA_FOUND THEN
3263: open x_missing_item FOR select 1 from dual;
3264: return;
3265: END;
3266: open x_missing_item FOR
3267: select wnd.name

Line 3332: open x_missing_item FOR select 1 from dual;

3328: x_missing_count := l_count;
3329: end if;
3330: EXCEPTION
3331: WHEN NO_DATA_FOUND THEN
3332: open x_missing_item FOR select 1 from dual;
3333: return;
3334: END;
3335:
3336: /*Bug#5612236. In the below query, replaced 'MTL_SYSTEM_ITEMS_KFV' with

Line 3477: FROM DUAL

3473: EXIT WHEN delivered_ship_set%NOTFOUND;
3474: BEGIN
3475: /* SELECT 1
3476: INTO unshipped_count
3477: FROM DUAL
3478: WHERE exists (
3479: SELECT 1
3480: FROM wsh_delivery_details_ob_grp_v wdd
3481: WHERE

Line 5608: OPEN x_nt_item FOR SELECT 1 FROM dual;

5604: x_nt_count := l_count;
5605: END IF;
5606: EXCEPTION
5607: WHEN NO_DATA_FOUND THEN
5608: OPEN x_nt_item FOR SELECT 1 FROM dual;
5609: RETURN;
5610: END;
5611: OPEN x_nt_item FOR
5612: SELECT wnd.name,

Line 5673: OPEN x_nt_item FOR SELECT 1 FROM dual;

5669: x_nt_count := l_count;
5670: END IF;
5671: EXCEPTION
5672: WHEN NO_DATA_FOUND THEN
5673: OPEN x_nt_item FOR SELECT 1 FROM dual;
5674: RETURN;
5675: END;
5676: OPEN x_nt_item FOR
5677: SELECT wnd.name,