DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_LOV dependencies on WMS_PUTAWAY_GROUP_TASKS_GTMP

Line 1390: from wms_putaway_group_tasks_gtmp wpgt

1386: WHERE organization_id = p_organization_id
1387: AND concatenated_segments LIKE p_concatenated_segments||l_append
1388: AND exists
1389: ( select 1
1390: from wms_putaway_group_tasks_gtmp wpgt
1391: where wpgt.inventory_item_id = msik.inventory_item_id
1392: and lpn_id = p_lpn_id
1393: and drop_type = 'ID')
1394: --Changes for GTIN

Line 1449: from wms_putaway_group_tasks_gtmp wpgt

1445: OR
1446: mcr.org_independent_flag = 'Y')
1447: AND exists
1448: ( select 1
1449: from wms_putaway_group_tasks_gtmp wpgt
1450: where wpgt.inventory_item_id = msik.inventory_item_id
1451: and lpn_id = p_lpn_id
1452: and drop_type = 'ID');
1453: