DBA Data[Home] [Help]

APPS.WIP_PICKING_PUB dependencies on DUAL

Line 616: from dual

612: begin
613:
614: select 1
615: into l_dummy
616: from dual
617: where exists
618: ( select 1
619: from MTL_TXN_REQUEST_LINES mtrl
620: where

Line 746: From dual

742: /* Bug 12861942 The original query don't make sense because its purpose is for checking if
743: there are existing/pending move order lines, while quantity_backordered doesn't have much relation
744: existing/pending move order, modified query below to use MTL_TXN_REQUEST_LINES instead
745: Select 1 Into l_dummy
746: From dual
747: Where exists
748: (select 1
749: from wip_requirement_operations
750: Where wip_entity_id = p_wip_entity_id

Line 770: From dual

766: /* Bug 12861942 The original query don't make sense because its purpose is for checking if
767: there are existing/pending move order lines, while quantity_backordered doesn't have much relation
768: existing/pending move order, modified query below to use MTL_TXN_REQUEST_LINES instead
769: Select 1 Into l_dummy
770: From dual
771: Where exists
772: (select 1
773: from wip_requirement_operations
774: Where wip_entity_id = p_wip_entity_id