DBA Data[Home] [Help]

APPS.WMS_CONSOLIDATION_PUB dependencies on WMS_GLOBALS

Line 2713: AND wdth.task_type = WMS_GLOBALS.G_WMS_TASK_TYPE_PICK --Bug5883610

2709: WHERE wlpn.organization_id = p_org_id
2710: AND wlpn.outermost_lpn_id = p_lpn_id
2711: AND wdth.organization_id = p_org_id
2712: AND wdth.transfer_lpn_id = wlpn.lpn_id
2713: AND wdth.task_type = WMS_GLOBALS.G_WMS_TASK_TYPE_PICK --Bug5883610
2714: AND nvl(wdth.is_parent,'X') <> 'Y' -- Bug 7319244
2715: AND ROWNUM < 2;
2716: */
2717:

Line 2775: AND wdth.task_type = WMS_GLOBALS.G_WMS_TASK_TYPE_PICK

2771: And Wddc.Lpn_Id = Wlpn.Lpn_Id
2772: And Mmt.Organization_Id = Wlpn.Organization_Id
2773: And Wlpn.Organization_Id = p_org_id
2774: And Wlpn.Outermost_Lpn_Id = p_lpn_id
2775: AND wdth.task_type = WMS_GLOBALS.G_WMS_TASK_TYPE_PICK
2776: And Rownum < 2;
2777: -- # bug 14360834 end
2778:
2779: EXCEPTION