APPS.WMS_CONSOLIDATION_PUB dependencies on INV_MATERIAL_STATUS_GRP

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

1929: AND mil.organization_id = msi.organization_id
1930: AND Nvl(mil.inventory_location_type, 3) IN (g_loc_type_consolidation,
1931: g_loc_type_packing_station,
1932: g_loc_type_staging_lane)
1933: AND inv_material_status_grp.is_status_applicable('Y',
1934: NULL,
1935: 2,
1936: NULL,
1937: NULL,

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

2020: AND moqd.locator_id = mil.inventory_location_id
2021: AND moqd.organization_id = mil.organization_id
2022: AND moqd.lpn_id IS NULL
2023: )
2024: AND inv_material_status_grp.is_status_applicable('Y',
2025: NULL,
2026: 2,
2027: NULL,
2028: NULL,

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

2074: AND wlpn2.organization_id = mil.organization_id
2075: AND wlpn2.subinventory_code = mil.subinventory_code
2076: AND wlpn2.locator_id = mil.inventory_location_id
2077: )
2078: AND inv_material_status_grp.is_status_applicable('Y',
2079: NULL,
2080: 2,
2081: NULL,
2082: NULL,

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

2154: AND moqd.locator_id = mil.inventory_location_id
2155: AND moqd.organization_id = mil.organization_id
2156: AND moqd.lpn_id IS NULL
2157: )
2158: AND inv_material_status_grp.is_status_applicable('Y',
2159: NULL,
2160: 2,
2161: NULL,
2162: NULL,

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

2208: AND wlpn2.organization_id = mil.organization_id
2209: AND wlpn2.subinventory_code = mil.subinventory_code
2210: AND wlpn2.locator_id = mil.inventory_location_id
2211: )
2212: AND inv_material_status_grp.is_status_applicable('Y',
2213: NULL,
2214: 2,
2215: NULL,
2216: NULL,