APPS.WMS_RULE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 392: ,MTL_SYSTEM_ITEMS msi

388: ,mil.TASK_ID TASK_ID
389: from MTL_ITEM_LOCATIONS mil
390: ,MTL_SECONDARY_INVENTORIES msei
391: ,MTL_PARAMETERS mp
392: ,MTL_SYSTEM_ITEMS msi
393: where nvl(msi.RESTRICT_SUBINVENTORIES_CODE,2) = 2
394: and nvl(msi.RESTRICT_LOCATORS_CODE,2) = 2
395: and mp.ORGANIZATION_ID = msi.ORGANIZATION_ID
396: and msei.ORGANIZATION_ID = msi.ORGANIZATION_ID

Line 419: ,MTL_SYSTEM_ITEMS msi

415: from MTL_ITEM_LOCATIONS mil
416: ,MTL_SECONDARY_INVENTORIES msei
417: ,MTL_ITEM_SUB_INVENTORIES misi
418: ,MTL_PARAMETERS mp
419: ,MTL_SYSTEM_ITEMS msi
420: where nvl(msi.RESTRICT_SUBINVENTORIES_CODE,2) = 1
421: and nvl(msi.RESTRICT_LOCATORS_CODE,2) = 2
422: and mp.ORGANIZATION_ID = msi.ORGANIZATION_ID
423: and misi.ORGANIZATION_ID = msi.ORGANIZATION_ID

Line 450: ,MTL_SYSTEM_ITEMS msi

446: ,MTL_SECONDARY_LOCATORS msl
447: ,MTL_SECONDARY_INVENTORIES msei
448: ,MTL_ITEM_SUB_INVENTORIES misi
449: ,MTL_PARAMETERS mp
450: ,MTL_SYSTEM_ITEMS msi
451: where nvl(msi.RESTRICT_SUBINVENTORIES_CODE,2) = 1
452: and nvl(msi.RESTRICT_LOCATORS_CODE,2) = 1
453: and mp.ORGANIZATION_ID = msi.ORGANIZATION_ID
454: and misi.ORGANIZATION_ID = msi.ORGANIZATION_ID

Line 1168: FROM mtl_units_of_measure muom, mtl_system_items msi

1164:
1165: -- find the uom class for the item's primary uom
1166: CURSOR c_primary_uom_class IS
1167: SELECT uom_class
1168: FROM mtl_units_of_measure muom, mtl_system_items msi
1169: WHERE msi.organization_id = p_organization_id
1170: AND msi.inventory_item_id = p_inventory_item_id
1171: AND muom.uom_code = msi.primary_uom_code;
1172:

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

2087: ,nvl(base.secondary_quantity,0) -- new
2088: ,base.grade_code, -- new
2089: ,NULL consist_string,
2090: ,NULL order_by_string';
2091: g_rule_from := ' mtl_system_items msi, ';
2092: g_rule_where :=
2093: ' and msi.ORGANIZATION_ID = mptdtv.FROM_ORGANIZATION_ID
2094: and msi.INVENTORY_ITEM_ID = mptdtv.inventory_item_id ';
2095: ELSE

Line 4290: FROM mtl_system_items

4286: CURSOR C_item_info IS
4287: SELECT lot_divisible_flag
4288: , lot_control_code
4289: , dual_uom_control
4290: FROM mtl_system_items
4291: WHERE organization_id = p_organization_id
4292: AND inventory_item_id = p_inventory_item_id;
4293:
4294: Cursor c_detailed_reservation IS

Line 6731: FROM mtl_system_items

6727: , lot_divisible_flag
6728: , lot_control_code
6729: , revision_qty_control_code
6730: , grade_control_flag
6731: FROM mtl_system_items
6732: WHERE organization_id = p_organization_id
6733: AND inventory_item_id = p_inventory_item_id;
6734:
6735: --cursor used to determine if the rule package exists

Line 15870: FROM mtl_system_items

15866: CURSOR l_cur_serial IS
15867: SELECT serial_number_control_code
15868: , NVL(restrict_subinventories_code, 2)
15869: , NVL(restrict_locators_code, 2)
15870: FROM mtl_system_items
15871: WHERE organization_id = p_organization_id
15872: AND inventory_item_id = p_inventory_item_id;
15873:
15874: --cursor used to determine if the rule package exists