APPS.WMS_RULE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 412: ,MTL_SYSTEM_ITEMS msi

408: ,mil.TASK_ID TASK_ID
409: from MTL_ITEM_LOCATIONS mil
410: ,MTL_SECONDARY_INVENTORIES msei
411: ,MTL_PARAMETERS mp
412: ,MTL_SYSTEM_ITEMS msi
413: where nvl(msi.RESTRICT_SUBINVENTORIES_CODE,2) = 2
414: and nvl(msi.RESTRICT_LOCATORS_CODE,2) = 2
415: and mp.ORGANIZATION_ID = msi.ORGANIZATION_ID
416: and msei.ORGANIZATION_ID = msi.ORGANIZATION_ID

Line 439: ,MTL_SYSTEM_ITEMS msi

435: from MTL_ITEM_LOCATIONS mil
436: ,MTL_SECONDARY_INVENTORIES msei
437: ,MTL_ITEM_SUB_INVENTORIES misi
438: ,MTL_PARAMETERS mp
439: ,MTL_SYSTEM_ITEMS msi
440: where nvl(msi.RESTRICT_SUBINVENTORIES_CODE,2) = 1
441: and nvl(msi.RESTRICT_LOCATORS_CODE,2) = 2
442: and mp.ORGANIZATION_ID = msi.ORGANIZATION_ID
443: and misi.ORGANIZATION_ID = msi.ORGANIZATION_ID

Line 470: ,MTL_SYSTEM_ITEMS msi

466: ,MTL_SECONDARY_LOCATORS msl
467: ,MTL_SECONDARY_INVENTORIES msei
468: ,MTL_ITEM_SUB_INVENTORIES misi
469: ,MTL_PARAMETERS mp
470: ,MTL_SYSTEM_ITEMS msi
471: where nvl(msi.RESTRICT_SUBINVENTORIES_CODE,2) = 1
472: and nvl(msi.RESTRICT_LOCATORS_CODE,2) = 1
473: and mp.ORGANIZATION_ID = msi.ORGANIZATION_ID
474: and misi.ORGANIZATION_ID = msi.ORGANIZATION_ID

Line 1251: FROM mtl_units_of_measure muom, mtl_system_items msi

1247:
1248: -- find the uom class for the item's primary uom
1249: CURSOR c_primary_uom_class IS
1250: SELECT uom_class
1251: FROM mtl_units_of_measure muom, mtl_system_items msi
1252: WHERE msi.organization_id = p_organization_id
1253: AND msi.inventory_item_id = p_inventory_item_id
1254: AND muom.uom_code = msi.primary_uom_code;
1255:

Line 2180: g_rule_from := ' mtl_system_items msi, ';

2176: ,nvl(base.secondary_quantity,0) -- new
2177: ,base.grade_code, -- new
2178: ,NULL consist_string,
2179: ,NULL order_by_string';
2180: g_rule_from := ' mtl_system_items msi, ';
2181: g_rule_where :=
2182: ' and msi.ORGANIZATION_ID = mptdtv.FROM_ORGANIZATION_ID
2183: and msi.INVENTORY_ITEM_ID = mptdtv.inventory_item_id ';
2184: ELSE