APPS.WIP_DISCRETE_WS_MOVE dependencies on INV_MATERIAL_STATUS_GRP

Line 524: AND inv_material_status_grp.is_status_applicable

520: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)
521: AND b.subinventory_code = p_Subinventory_Code
522: AND a.inventory_location_id = b.secondary_locator
523: AND a.concatenated_segments LIKE (p_concatenated_segments)
524: AND inv_material_status_grp.is_status_applicable
525: ( p_wms_installed,
526: NULL,
527: p_transaction_type_id,
528: NULL,

Line 549: AND inv_material_status_grp.is_status_applicable

545: WHERE organization_id = p_Organization_Id
546: AND subinventory_code = p_Subinventory_Code
547: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
548: AND concatenated_segments LIKE (p_concatenated_segments )
549: AND inv_material_status_grp.is_status_applicable
550: ( p_wms_installed,
551: NULL,
552: p_transaction_type_id,
553: NULL,

Line 580: AND inv_material_status_grp.is_status_applicable

576: AND a.inventory_location_id = b.secondary_locator
577: AND a.concatenated_segments like (p_concatenated_segments )
578: AND nvl(a.project_id,-1) = nvl(p_project_id, -1)
579: AND nvl(a.task_id, -1) = nvl(p_task_id, -1)
580: AND inv_material_status_grp.is_status_applicable
581: ( p_wms_installed,
582: NULL,
583: p_transaction_type_id,
584: NULL,

Line 607: AND inv_material_status_grp.is_status_applicable

603: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
604: AND concatenated_segments LIKE (p_concatenated_segments )
605: AND nvl(project_id,-1) = nvl(p_project_id, -1)
606: AND nvl(task_id, -1) = nvl(p_task_id, -1)
607: AND inv_material_status_grp.is_status_applicable
608: ( p_wms_installed,
609: NULL,
610: p_transaction_type_id,
611: NULL,