APPS.WMS_CONSOLIDATION_PUB dependencies on INV_MATERIAL_STATUS_GRP

Line 1928: AND inv_material_status_grp.is_status_applicable('Y',

1924: AND mil.organization_id = msi.organization_id
1925: AND Nvl(mil.inventory_location_type, 3) IN (g_loc_type_consolidation,
1926: g_loc_type_packing_station,
1927: g_loc_type_staging_lane)
1928: AND inv_material_status_grp.is_status_applicable('Y',
1929: NULL,
1930: 2,
1931: NULL,
1932: NULL,

Line 2019: AND inv_material_status_grp.is_status_applicable('Y',

2015: AND moqd.locator_id = mil.inventory_location_id
2016: AND moqd.organization_id = mil.organization_id
2017: AND moqd.lpn_id IS NULL
2018: )
2019: AND inv_material_status_grp.is_status_applicable('Y',
2020: NULL,
2021: 2,
2022: NULL,
2023: NULL,

Line 2073: AND inv_material_status_grp.is_status_applicable('Y',

2069: AND wlpn2.organization_id = mil.organization_id
2070: AND wlpn2.subinventory_code = mil.subinventory_code
2071: AND wlpn2.locator_id = mil.inventory_location_id
2072: )
2073: AND inv_material_status_grp.is_status_applicable('Y',
2074: NULL,
2075: 2,
2076: NULL,
2077: NULL,

Line 2153: AND inv_material_status_grp.is_status_applicable('Y',

2149: AND moqd.locator_id = mil.inventory_location_id
2150: AND moqd.organization_id = mil.organization_id
2151: AND moqd.lpn_id IS NULL
2152: )
2153: AND inv_material_status_grp.is_status_applicable('Y',
2154: NULL,
2155: 2,
2156: NULL,
2157: NULL,

Line 2207: AND inv_material_status_grp.is_status_applicable('Y',

2203: AND wlpn2.organization_id = mil.organization_id
2204: AND wlpn2.subinventory_code = mil.subinventory_code
2205: AND wlpn2.locator_id = mil.inventory_location_id
2206: )
2207: AND inv_material_status_grp.is_status_applicable('Y',
2208: NULL,
2209: 2,
2210: NULL,
2211: NULL,