APPS.WIP_DISCRETE_WS_MOVE dependencies on INV_MATERIAL_STATUS_GRP

Line 553: AND inv_material_status_grp.is_status_applicable

549: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)
550: AND b.subinventory_code = p_Subinventory_Code
551: AND a.inventory_location_id = b.secondary_locator
552: AND a.concatenated_segments LIKE (p_concatenated_segments)
553: AND inv_material_status_grp.is_status_applicable
554: ( p_wms_installed,
555: NULL,
556: p_transaction_type_id,
557: NULL,

Line 578: AND inv_material_status_grp.is_status_applicable

574: WHERE organization_id = p_Organization_Id
575: AND subinventory_code = p_Subinventory_Code
576: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
577: AND concatenated_segments LIKE (p_concatenated_segments )
578: AND inv_material_status_grp.is_status_applicable
579: ( p_wms_installed,
580: NULL,
581: p_transaction_type_id,
582: NULL,

Line 609: AND inv_material_status_grp.is_status_applicable

605: AND a.inventory_location_id = b.secondary_locator
606: AND a.concatenated_segments like (p_concatenated_segments )
607: AND nvl(a.project_id,-1) = nvl(p_project_id, -1)
608: AND nvl(a.task_id, -1) = nvl(p_task_id, -1)
609: AND inv_material_status_grp.is_status_applicable
610: ( p_wms_installed,
611: NULL,
612: p_transaction_type_id,
613: NULL,

Line 636: AND inv_material_status_grp.is_status_applicable

632: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
633: AND concatenated_segments LIKE (p_concatenated_segments )
634: AND nvl(project_id,-1) = nvl(p_project_id, -1)
635: AND nvl(task_id, -1) = nvl(p_task_id, -1)
636: AND inv_material_status_grp.is_status_applicable
637: ( p_wms_installed,
638: NULL,
639: p_transaction_type_id,
640: NULL,