DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_SUGGESTIONS dependencies on DUAL

Line 418: -- We need to at least break the dual maintanance between H and I,

414:
415: --ATF_J
416: -- select operation_plan_ID from MMTT
417: -- This makes this file depending on patchset I and above.
418: -- We need to at least break the dual maintanance between H and I,
419: -- but can keep the dual maintanance between I and J
420:
421: CURSOR mmtt_cursor (l_line_id IN NUMBER) IS
422: SELECT

Line 419: -- but can keep the dual maintanance between I and J

415: --ATF_J
416: -- select operation_plan_ID from MMTT
417: -- This makes this file depending on patchset I and above.
418: -- We need to at least break the dual maintanance between H and I,
419: -- but can keep the dual maintanance between I and J
420:
421: CURSOR mmtt_cursor (l_line_id IN NUMBER) IS
422: SELECT
423: nvl(mmtt.LPN_ID, mmtt.CONTENT_LPN_ID),

Line 528: FROM DUAL WHERE exists

524:
525: BEGIN
526: SELECT 1
527: INTO l_process_flag_count
528: FROM DUAL WHERE exists
529: (SELECT 1
530: FROM mtl_txn_request_lines
531: WHERE lpn_id = p_lpn_id
532: AND line_status <> inv_globals.g_to_status_closed /* 3867448 */