APPS.INV_COMINGLING_UTILS dependencies on DUAL

Line 117: FROM dual

113: end if;
114:
115: BEGIN
116: SELECT 'Y' INTO l_serial_item
117: FROM dual
118: WHERE
119: exists
120: (--select count(*)
121: --into l_serial_count

Line 143: FROM dual

139: ** Look at MTL_ONHAND_QUANTIES, the on hand table
140: */
141: BEGIN
142: SELECT 'Y' INTO l_moq_exist
143: FROM dual
144: WHERE
145: exists
146: (SELECT organization_id
147: --BUG 2921882

Line 201: l_mmtt_receipts_exist FROM dual

197: */
198: if (p_lot_number is null) then
199: BEGIN
200: SELECT 'Y' INTO
201: l_mmtt_receipts_exist FROM dual
202: WHERE
203: exists
204: (SELECT organization_id
205: --BUG 2921882

Line 240: FROM dual

236: else /* Lot Controlled Item transaction */
237:
238: BEGIN
239: SELECT 'Y' INTO l_mmtt_receipts_exist
240: FROM dual
241: WHERE
242: exists
243: (SELECT mmtt.organization_id --Bug 4496965
244: --BUG 2921882

Line 299: FROM dual

295: --Splitting the query for bug 2921882
296: IF p_locator_id IS NULL THEN
297: BEGIN
298: SELECT 'Y' INTO l_mmtt_transfers_exist
299: FROM dual
300: WHERE
301: exists
302: (SELECT organization_id
303: --BUG 2921882

Line 329: FROM dual

325: END;
326: ELSE
327: BEGIN
328: SELECT 'Y' INTO l_mmtt_transfers_exist
329: FROM dual
330: WHERE
331: exists
332: (SELECT organization_id
333: --BUG 2921882

Line 363: FROM dual

359:
360: IF p_locator_id IS NULL then
361: BEGIN
362: SELECT 'Y' INTO l_mmtt_transfers_exist
363: FROM dual
364: WHERE
365: exists
366: (SELECT mmtt.organization_id --Bug 4496965
367: --BUG 2921882

Line 395: FROM dual

391: END;
392: ELSE
393: BEGIN
394: SELECT 'Y' INTO l_mmtt_transfers_exist
395: FROM dual
396: WHERE
397: exists
398: (SELECT mmtt.organization_id --Bug 4496965
399: --BUG 2921882

Line 440: FROM dual

436: */
437:
438: BEGIN
439: SELECT 'Y' INTO l_lpn_contents_exist
440: FROM dual
441: WHERE
442: exists
443: (SELECT organization_id
444: --BUG 2921882

Line 481: FROM dual

477:
478: IF (p_lot_number is null) THEN
479: BEGIN
480: SELECT 'Y' INTO l_mmtt_lpn_receipts_exist
481: FROM dual
482: WHERE
483: exists
484: (SELECT organization_id
485: --BUG 2921882

Line 512: FROM dual

508:
509: ELSE /* Lot Controlled LPN transaction */
510: BEGIN
511: SELECT 'Y' INTO l_mmtt_lpn_receipts_exist
512: FROM dual
513: WHERE
514: exists
515: (SELECT mmtt.organization_id --Bug 4496965
516: --BUG 2921882

Line 684: FROM dual

680: ***/
681:
682: BEGIN
683: SELECT 'Y' INTO l_serials_exist
684: FROM dual
685: WHERE exists
686: ( SELECT 1
687: FROM mtl_serial_numbers_temp
688: WHERE transaction_temp_id = p_mmtt_rec.transaction_temp_id);

Line 693: FROM dual

689: EXCEPTION
690: WHEN no_data_found THEN
691: BEGIN
692: SELECT 'Y' INTO l_serials_exist
693: FROM dual
694: WHERE exists
695: (SELECT msnt.transaction_temp_id
696: FROM
697: mtl_serial_numbers_temp msnt,